Dynamic Charts in Excel - Forex Tester Example (Part 3/3)
Find more about Excel Forex Tester and download the program to use it and see the code here: https://excelmacrobusiness.blogspot.c...
Check this other page to read more about the difference between my Excel version of a Forex testing simulator, and one of the top Forex backtesting software in the market here: https://excelmacrobusiness.blogspot.c...
In the first video (Part 1/3) we created a dynamic chart in Excel to show historic Forex data of EUR/USD closing prices that allows to scroll through the data and zoom in/out the view. That's all possible adding some formulas to the chart data range via defined names, so no macros are needed. In the previous video (Part 2/3) we used macros to add more functionality to the dynamic chart - change axes scale automatically and show/hide series through check box. In this video (Part 3/3) we use macros to load data and make the chart move accordingly, as it is done in Forex backtesting and in the way Excel Forex Tester actually works.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: https://excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)
![Star Citizen - Making Money with an Aurora [GIVEAWAY]](https://images.videosashka.com/watch/o7JyUhfZ3Wo)
