5 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 excel options trading system tables 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 beginning 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 excel options trading system tables.
Let me suggest you this: To see the actual performance IN the pivot table, just add a calculated field from the menu: Yes, you are right! This is much better than duplicating the table. I will update this post asap. Found this site http: You 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. Excel options trading system tables Grau November 7, Leave a Reply Cancel reply Enter your comment here Fill in excel options trading system tables details excel options trading system tables or click an icon to log in: Email required Address never made public.