Rank: Member
Groups: Registered, Registered Users
Joined: 5/11/2006(UTC)
Posts: 10
|
Is it possible to convert MetaStock formulas into Excel formulas?
I'd like to create a spreadsheet in Excel that replicates the data held in a chart.
For instance:
In Excel
Column A would be Opening Price
Column B would be 21-day MA of OP
Column C would be 56-day MA of OP
etc.
Any help would be greatly appreciated.
Nicholas Kormanik
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
End of day (EOD) or real-time (RT)?
wabbit [:D]
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 5/11/2006(UTC)
Posts: 10
|
EOD
In Excel there would have to be an entire column of formulas for any indicator.
And MetaStock built-in indicators do not have a corollary in Excel.
Seems no straight-forward direct connection between the two programs. MS doesn't speak Excel. Excel doesn't speak MS. Definitely appear to be road blocks.
Please enlighten.
Thanks,
Nicholas Kormanik
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Although there are a lot of limitations in MS, I'm wondering what analysis you're doing in Excel which cannot be done in MS, hence the need to have the MS data in Excel?
How many indicators are we talking about here?
Anyway, there are a number of ways to get MS data into Excel.
1. RTFM re: OLE (Object Linking and Embedding), or simply cut-and-paste. Unfortunately in the MS GUI you cannot multiple select chart objects (data and indicators) so each has to be done individually.
2. If you know how to program in Excel, to create the 'corollary' of functions in Excel, then all you need is a third-party application to read MS data in Excel (I cannot remember any specifics, but they are 'out there' on the net -- Google will be your friend).
3. If you cannot program in Excel (or don't want to) the next option to use the MDK (yourself, or have someone write it for you) to output the MS charted data to a .csv file (or similar ). This has the benefit of being able to write multiple tickers' data files. There are several ways to do, each with their own capabilities and limitations, so talk these through with your programmer.
4. There are some commercially flogged products, but I cannot vouch for them.
wabbit [:D]
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 5/11/2006(UTC)
Posts: 10
|
All sound advice. I hope someone here knows specifically how to efficiently accomplish the chore.
The manual copy-and-paste way is the only way I know of so far.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Ahem.... look at my signature block as a place to start.
wabbit [:D]
|
|
|
|
|
|
| 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.
