MetaStock Formula ---> Excel Formula

This is a discussion on MetaStock Formula ---> Excel Formula within the Trading Software forums, part of the Commercial category; Is it possible to convert MetaStock formulas into Excel formulas? I'd like to create a spreadsheet in Excel that replicates ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Feb 26, 2012, 9:15am   #1
 
1 Posts
Joined Feb 2012
MetaStock Formula ---> Excel Formula

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
Nicholas Kormanik is offline   Reply With Quote
Old Feb 26, 2012, 10:59am   #2
Joined Mar 2005
Re: MetaStock Formula ---> Excel Formula

@Nicholas,

you can rebuild the formulas/functions that you use in MS also in Excel manually (there's no automatic possibility), if you know the underlying algorithms.

Alternatively you can write MS price data directly to Excel using this add-on tool:
MetaLib: SDK for reading/writing MetaStock security price data in VB, C#, Delphi, C++

You have to ask the autors, whether it's possible to write the results of formulas/functions (like MAs etc.) too...

bye,
zentrader
__________________
www.zentrader.de (Trading system development and simulation tools)
zentrader22 is offline Software vendor   Reply With Quote
Old Feb 26, 2012, 12:10pm   #3
Joined Nov 2008
Re: MetaStock Formula ---> Excel Formula

Hi

This can be done very easily using copy and paste (OLE)

open a new internal window, add the indicator and then copy and special past as link csv

you will have to pick all the colums when pasting

regards,

mehul





Quote:
Originally Posted by Nicholas Kormanik View Post
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
rahul100 is offline   Reply With Quote
Old Feb 26, 2012, 3:24pm   #4
Joined Mar 2005
Re: MetaStock Formula ---> Excel Formula

Quote:
Originally Posted by rahul100 View Post
Hi

This can be done very easily using copy and paste (OLE)

open a new internal window, add the indicator and then copy and special past as link csv

you will have to pick all the colums when pasting

regards,

mehul
@mehul,

yeah - many thanks! Sometimes the most simple solutions (OLE) are overseen... :-)

bye,
Volker
__________________
www.zentrader.de (Trading system development and simulation tools)
zentrader22 is offline Software vendor   Reply With Quote
Old May 16, 2017, 5:04pm   #5
 
3 Posts
Joined May 2017
Hello everyone

I was wondering if there is a metastock formula expert here who can assist in creating an explorer that would provide Daily S/R levels (duration 4 weeks including current week) and
Weekly S/R levels (duration 6 months including current month).

I also would like an explorer showing instruments that are in a trading range for same period mentioned above.

For both explorers I would like to show me the levels themselves which will be identified in the columns of the explorer.

Thank you in advance.
MH
Hadddm is offline   Reply With Quote
Old Oct 9, 2017, 12:57pm   #6
 
2 Posts
Joined Oct 2017
Hi,
I am new to MS. Using version 11 offline mode.
My issue is at end of day i get only (high, low, open,close,volume) data of all 100+ securities/scrips/equities from some sites.
I want to auto populated data in excel including ( high,low,open,close,volume,bollinger bottom, SME5, RSI) that too against each securities.
I am tired !!! of doing things manually on excel so i need some help from MS program to auto populate last day working ALONG with Indicator values, and how this can be done, how to extract these values from metastock program. That too with simple few clicks.
I dont want to open each 100+ securities graphs and simple copy paste everything into tabular forum.

I will'b highly highly grateful to support on this.
NoumanZafar is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Supertrend excel formula mpower87 Technical Analysis 1 Feb 9, 2012 4:16am
EXCEL trendline formula Billy Gates Techies Corner 2 Sep 18, 2011 9:04am
Excel Probability Formula Help richardsbenson Psychology, Risk & Money Management 3 Jan 17, 2009 5:31pm
excel formula wasp General Trading Chat 14 Dec 1, 2008 7:49pm
Excel - win % calculation formula Directional Techies Corner 8 Mar 30, 2006 10:37pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)