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 Cumulative New High/Low Line Pivot Point Breakout Scanner Number of Stocks Making a new 52-Week Low - Market Indicator Number of Stocks Making a new 52-Week High - Market Indicator New High	How-to Lessons How to download new quotes when selecting a chart How to automatically draw Fibonacci Retracement for each new stoc... How to create a correlation matrix of several securities How to display the number of stocks per day for different RSI gro... How to display the number of notes per stock
Related Forum Threads New Feature To Portfolio? camirila pivot point Saving Pivot Tables New User New to Quantshare. Futures quotes/data not automatically updatin...	Blog Posts How to predict and trade the stock market using pivot points What's new in this trading software? New features in QuantShare - Trading Software Trading software new features Pivot Tables in QuantShare Trading Software