This is a trading item or a component that was created using QuantShare by one of our members.
This item can be downloaded and used by QuantShare Trading Software.
Trading items are of different types. There are data downloaders, trading indicators, trading systems, watchlists, composites/indices...
You can use this item and hundreds of others for free by downloading QuantShare.
Top Reasons Why You Should Use QuantShare:
Works with US and international markets (stock, forex, options, futures, ETF...)
Offers you the tools that will help you become a profitable trader
Allows you to implement any trading ideas
Exchange items and ideas with other QuantShare users
Our support team is very responsive and will answer any of your questions
We will implement any features you suggest
Very low price and much more features than the majority of other trading software
The current pivot table returns the average 10-Bar stock performance for each U.S. Exchange (NYSE, NASD, NYSE and OTC). It also returns, in another column, the number of stocks in each one of the previous exchanges. The 10-Bar return calculation is performed using the "perf" trading indicator and it is based on the last global date.
As I said, the table contains two columns. The "10D Return" uses the "Average" calculation method, while the "Number of stocks" column uses the "Sum" method. Stocks are grouped using the "market()" function, a function that returns the market/exchange where the stock is listed.
As you may have guessed, this pivot table can work with any market. All you have to do is make sure that the market field of each stock is properly set, then you should update the limits field values of the pivot table.
Here is how to update the limits field:
- Right click on the pivot table
- Click on "Update Rows/Columns/Values"
- Select "Formula" under the "Rows" list
- Select "Indicator Limits" tab
- Under "Limits" pane, change "AMEX;NASD;NYSE;OTC" with your own list of exchanges
It is also possible to calculate the average performance or return for each sector, industry or index, by setting "industry()", "sector()" or "index()" formula instead of "market()". You also need to set the different sectors, industries or indices (or at least few ones) in the "Limits" field.
Here is how the pivot table looks like. This example uses only a subset of U.S. stocks:
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.
