Excel Strategy Dashboard
Introducing the Excel Strategy Dashboard
Elevate your trading with the perfect tool to maximize your profits and minimize your losses in the stock market.
The Excel Strategy Dashboard is an innovative, user-friendly tool designed to help you build profitable trading strategies in minutes. With its powerful data analysis, backtesting capabilities, and intuitive interface, you can take control of your financial future and maximize your chances of success in any market.
Key Features:
- Powerful data analysis and backtesting capabilities
- Intuitive user interface for easy strategy building
- Confidence-boosting backtesting simulations
- Built-in scorecards, analysis suggestions, and strategy rating tools
The Excel Strategy Dashboard gives you the confidence to trade with conviction, providing invaluable insights into what works and what needs improvement. Excel Macro 'Magic' allows you to import your data with a single click, with macros formatting your data automatically. Empower your trading with algorithmic-assisted investing by 'Farsight' and proven backtested results with the 'Excel Strategy Backtesting Tool'—the perfect combination for success.
Note:
- Requires Excel and the ability to enable Macros
- Can be used without Macros enabled, but manual data formatting will be necessary
What Does it Do?
**Excel Trading Analysis Tool Features**
**Data Import and Formatting:**
- Easily imports and automatically formats data exported from Thinkorswim into Excel using macro buttons.
- Supports importing stocks, futures, forex, etc.**Trade Analysis:**
- Breaks down trade totals by winners and losers, showing the percentage of each.
- Plots the top 20 winning and losing trades, and totals each.
- Plots trade PnL and account value over time.
- Plots stock price over time.
- Shows strategy gains.
- Itemizes strategy gains based on net gains, gains minus slippage, and gains minus commissions and slippage.**Customization and Insights:**
- Allows users to set the commission trade round trip price and the estimated slippage amount.
- Plots and sums all trades over a 24-hour period graph, indicating the most and least profitable hours.
- Allows users to input a starting investment amount.
- Compares starting investment amount to PnL to calculate ROI%.**Period and Strategy Details:**
- Displays the number of days in the trading period and the start and end dates.
- Includes a strategy notes section for comments and useful observations.
- Features a strategy rating tool that rates the strategy from 0-100 points and a 5-star rating based on 8 different criteria.**Profit and Analysis:**
- Provides a profit factor section that compares the average win $ vs. the average loss $, finding the ratio between the two (e.g., a profit factor of 1 is a 1:1 risk-to-reward ratio, while a profit factor of 2 is a 2:1 risk-to-reward ratio).
- Includes an enhanced analysis section that breaks down the point score used for the rating tool, offering a quick snapshot/explanation of where the strategy is lacking and where it excels. Scores are color-coded based on conditional formatting and the point score.**Documentation and Performance:**
- Has a section to post screenshots of the strategy being used and document the settings for later use.
- Displays max account drawdown and max account loss.
- Allows users to input the name of the underlying asset being analyzed.