Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 12/30/2005(UTC) Posts: 120
|
I would like to load data from Excel into Metastock, so whenever data within Excel is updated, the Chart within Metastock will also be updated. When I follow below instruction, I don't understand the step 4 on how to create a new security instead of creating New inner window within another security. Does anyone have any suggestions and know any tutorial video to do that?
Thanks in advance for any suggestions
To link data in an Excel spreadsheet to MetaStock
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.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users Joined: 10/28/2004(UTC) Posts: 3,111 Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
The instructions above are for displaying data from Excel against a base security.
You need to convert your Excel data into a base security, use the Downloader to do the conversion, then simply open the data as a new chart.
wabbit [:D]
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 12/30/2005(UTC) Posts: 120
|
Once I convert Excel data into a base security, will the data from a base security be automatically updated by linking data from Excel?
Do you have any suggestions?
Thanks you very much for any suggestions
|
|
|
|
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.