Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/22/2009(UTC)
Posts: 13
Location: California
Was thanked: 1 time(s) in 1 post(s)
|
Please forgive me if this is the wrong forum. Currently running Windows 7 home premium, and I recently installed Office2106 64 bit (including Excel 64 bit). I have used the Downloader for several years, and Metalib5.0 (Trading-Tools.com) to put the Metastock data into a spreadsheet. Metalib5.0 gives an error message "ActiveX component can't create object". It will not work with Excel 64 bit, and they do not provide technical support.
Can anyone suggest a product that will export Metastock Downloader files to Excel (64 bit)? Thanks very much. Bill Roberts
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
Hi,
The DownLoader can Convert MetaStock Data into the older Excel (XLS) format. Excel should be able to open these files however, and you could then save it in a newer format if you wished.
In The DownLoader, clicking Tools > Convert allows you to start the process. You would set the Source type as MetaStock and the Destination type as Excel. Single or multiple securities can be converted. If you only want 1 security per XLS file, you need to use *.XLS for the Destination Filename and it will create a separate XLS file for each MetaStock security you select in the Source.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/22/2009(UTC)
Posts: 13
Location: California
Was thanked: 1 time(s) in 1 post(s)
|
My first post was not clear. Metalib runs as part of (imbedded in) my Visual Basic program, so the process is quite automated. I run the program for several symbols, and I specify the number of periods/Weekly/Daily, etc.
The program gets a symbol from a cell, loads the number of days requested, open, high, low, close, volume, then runs technical analysis visual basic software. I don't have to do anything more than run the macro.
I understand how to use the convert option, but it is not automated. I need a program that will do that within Visual Basic. Thanks for the note. I hope I clarified my request. Bill Roberts. (And in an Excel 64 bit system)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
Ah okay makes sense. I am not familiar with any such program, although perhaps some sort of application like AutoHotkey might make for an imperfect alternative.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 9/22/2009(UTC)
Posts: 13
Location: California
Was thanked: 1 time(s) in 1 post(s)
|
Follow up to my earlier post. I cannot find a solution to my problem that is within my programming skills. If there are any programmers out there that can provide code that will allow me to create a spreadsheet (within Visual Basic) for a symbol within a Downloader Metastock file, I will be glad to pay for the code. Bill Roberts
|
|
|
|
|
|
| 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.
