logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
oem7110  
#1 Posted : Friday, January 27, 2012 11:12:36 PM(UTC)
oem7110

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.

wabbit  
#2 Posted : Friday, January 27, 2012 11:44:36 PM(UTC)
wabbit

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]

oem7110  
#3 Posted : Saturday, January 28, 2012 7:08:54 PM(UTC)
oem7110

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.