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

• Trading System based on the Previous Week SPY Return
• AccuTrack Indicator
• Center of Gravity
• Basic in-Sample/out-of-sample trading technique
• MSCI China Markets Indices
• Adaptive Strategy Indicator
• Maximum Drawdown Indicator
• Flexible Asset Allocation Model V1.0
• mov avrages
• Murrey Math Lines Indicator
• More trading objects...

Fundamental Analysis

• Earnings Surprise Strategy
• US Stocks: Size & Share Volume
• Historical Earnings Calendar Data for U.S. Stocks - Date/Time and EPS
• Income Statement & Growth
• Update the Stock Exchange Associated With U.S. Stocks - Market Field
• Roubini Sentiment Indicator
• Industry Relative Strength
• Industry Equity
• M2 money supply
• Earnings database
• More trading objects...