logo
  • Home
  • Discussions
  • Files
  • Register
  • Login
Welcome Guest! To enable all features please Login or Register.
  • Forum
  • Active Topics
  • Search
  • Help
  • Login
  • Register
  Search Search

Notification

Icon
Error

OK


Discussions  »  Product and Service Development  »  Formula Assistance  »  To link data in an Excel spreadsheet to MetaStock
To link data in an Excel spreadsheet to MetaStock - To link data in an Excel spreadsheet to MetaStock
Options
  • Email this topic Email this topic
  • Watch this topic Watch this topic
  • Print this topic Print this topic
  • » Normal
  • Threaded
Go to last post Go to first unread
Previous Topic Next Topic
oem7110  
#1 Posted : Friday, May 21, 2010 3:50:34 AM(UTC)
oem7110

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.
Back to top
  • User Profile
  • View All Posts by User
  • View Thanks

Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.

Back to top  
Users browsing this topic
Guest (Hidden)
Discussions  »  Product and Service Development  »  Formula Assistance  »  To link data in an Excel spreadsheet to MetaStock
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.

Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET
  • Terms
  • Privacy Statement
  •  
© Copyright 2025 MetaStock. All rights reserved.