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

• Stock Ranking using Rate of Change and SMA Volume
• Short to Long-Term Volatility Indicator based on High/Low Trading Data
• Correlation To Portfolio
• Transform Double To Comma Separated Representation
• RSI GT 2%
• Consecutive Up and Down Bars - Works With Any Trading Indicator
• CBOE Options Advance Decline
• Buy signal watchlist And Buy signal on your Chart (Red Spot)
• Swiss Army Knife Indicator - SWAK
• Equity Put-Call Ratio
• More trading objects...

Fundamental Analysis

• Industrial Production Index - IPI - Historical data
• Stock Grade - Fundamental Analysis
• Economic Calendar
• Detect and Display Potential Splits on a Chart
• Smartmoney news for US equities
• SocialPicks Analysis
• Recent mergers and acquisitions
• NSE - Short Selling
• Dow Jones U.S. Technology Sector Index Fund survivorship bias-free database downloader
• Historical Stock Market News
• More trading objects...