Click here to Login

                                                   PIVOT TABLES-a new feature


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

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


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
SBI 1% _ STEEL -2%

2010-11-02 13:59:56

I am not sure I understand exactly what you need.

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

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.

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.

No more messages


No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"


Trading Items
Cumulative New High/Low Line
Is New Bar
Percentage of Stocks Trading Above their Pivot Point
Pivot Point Breakout Scanner
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
Backup and move entire QS to new computer

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
QuantShare Trading Software: New Features in the 3.4.2 Version
QuantShare Trading Software: New Features in the 3.1.2 Version

Create an account
Affiliate Program
Contact Us
Trading Forum
How-to Lessons
About Us
Terms of Use

Copyright 2021
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Follow us on Google+
RSS Trading Items

Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.