How to Make (and Lose) $2,000,000 Day Trading: The System & The Story
4 stars based on
The pivot table tool is great for inspection, filtering and analyzing large data sets. In this article, I will present how to create a simple timing-based strategy and how to compute its historical performance. In the following, I will show, how to create an analysis like the previous post: First, we need to get the data for the analysis. But, it is easy to guess the correct Link:. Historical Dow-Jones Index daily from Save this file to disk.
Then, open it with MS Excel and we continue with the next step. Then, we add the indicator of the trading strategy — in this case just the month of the year:. The sum of the log returns in the pivot table is a good indication for the performance of a trading strategy. But, the acutal performance can easily be obtained from the log-returns by:.
Now, you are ready: Each cell contains the performance of buying the Dow-Jones Index at the excel options trading system tables and selling it at the end of each months. Have fun with your own studies! You find a detailed study about the performances of the different months in the main indices here. Back-testing of simple trading strategies is easy using Excel pivot tables. While more advanced strategies usually require a more specialized software package as we see in MACD Back-testingfive simple steps lead to in-depths insights of a timing based strategy.
Let me suggest excel options trading system tables this: To see the actual performance IN the pivot table, just add a calculated field from the menu: Yes, you are right! This excel options trading system tables much better than duplicating the table. I will update this post asap. Found this site http: Excel options trading system tables are commenting using your WordPress.
You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. Obtain the data First, we need to get the data for the analysis. But, it is easy to guess the correct Link: Then, we add the indicator of the trading strategy — in this case just the month of the year: Finally, we add a group indicator: Sort Data in Table.
Christophe November 7, Im glad to land on this blog. Andreas Grau November 7, Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in: Email required Address never made public.