Greetings, and welcome to TraderArchive.
TraderArchive is dedicated to supporting traders on their journey. Whether there are questions about the backtesting spreadsheets or a desire to learn more about how these tools can optimize trading strategies, assistance is always available. Proposals for potential partnerships and collaborations are also welcomed.
Engagement is greatly appreciated as efforts are continually made to improve the experience with the products.
For any inquiries, feel free to use the contact form below. Responses are typically provided within 24-48 hours.
TraderArchive, LLC. 400 Rella Blvd #207-298 Montebello, NY 10901, support@traderarchive.com
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.