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

Re: [Metastockusers] importing Data from Excel into Metastock

PureBytes Links

Trading Reference Links
Dear All
 
I have been importing a daily Excel file into the Metastock format for many years using a copy of Textoms which is downloadable from http://www.worldlynx.net/pgerhart/.
 
The software is really excellent and is inexpensive.
 
Regards
 
 
Mike Simmons
 
 
 
----- Original Message -----
From: Guss
Sent: Friday, October 22, 2004 4:55 PM
Subject: Re: [Metastockusers] importing Data from Excel into Metastock

Tom,
Once again thanks for the informative email, will look into it and see what I can do.
 
Regards,
Guss
----- Original Message -----
Sent: Friday, October 22, 2004 11:20
Subject: Re: [Metastockusers] importing Data from Excel into Metastock

You should look into an Excel VBA (Visual Basic ) macro that will automatically pull the data and put it into an Excel file(s) in the right format.
The reason you can't copy and paste directly from the website to the downloader is that on the web page the data is in HTML format.  The Downloader will not accept HTML.  Once it gets put into Excel it is changed to Excel format which the Downloader will accept.
 
Then, you can play around and either copy and paste or perhaps use the downloader to convert.
 
There is a Yahoo Group called XL Traders.  They do all kinds of stuff like that there.  You might join and do a search for finding a macro that does something close to what you are doing. I've seen a bunch that pull data from web sites into Excel. Can't remember seeing one that then puts it into Metastock, but there could be.
 
Tom
----- Original Message -----
From: Guss
Sent: Friday, October 22, 2004 10:04 AM
Subject: Re: [Metastockusers] importing Data from Excel into Metastock

Tom,
Thanks for your help, I really appreciate it.
The problem is that,  I copy the data from a web site, and I am unable to copy/paste it  directly in the downloader for some reason.
so I end up entering the data manually in the downloader file  rather than pasting it in excel then converting it again using downloader.
but since I need to update about 20 securities on daily bases, I am trying to find an easier way to do it by just either copying it  from the site and pasting it in downloader file , or by using some kind of link between the two if it is possible.
any help would be appreciated
 
Thanks
Regards
Guss
 
----- Original Message -----
Sent: Friday, October 22, 2004 10:16
Subject: Re: [Metastockusers] importing Data from Excel into Metastock

If you only have one or so files, I find it easier to just cut and paste instead of using the downloader and all the conversion stuff.
 
You do use the downloader to create the security.  Input the name and symbol manually.  Often I want to graph something that has no symbol, for example, my personal equity curve that is maintained in Excel.  So I make one up that I know won't be recognized by the the data provider.  For example if you are using Reuters, all the indexes start with a "."  so put a "$" in front of your made up symbol.  You do this to make sure when you run the downloader it won't accidently retrieve new data.
 
You then make sure that the Excel file is in the format below and that the oldest date is at the top of the file.  Then  in the downloader open up your symbol.  It won't have any data.  Then highlight the data in in Excel, and hit "copy".  Switch to downloader and place the cursor at the top of the file in the left hand corner in row 1 and hit "paste".  Voila! Now the data is in place.  You then have to save and close that file on the Downloader.  T
 
Then just open up the new dummy security in Metastock and view the graph, add indicators, whatever.
 
By the way the copy and paste works the other way as well.  If you want to pull data from the Downloader and put it into Excel for additional analysis, just do the reverse and paste it into Excel.
 
Tom
----- Original Message -----
Sent: Friday, October 22, 2004 9:05 AM
Subject: Re: [Metastockusers] importing Data from Excel into Metastock

I used to get into a tangle when trying this in the initial stages. As the Help says -

 

To convert from Excel file to Metastock you need to do the following-

  1. The data must be in columns.
  2. Each column must have a heading that describes what data is in the column.  The only required columns are DATE and CLOSE.  Optional columns are TICKER, PER, OPEN, HIGH, LOW, VOLUME, and O/I.  The column names must be spelled as shown here.  The column headings must all be on the same row.
  3. The dates must be in the mm/dd/yy style and must be formatted as text labels

 

 

……to add to the above

 

1)     My source Excel files have the following

TICKER

DATE

OPEN

HIGH

LOW

CLOSE

VOLUME

O/I

2)     Make sure the DATE is in TEXT format.

3)     The TICKER cell is also  in TEXT format in my source file.

4)     Different  TICKER or SYMBOL needs to be a separate Excel source file

5)     The TICKER or SYMBOL should match your destination file

6)     My set of Excel files are in one folder and the destination or Metastock files are in another folder

7)     In the downloader choose TOOLs choose CONVERT

8)     In source file type choose EXCEL, specify  the folder,  Click  on Browse.

9)     Highlight the source files then click OPEN.

10) Now go to the Destination section choose Metastock, then indicate the folder. Click BROWSE . all the files in the folder will be shown, click SAVE.

11) You come back to the CONVERT screen. Go to the OPTIONS  and make the appropriate entries.(You could increase the max error msgs to 10,000 since the data conversion stops when the Max amount is reached – the data after conversion seems fine in spite of error msgs ! ) Click the OK button for the conversion to take place.

 

 

I download my EOD as a Excel file. Using a macro each symbol is saved in a different Excel file, I update the MS data through the above process.

 

Hope this helps !

 

PS - the source file is used for charting by MS



Guss <nasdaq@xxxxxxxxx> wrote:
Dear all,
 
I have some Data in excel format (open,high, Low,close) columns, that I would like to import into Metastock as a chart.
Is that possible? if yes, how can I do that
 
Thanks in advance
Regards,
Guss

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com





Yahoo! Groups Sponsor
ADVERTISEMENT
click here

Yahoo! Groups Links