HOW TO SET UP AnalyzerXL FOR EXPORTING ASCII DATA

STEP 1

Open EXCEL. Click on "BulkQuotesXL" ---> "New Download Project". You will see something similar to the following screen.



STEP 2

Click on the date in Row 2 under "Start Date". You will see a screen similar to the following:



Change the number "60" in the "=TODAY()-60" entry field to the number of days of data you want to download. There are about 250 trading days in a year.

STEP 3

Delete the "V" and the ";" in the entry field. We do not use Volume and do not want to download it.



STEP 4

In this step we will add the macro so that AnalyzerXL will automatically download our data in the proper format to the hard disk.



In the entry field type the following: ExportData("Metastock","C:\MyDirectoryName")

You have to replace MyDirectoryName with the actual name of the directory you will use for the data downloads. This must be an existing directory. The macro will not create the directory for you.

STEP 5

In Column A you will add the ticker symbols for the tickers you want to download. You can get the list of acceptable ticker symbols for international stocks and continuous futures data at BulkQuotesXL



If the data source is not the default then you must manually add the source to Column H.

THE FINAL RESULT should look very similar to the following:



STEP 6

SAVE the spreadsheet file. For future downloads OPEN the spreadsheet. Click on "BulkQuotesXL"--->"UpDate Data"

The data will be automatically collected and saved in the proper format to your hard disk. There is no user intervention.

 

HOME