Greetings, and welcome to TraderArchive.
We’re here to support you on your trading journey. Whether you have questions about our backtesting spreadsheets or want to learn more about how we can help optimize your strategies, we’re happy to assist. We also welcome any proposals for potential partnerships and collaborations.
Your engagement is greatly appreciated as we continually work to improve your experience with our products.
If you have any inquiries, please feel free to reach out using the contact form below. We strive to respond to all messages within 24-48 hours.
Frequently Asked Questions
Find answers to common questions about our backtesting spreadsheets and how to use them.
What do I need to use these backtesting spreadsheets?
You only need Microsoft Excel (version 2021 or newer) and historical price data for the instrument you want to test.
How do I get the historical price data?
You can download historical price data from most trading platforms or financial websites. Investing.com or Yahoo Finance provide free historical price data in 1D time frame for various instruments. For intraday historical price data, consider using FirstRate Data or EODHD APIs.
How good should my knowledge of Excel be?
Basic knowledge is sufficient, such as understanding how to copy and paste data into a spreadsheet and edit cells. Our spreadsheets have a user-friendly interface with lots of prompts for users of any level.
What types of instruments can be used with these spreadsheets?
You can use these spreadsheets for any instrument for which historical data is available. This includes stocks, ETFs, indices, forex, commodities, and cryptocurrencies.
What are the hardware requirements?
A PC or laptop is required as Microsoft Excel provides all the necessary features only for these versions. The minimal system requirements are Windows 11 or Windows 10 for PC, Mac OS for Mac, and 4GB RAM, but for optimal performance, 8GB RAM or more is recommended, along with a modern processor.
How long does the optimization take?
A PC or laptop with a modern processor and 16GB RAM typically processes the optimization of 1000 indicator parameter combinations using 20,000 historical price data points in about 2 hours. Older computers may take more time, but modern computers with more RAM can complete the task in less time.
What should I do if the spreadsheet is slow and the optimization takes too much time?
If your computer has low computational power, consider reducing the number of historical data points to 10,000 or even 5,000. This will significantly improve the processing speed of the spreadsheet without sacrificing too much accuracy in your optimization. Additionally, closing unnecessary programs and increasing your computer’s available memory by freeing up RAM can further enhance performance.
Can I edit these spreadsheets?
Yes, all our backtesting spreadsheets are fully editable and transparent. If you are an experienced Excel user, you can create your own backtesting spreadsheet with your unique strategy using our spreadsheets as a template.