[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Metastockusers] Import from Excel



PureBytes Links

Trading Reference Links

> Can anyone tell me how I can import a list of stocks from Excel into
> Metastock fovourites

Once you are done with your sorting/filtering or whatever you want to do to
create your final list, delete all Excel columns to the right of the symbols
and any headers in Col A.  All symbols should now be in Col A.  Then select
File, Save As.  In the drop down box below, select the file type as .PRN.
Save the file (name) to the C:\Programs\Metastock\The Downloader directory.
Then find the file using Windows Explorer, right click on the .PRN file and
select RENAME.  Change the .PRN to .SYM.

Open the Downloader, click on file, new. security and you'll get that new
security box.. click on Look Up and you'll find your newly created file
(with *sym) in the Type Box, highlight your file and the stocks that are in
it will appear below, click selct all and then do your thing.  This will
create empty symbol files in the Local Directory of your choice.  Then run
the Downloader to fetch the historical data.


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/zMEolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/