Discussions
»
Special Interest Groups
»
Plugins & Addons
»
How to increase Explorer's 256 character filter limit
Rank: Newbie
Groups: Registered, Registered Users Joined: 9/12/2005(UTC) Posts: 4
|
In metastock explorer for the filter section up to 256 character is available for editing...
Is there any add-in program or any other section that I dont know to solve this problem.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 1/19/2005(UTC) Posts: 1,065 Location: Koh Pha-Ngan, Earth
Was thanked: 2 time(s) in 2 post(s)
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/7/2005(UTC) Posts: 1,346
|
hey INVESTORKK..... the only way to increase that limit might be thru tight coding..... use the fml to reduce..... you likely know this but some might not.....
as a example, filter
(Mov( ( RSI(8) - LLV( RSI(8) ,8 ) ) / ( ( HHV( RSI(8) ,8) ) - LLV(RSI(8),8) ),3,E) *100)>90
will return the same results as simply,
fml("a")
but with far less characters.... the difference is having an indicator named "[color=blue:c57014d2c0]a[/color]" whose formula is [color=blue:c57014d2c0](Mov( ( RSI(8) - LLV( RSI(8) ,8 ) ) / ( ( HHV( RSI(8) ,8) ) - LLV(RSI(8),8) ),3,E) *100)>90[/color]....
thats the only way that comes to mind..... try the fml, there will be significant savings .....h
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/7/2005(UTC) Posts: 1,346
|
hey INVESTORKK..... it never dawned on me to look at the limit untill seeing jose's post.... shows ya how often i do explorations i guess........ which version are you using, if ya don't mind.....
and btw, wasn't sure on how to export that many indicators to excel..... it might be easier to set up macro's in excell for the function formulas and the just export the price data....
corrected this post, limit appears to be 3000 in 9.1, thats assuming all characters are equal.....h
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 4/30/2005(UTC) Posts: 112
|
hi hayseed or others,
Just curious, wouldn't it affect the efficiency of MS if we put a lot of external formulae similar to fml("a")?
I mean will it consume more cache / ram to run it?
secondly, is it possible to export real time data to excel by macro?
.. thks
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 3/7/2005(UTC) Posts: 1,346
|
hey gary..... seems like you can use macros to link excel to real time data.... i am almost certain it can be done using QC.... there is a reuters tools app for excel that creates the links...
the use of external formulas almost assuredly must effect meta's efficiency.... that effect might not be a negative one.... without knowing exactly the process meta uses in explorations, we would have to time related explorations....
i ran the macd expert, macd histogram expert, and stochastic osc experts explorations on the folder 'stocks north american' the 7590 US securities only... it took 1.02 , 1.22, and 1.08 for total time of 3.32 minutes...
then i ran a combination of those 3 using the fml("a") type setup... the combo deal took 1.39 minutes..... each column contained only fml ..... the combo was similiar to this........
at least in some cases it appears fml's have a positive effect....
patrick, jose or roy would have more experienced thoughts.....h
|
|
|
|
Users browsing this topic |
|
Discussions
»
Special Interest Groups
»
Plugins & Addons
»
How to increase Explorer's 256 character filter limit
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.