Average Daily Return per Year/Month Table

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 calculated using the open and close prices (The intraday percentage change from open to close). A cell is colored in red when the average daily profit is negative and it is colored in green when the average daily profit is positive.

Above the table, you can change the active symbol to refresh the table.

You can also perform calculations based on the active trading chart (each time you change a chart or chart's symbol the table will be updated automatically):
- Right click on the pivot table
- Select "Active Symbol Settings"
- Select "Active Chart Symbol"

Note that to add this pivot table, you must first open or create a new dashboard (Tools -> Dashboard). After that, right click on the Dashboard to add the pivot table.

To update the analysis period, right click on the pivot table, select "Update Rows/Columns/Values", update the start and end dates in the "Select Dates" panel.

Technical Analysis

• watchlist2
• Weighted Linear Regression
• Scale-In On Price Drop
• InSync Index - Consensus Trading Indicator
• Covered Call Screener
• Cumulative Sum of a Technical Indicator
• RSI3 Box v001b 2014-02-14
• How far are the close prices from the support line
• SafeZone Stop
• PIPS conversion formula in Forex trading
• More trading objects...

Fundamental Analysis

• Real Disposable Personal Income
• Media sentiment alerts
• Stock Market Capitalization
• S&P Earnings
• Industry Relative Strength
• Historical Earnings Surprise, EPS and Consensus Data
• NASDAQ and Boston stock exchanges - Daily short sale data
• Real Gross Domestic Product - Historical data
• Commitments of Traders
• Valuation ratios for US stocks
• More trading objects...