In this blog post, I’ll show you how to use this custom trade compiler to speed up your compiling process by over 100 times. I’ll walk you through the step-by-step process of using the compiler and provide tips on how to maximize its benefits. By the end of this post, you’ll be ready to start compiling your trades lightning-fast. So let’s get started!
This way you can compile the big batches of data lightning fast. And then use the MAIN sheets compiler only for small batches, like weekly trades or separate days.
All of the process is very similar to the Main Workbooks process. 1st you import a CSV file, 2nd run compiling, 3rd prepare the data for next import if necessary, 4th import the next batch of trades, 5th compile again, 6th if you got another batch waiting, Prepare it again. And finally copy the trades to the MAIN Workbook.
Click Ok to replace data
Enter the row number. On the first compiling you enter number 2. Later you will need to choose last closed row. Will explain a bit lower.
Now it will do its Thang and you will receive a pop up message that compiling is finished.
Go to DATA sheet and take a note of the last closed row with data.
Import the next batch of trades
Run the compiler again
Now when it asks to enter the row number, we enter the number of the last closed row. In my case its 963, you will have a different one.
I have finished importing the CSV files so we can move the data to the MAIN Workbook
You should delete the data if you are opening the workbook for the first time. As there will be some dummy data.
You must keep both workbooks open to complete this step. For Compiling and InteractiveBrokersShortEnabled must be open.
It will do its Thang again
This button will Integrate all of the data imported with the formulas and formatting
It should bring you to the MAIN dashboard, and the only thing left to do is hit that Refresh button
Now when all of the big bathes of trades are imported, we can use the InteractiveBrokersShortEnabled Workbooks integrated compiler for next smaller imports.
Its the same process. Hit the Prepare button, take a note of the last closed row number. Import the CSV file. And click the Web trades button.