MetaStock Formula ---> Excel Formula

[Nicholas Kormanik]

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

 

[zentrader22]

@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

 

[rahul100]

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

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

 

[zentrader22]

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

 

[Hadddm]

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

 

[NoumanZafar]

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.