Average Open-to-Close Return per Day of Week

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 table will display the day of week as rows and the previous day's performance thresholds as columns. There are four thresholds:
down-: Yesterday's intraday return is below -1%
down: Yesterday's intraday return is below 0%
up: Yesterday's intraday return is above or equal to 0%
up+: Yesterday's intraday return is above +1%


Here is an example of what the pivot table would look like:




At the top of the table you can type the symbol you want to analyze and the table will re-calculate automatically showing you the data of that selected symbol.
The table has "%PL" columns that display the average intraday return as well as "Count" columns that display the number of occurrences for a specific "day of week / up-down" pair.

To add a pivot table in a dashboard, open or create a new dashboard first by selecting "Tools" then "Dashboard". Once done, right click on the dashboard then select "Open Pivot Table".

Note 1:
Positive PLs are shown in green, negative PLs are shown in red and high PLs (> 0.5%) in blue.
You can update that and add more color conditions by right clicking on the pivot table then selecting "Update Table Settings".

Note 2:
The calculation is based on the past 10 years data (if available) of the selected stock or asset.

Technical Analysis

• Gap Up/Down Market Breadh Indicator
• FirstTradingDOM
• High to low stock pattern for the close price
• Volatility Ratio - Technical Indicator
• Swiss Army Knife Indicator - SWAK
• Relative Vigor Index - Signal Line
• Coppock Indicator
• RSI methodology with profit/trade GT 0%
• TFS Tether Line
• 10-bar moving average return for S&P 500 stocks
• More trading objects...

Fundamental Analysis

• Yahoo News
• Ivey PMI Index - Canada
• Industry Relative Strength
• Tweet Sentiment Index for the Forex and Stock Market
• Splits Calendar - Historical data for U.S. Stocks
• M2 money supply
• NASDAQ and Boston stock exchanges - Daily short sale data
• Economic Data - Retail Trade Report
• NYSE - Corporate Actions
• Economic Calendar
• More trading objects...