Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 8/29/2011(UTC) Posts: 1
|
From an Excel spreadsheet:
Columns A (Date) and B (Closing Price) for a security. We would like to copy that data to the date and closing price fields of that security file to be updated in Metastock’s Downloader program on a daily basis.
I have the MetaStock drivers. How would we do this through vba code? (I just need the calls to MetaStock - I don't need to know how to iterate through the rows in the Excel spreadsheet).
Thanks in advance!
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,955
Thanks: 91 times Was thanked: 155 time(s) in 150 post(s)
|
I'm sorry but we do not have provisions for a VBA update like you are requesting. Data files can only be updated from a download within the downloader OR by converting the data with the downloader.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 5/13/2005(UTC) Posts: 715 Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
Try MetastockCSV -- there is a free version with a limited number of columns that may be all you need.
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,955
Thanks: 91 times Was thanked: 155 time(s) in 150 post(s)
|
Thanks Johnathan. I was not aware of this third-party tool.
|
|
|
|
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.