Re: [EquisMetaStock Group] Metastock to Spreadsheet ?

[JayTownsend@xxxxxxx]

You cannot reply to this message via email because you have chosen not
to disclose your email address to the group.  Please use this
page to reply.
 



<<I have a series of 1 minute charts saved using various indicators 
including the Renko indicator. Is it possible to send this data 
including the indicator value to an Excel spreadsheet? If so ? How?


Thanks>>

Open up Excel to a "new" or blank page.  With Excel open, go to your MetaStock chart.  Left click on one of the data bars which will select it.  (You can tell that it has been selected by the little black boxes that are displayed on some of the bars.)  Do a <ctrl> <c> (copy) which will move the data to the clipboard.  Then move to Excel, place your mouse in the cell where you wish to begin your copy, and then do a <ctrl> <v> (paste) at that point.  You will than have columns with titles and data for: date, open, high, low, close, volume and in the case of futures, open interest.  I am not familiar will the Renko indicator as I have MS EOD, but to copy any indicator from a MS chart, do the same as previously described.  Start by doing a select on the indicator, do a copy to the clipboard, go to Excel, and now because you probably want your indicator data to reside alongside your price and volume data, go to the first open cell just to the right of the titles that have already been copied there, then do the insert at that point.  With this copy/insert you will get a new column of dates (in your case, I would imagine times as well) as well as the indicator title and values.  I use this to cross check and verify that my indicator values line up with my data dates.  Then you can remove the duplicate date column.

I use this method a great deal to build history files in Excel.  I bring in daily data, then at the bottom the MS chart I go to the little periodicity tab and convert it to monthly.  Then when I copy it to Excel, I get a list of monthly data without the daily data details.  Also, when I get it into Excel I change the date to a format that is easier for me to read.  You will be able to do that with time as well.  In fact, I have put the Excel cell formating icon on my tool bar so I don't have to go through the hassle of selecting the "Format" tab each time.

Once I got used to this routine and understood how to make the format changes in Excel, it became a very simple task.  Hope it works the same for you.

Jay  






Yahoo! Groups Sponsor


  ADVERTISEMENT









To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx





Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.