Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Gold/Mining/Energy : Daytrading Canadian stocks in Realtime -- Ignore unavailable to you. Want to Upgrade?

To: John Hunt who wrote (5003)	3/28/1999 12:23:00 PM
From: keith massey	Read Replies (1) \| Respond to of 62347

The problem with CSW is that they don't provide historical data. The data you got with Metastock is not compatible because the volume is divided by 100. This means if you merge CSW data with Metastock data it will appear that the volume is 100 times less before the merge date. If you want a database of all Canadian stocks be prepared to spend 12-14 hours of mindless work. It is not worth the time to download and break-up the U.S data and I would suggest using QP2 for U.S stocks. The reason I went with CSW as a provider is not because I was cheap but because every other Canadian provider I tried was horribly. The only one I didn't try was Reuters which may be O.K but it cost $400/year for data. CSW is FREE. I downloaded each individual file for 4 years one at a time. Because they charge you .20 a file you can only download so many with your daily account ($20 or $50 a day free downloads). I had a friend's account and my account which gave me $70/day or 350files/day so I got it done fairly fast (8-9hrs). The big flaw with metastock is that you can only have 2000 files in each folder. This means you need to download each TSE,ASE and VSE file separately. I only did the TSE and VSE. 1. Go to Historical company stock prices 2. Type in the first data 3. Do not include options/future or files will be greater than 2000 and your system will bug out. If you want to look at options/futures you can download them later as separate files. 4. For TSE stocks: Highlight - Click T, Metastock with open Destination: File on hard disk Highlight: Generate one carriage return AND Leave blank 3. When you save the file name it so they list in alphabetical order and you can figure out the data. E.G in named files A021096.txt, B031297.txt, C110598.txt, etc, etc. This just makes life easier later. (NOTE: make sure you give files the .txt extension) After you get all the files downloaded (if you dare) than give me a ring. It is a tricky task get all the files into a working database but I think I have worked the bugs out of the procedure. If you want to try it out for an individual stocks. 1. Type in symbol Click all the dates you want. You can't leave out newer dates unless you want some fried charts. Highlight - Metastock with open Destination: File on hard disk Highlight: Generate one carriage return AND Leave blank Download the file with the name of the symbol and the txt extension into any folder you want. E.G ABX.txt in the TEMP directory Make a new folder on your harddrive where metastock data is going to be stored Go to the download and click on the convert function. Click on TXT file conversion and bring up the ABX.txt file. In the bottom window bring up the folder you created to store files. Click convert. You should now be able to go to Metastock and see the file. P.S Once you have the entire database up and running it takes around 1-2 minutes to update you database daily. Best Regards KEITH