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

• Swing Index Indicator
• Put Call Volume Comparison Indicator
• How far are the close prices from the support line
• Center Of Gravity - COG
• Damping index
• Moving Average Relative Strength Index (RSI)
• Sector Surfer AMM Model
• NYSE Index Closes
• VIDYA - Variable Index Dynamic Average
• Positive trend breakout list (SMA100-based)
• More trading objects...

Fundamental Analysis

• Historical Economic Events
• Super Stock Screener Ranking System
• Yahoo News
• NSE Board Meetings
• NSE - Short Selling
• Penny Stock News Picks
• Earnings Surprise Strategy
• Insiders' Blog stories
• iShares Exchange-Traded Funds - ETF Fees and Expenses
• Bankruptcy Filings
• More trading objects...