Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 12/30/2005(UTC) Posts: 120
|
I would like to add following data into Metastock from Excel, such as date OHLC, but when I follow below steps 2 by copying column A2 to E100, and paste special into Metastock, it only shows the first item under A - date in day format, and find nothing about OHLC, and when I try only to select column E2 to E100 for closing price, it shows closing price on chart only, but I would like to show OHLC based on given date to show daily chart, does anyone have any suggestions on how to do it in Metastock?
Thanks in advance for any suggestions
Eric
At this point you can perform further calculations on the indicator values in Excel if desired. Once these new values are calculated, they can be linked back to MetaStock and plotted in a new inner window by doing the following:
1. Select the entire column of newly calculated values in the spreadsheet by clicking on the column heading.
2. Right-click on the selected column and choose Copy from the shortcut menu. In the illustration below, columns A and B are the values linked from MetaStock. Column D is the newly calculated values that will be linked back to MetaStock.
3. Switch back to MetaStock.
4. Choose New Inner Window from the Window menu to open a new inner window in the chart.
5. Right-click on the new inner window and choose Paste Special from the shortcut menu.
6. Choose the Paste Link radio button and choose Csv from the list. Click OK.
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.