MS Formula : Create Function with Parameter

[Angeluz]

Hello there,

Here is what I am trying to do : a new indicator that would take a security name as parameter.

I want then to call this function in other functions by a command like "myFunction(SecurityName)" just like any other function for example rsi(15)...

Is that possible in MS ? I couldn't find any help on the subject, apart from the fmlvar syntax but it isn't helping here ..

Thank you for any advice !!

 

[jose]

I want then to call this function in other functions by a command like "myFunction(SecurityName)" just like any other function for example rsi(15)...

I believe that Umit at TraderHelp.net has a MetaStock DLL available which does just that.


jose '-)

 

[Angeluz]

I believe that Umit at TraderHelp.net has a MetaStock DLL available which does just that.

Jose,

Thank you for helping !
However on traderhelp.net website I could only found 3 programs developed there, and none seems to be specifically oriented in indicators creation with parameters.

If you come across this DLL you are talking about a bit more precisely let me know !

Gilles


[Edit to give more details about what I am trying to do :]
I want to sum up a specific indicator for, say, 20 securities.
for example : rsi(securities("blabla",C),14) + rsi(securities("tom",C),14) + ...

Because the formula editor is limited in length there are some problems with this formulation !

I would like to create a function "rsiSecurity(SecurityName)" and write :
rsiSecurity("blabla") + rsiSecurity("tom") +...
[/Edit]

 

[jose]

However on traderhelp.net website I could only found 3 programs developed there, and none seems to be specifically oriented in indicators creation with parameters.

Yes, contact Umit directly through his website, and he'll then give you a price on his very handy custom Security.dll (which he doesn't advertise).

jose '-)

 

[Robertral]

Jose,

Thank you for helping !
However on traderhelp.net website I could only found 3 programs developed there, and none seems to be specifically oriented in indicators creation with parameters.

If you come across this DLL you are talking about a bit more precisely let me know !

Gilles


[Edit to give more details about what I am trying to do :]
I want to sum up a specific indicator for, say, 20 securities.
for example : rsi(securities("blabla",C),14) + rsi(securities("tom",C),14) + ...

Because the formula editor is limited in length there are some problems with this formulation !

I would like to create a function "rsiSecurity(SecurityName)" and write :
rsiSecurity("blabla") + rsiSecurity("tom") +...
[/Edit]

Go into visual basic (Alt+F11), and then insert a module.
Then add code like this

function myFunction(ByVal SecurityName As String)
myFunction = rsiSecurity("blabla") + rsiSecurity("tom") +...
end function

If you need futher help send me a pm

 

[Robertral]

Go into visual basic (Alt+F11), and then insert a module.
Then add code like this

function myFunction(ByVal SecurityName As String)
myFunction = rsiSecurity("blabla") + rsiSecurity("tom") +...
end function

If you need futher help send me a pm

***** EDIT : opppsss sorry didn't read MetaStock....just saw MS and thought microsoft excel....sorry, please ignore my post

 

[martindelica]

Help with formula

Hi there, I was hoping somebody could help me a formula:
I want MetaStock explorer to use the following parameters;
RSI(14) is greater than 70 and daily volume over last 5 days is decreasing.
and
RSI(14) is less than 30 and daily volume over last 5 days is decreasing.

Kindest Regards,
Martin.

 

[zambuck]

....see your original thread.......

Hi there, I was hoping somebody could help me a formula:
I want MetaStock explorer to use the following parameters;
RSI(14) is greater than 70 and daily volume over last 5 days is decreasing.
and
RSI(14) is less than 30 and daily volume over last 5 days is decreasing.

Kindest Regards,
Martin.

 

[me_we]

hello to every one