|
Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object
The current pivot table displays the number of increases (today's close higher than yesterday's close) for each month and for each year for the SPY.
You can update the pivot table to display data for any indicator you want, you can also select the "Values" field, click on the "Symbols" tab...
No notes
|
Pivot Table
Medium
|
| |
This pivot table displays the number of stocks for each industry.
Each industry is displayed in a row and a second column "Count" would display the number of stocks that belong to each industry.
You would need to update the industry field of each stock first. You can let QuantShare do that...
No notes
|
Pivot Table
Medium
|
| |
This pivot table will show you how a stock or an asset would have performed intraday depending on two factors, which are the day of the week and the previous intraday return. By intraday, I mean here the open-to-close return and not the yesterday's close to today's close return.
The pivot...
No notes
|
Pivot Table
Advanced
|
| |
The following pivot table would allow you to easily display the year-to-date performance of your assets or ETFs and track their excess return with a benchmark or index.
By default, the following ETFs are compared to the SPY (S&P 500 ETF)
DIA: SPDR Dow Jones Industrial Average ETF
IEF: iShares Barclays 7-10 Year...
No notes
|
Pivot Table
Basic
|
| |
Using the pivot table tool of QuantShare, I have created a table that shows the average daily return of a security per month and per year. The table displays years as rows and months as columns and calculates the average daily return for every cell (year/month). The daily return is...
No notes
|
Pivot Table
Medium
|
| |
Standard deviation is often used as a measure to estimate future moves of an asset such as a stock (volatility). Although, price changes do not have a normal distribution, some technical analysts assume that it is the case and use this assumption to predict future price move. If the price...
No notes
|
Pivot Table
Medium
|
| |
The following Forex correlation trading item creates a correlation matrix between several currency pairs.
Correlation is a statistical measure of the relationship between two securities. It tells us whether two currency pairs are moving in the same, opposite or random direction.
Correlation values vary between -100% (Forex pairs move in the same...
No notes
|
Pivot Table
Medium
|
| |
The VIX symbol stands for the Chicago Board Options Exchange Volatility Index and it is a measure of the S&P500 stock index options that have a maturity of 30 days. In other words, it measures the expected market volatility for the next 30 days and this is why it is...
No notes
|
Pivot Table
Medium
|
| |
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...
No notes
|
Pivot Table
Medium
|
| |
0 |