Discussions
»
Product and Service Development
»
Data Related Questions
»
Synchronising Excel tick data to Metastock minute bars thru OLE
Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 12/15/2009(UTC) Posts: 4
|
Hey guys,
I am having a little trouble with this one, please help me out.
I'm working with live tick data in Excel and want to export the calculation via OLE to Metastock (Pro 11) 1 and 5 minute charts as an indicator.
I can bring the data into MS, but it backfills instead of "pushing against the right edge." Let me try explain that better:
If I'm on a 1 minute (1M) chart in MS, by midday I will have about 240 data points - 240 * 1M minute candles that is. Now if I import my Excel calcs for the same period, l have about 4000 data points which MS reads as 4000 1M candles. So instead of being restricted to the current session, the indicators plots backwards maybe a week.
Wondering if there might be a fix in Metastock? Currently my data is just a column of values, if I add a column with time values will MS be able to read and recognise it?
Alternately, is there a way in Excel to only create a new cell / data point / minute bar with the passage of every actual minute?
All help appreciated, cheers.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 4/27/2005(UTC) Posts: 31
|
I do not know much about Excel but when you paste or copy data to metastock from a spreadsheet, if you do not include a date and time column(s), metastock assumes the top row is the aligned with the first bar loaded in metastock. If you include columns for the date and time, then the imported data should align with the data in your chart.
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Data Related Questions
»
Synchronising Excel tick data to Metastock minute bars thru OLE
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.