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

Notification

Icon
Error

Options
Go to last post Go to first unread
robcpettit  
#1 Posted : Monday, May 23, 2005 12:10:55 PM(UTC)
robcpettit

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 5/6/2005(UTC)
Posts: 52
Location: England

Hi, heres a general query. In Excel, col A have dates from say 1/1/05 to todays date, col b range of prices. First dates are in uk, copy and paste both columns to index chart in Meta. Plots graph with some price series missing. Ok back to excel format col a to use USA Dates, back to Meta, Perfect. Why?. Next say a week later update in excel dates and prices, open metastock, no copy and paste as dynamically linked, but, in the header shows correct 'todays' prices but graph shows price 1 week ago, the only way so far Ive found to change this is, in Excel change dates to UK, apply, then back to USA, this updates Meta perfect. Why? In Meta used the Update Link but no joy. I know this is a minor prob but could be time consuming if I had alot of links to Excel. Also doesnt install confidence in the graph. Regards Robert
Patrick  
#2 Posted : Monday, May 23, 2005 2:25:32 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Could the problem be that MetaStock uses MMDDYYYY and your data is DDMMYYYY ... Patrick
robcpettit  
#3 Posted : Tuesday, May 24, 2005 9:17:34 AM(UTC)
robcpettit

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 5/6/2005(UTC)
Posts: 52
Location: England

Thanks for your reply, This is indeed the problem, what I like to know though is when Ive altered the date format in Excel, its not updating metastock without me haveing to go through the rigmorole of altering dates back to uk then back to usa. Regards Robert
Patrick  
#4 Posted : Tuesday, May 24, 2005 2:22:08 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
You could try the following : ( I have never tested this myself ) Delete the date column all together, now when in the downloader click on tools, convert and click on options. Specify the first and last date you are converting. I believe The Downloader will the assign the date properly for you as long as the data is accurate and that you are not missing any days. I don't know how it handles hollidays and such .... anyways it is worth a shot. Patrick :mrgreen:
Users browsing this topic
Guest (Hidden)
Similar Topics
Excel and Powerpoint error (Error Messages)
by shivammehta 2/3/2021 9:18:16 AM(UTC)
[SOLVED] Xenith excel ISM PMI data (Data Related Questions)
by traderUY 6/9/2016 5:13:34 AM(UTC)
Using Excel To Make Long Symbol Lists For Copy/Paste To MS12 (MetaStock)
by RichardShaw 2/25/2013 2:36:54 PM(UTC)
The downloader and import data from excel (xlsx)???? (MetaStock)
by sarcasm 9/5/2012 6:11:04 AM(UTC)
figure different from excel figure (Formula Assistance)
by Flexi 8/17/2012 3:30:37 PM(UTC)
Convert Excel data with weekends to Metastock format (Data Related Questions)
by Francesco 7/8/2012 7:36:08 AM(UTC)
OLE can paste special candlestick data from MS to Excel only? (MetaStock)
by JohnKey 5/22/2012 5:42:51 PM(UTC)
MetaStock Formula ---> Excel Formula (Formula Assistance)
by nkormanik 2/26/2012 12:57:41 AM(UTC)
How to load data from Excel into Metastock? (Formula Assistance)
by oem7110 1/27/2012 11:12:36 PM(UTC)
Adding Extra Fields in Metastock Excel based data (Data Related Questions)
by TrendTrader7 10/9/2011 3:58:14 PM(UTC)
problem copy/paste excel data to security file in downloader (Data Related Questions)
by Leclere 9/29/2011 3:55:54 AM(UTC)
Inserting a chart in excel as OLE object - can not paste as link (Data Related Questions)
by Torbenv 9/11/2011 9:15:15 AM(UTC)
Problems converting excel data to Metastock with Downloader (Data Related Questions)
by polintano 6/29/2011 7:44:21 PM(UTC)
Copying from Excel and Pasting to MetaStock (MetaStock)
by NewTrader 9/12/2010 6:17:54 AM(UTC)
Synchronising Excel tick data to Metastock minute bars thru OLE (Data Related Questions)
by RockCzar 9/9/2010 3:30:07 AM(UTC)
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.