Itâ€™s no secret that I use TraderXL Pro to download the majority of my Stock, Future, and Forex data that I use for RapidMiner modeling. I use the BulkquotesXL module because itâ€™s able to download daily and weekly data from Yahoo and daily price data from the PiFin data source. Usually it downloads the data into separate tabs in your spreadsheet, which is nice but a pain to manipulate if you want to create a summary sheet to load into RapidMiner.
Have no fear, TraderXL Pro has a built in macro called â€œTickerHeaderâ€ that you can run automatically as you download your data into a nice summary sheet. This macro will runs automatically for each asset symbol you list and place it into a data column. The next symbol will be placed in the following column and so forth. You can download my template her: TickerHeader Macro Template
This should cut down, considerably, your data downloading process and get you modeling sooner!
However, if you want to build my spreadsheet from scratch, you have go through the following steps below and set a few parameters in the BulkquotesXL:
Step 1 â€“ Create a new project
Step 2 â€“ Enter your asset symbols into column A (see my example spreadsheet)
Step 3 â€“ Enter the data range to download (columns B and C)
Step 4 â€“ Select the period to daily (column D)
Step 5 â€“ Enter the word â€œSummaryâ€ in column F
Step 6 â€“ Enter the values "A1", "C1", "D1"â€¦ (Without the " ". Why you skip B1 will become clear as you read further along)
Step 7 â€“ Set your data source (Yahoo or PiFin). If your downloading data from more than one data source, you have to enter its name in each row.
Step 8 â€“ in the Data Field column enter â€œCâ€ for close but in cell I3 enter â€œD;Câ€. This will place the Date field of the downloaded asset in A1 and then the closing price in B1.
Step 9 â€“ Enter â€œTickerHeaderâ€ into the Autorun Macro column J.
Then click Download/Refresh Data and your done! The TickerHeader macro comes stock with BulkquotesXL module and has made my data downloading life a lot easier.
As always, if you have questions please leave me a comment or email me via my contact page. On your way out, please subscribe to my feed!
From around the Social Web!
Want to leave a comment?
If you want to give me some feedback on this post, please contact me
via email or on Twitter