PIVOT TABLES-a new feature - Trading Software

PIVOT TABLES-a new feature

Gilari Decosta
2010-11-02 12:52:07

Sir,
Pivot tables are very useful.
Now let me suggest another feature with Pivot table.

If the pivot table can be opened as QUARY WINDOW as in data basis application, It will be able to retrieve
very useful information of current symbol as shown in attached file .These information are very vital for informed decision

GILARI

Price Change for N bars
Symbol CUB 2%
INDUSTRY BANK 4% (here the composite index change may be added)

List of Members of Bank Industry price change List of other Composites price change
ICICI -3% _ PHARMA 7%
PNB 4% _REALITY 3%
SBI 1% _ STEEL -2%

QuantShare
2010-11-02 13:59:56

I am not sure I understand exactly what you need.

Gilari Decosta
2010-11-02 14:24:29

Sir
When we study chart of symbol,we may wish to know to which sector it belong.It can be retrieved from data base using sql quary.Suppose we have already made composite index of all sectors ,then we can attach a "_" in front of sector name that we have already retrieved (ie, _bank) and retrieve last price change for same.
Now we have price change of symbol and the sector it belong to.
Suppose we want to know how other members of this industry are performing now ,
then a list of other members of of industry with the price change will provide it.
Pivot table is now like excel sheet.But if it can be opened like QUERY AS IN MICROSOFT ACCESS QUARY.All these feature can be implemented using SQL queris.
thanks
GILARI
.

QuantShare
2010-11-03 05:40:30

We are creating a tool that is more like excel that will allow you to perform this. You will be able to edit individual cells with QS or .Net functions.
This tool will be released with the real-time version.

Get more messages

No more messages

Back


Trading Items Dave's New System - DNS Lunar Phase Indicator - New and Full Moon Cycles Is New Bar Percentage of Stocks Trading Above their Pivot Point Number of Stocks Making a new 52-Week Low - Market Indicator	How-to Lessons How to download new quotes when selecting a chart How to automatically draw Fibonacci Retracement for each new stoc... How to quickly add a ticker symbol How to install the previous version of QuantShare How to create a correlation matrix of several securities
Related Forum Threads New Feature To Portfolio? New Group feature - and teaser.. QuantShare Trading Software: New Version 2.9.2 pivot tables Saving Pivot Tables	Blog Posts How to use the new Market Regimes Feature in QuantShare Trading S... What's new in this trading software? QuantShare Trading Software: New Features in the 3.4.3 Version How to Display the Year-to-Date Excess Return in a Pivot Table QuantShare New Website Feature: Groups