logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
RUTrading  
#1 Posted : Wednesday, March 6, 2013 8:33:25 AM(UTC)
RUTrading

Rank: Member

Groups: Registered, Registered Users, Unverified Users
Joined: 6/12/2012(UTC)
Posts: 19
Location: South Africa - JHB

Hi

I would like to find out with the explorer function if there is away to explore more than just the 12 columns.

I would like to be able to put in 120 different formulas at one time and use the explorer to give me the answer (1 or 0 in most cases) for each scenario.

I need each answer in different column very important!! I could make 10 different explorations with 12 in each but it is going to be easier if it was just one exploration as I have many different groups of shares (that are grouped which I don't want to combined that I would like to do this exploration on.


Which therefore makes it alot more work because it would mean 10 X 12 times 24 groups of shares which I have.

I hope I am making sense. Is there a way around this hard work?



wabbit  
#2 Posted : Thursday, March 7, 2013 5:58:30 AM(UTC)
wabbit

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)
If you've got 120 criteria to determine your trades, then you're better off combining these in a single function (or series of functions) and have it/them just return a yes/no decision instead of having to read a report and then make a decision.



wabbit [:D]

RUTrading  
#3 Posted : Thursday, March 7, 2013 12:51:58 PM(UTC)
RUTrading

Rank: Member

Groups: Registered, Registered Users, Unverified Users
Joined: 6/12/2012(UTC)
Posts: 19
Location: South Africa - JHB

Hi Wabbit

I understand you can do that, but for research purposes I need each formula to give me a 1 or 0. Any other suggestion?
wabbit  
#4 Posted : Sunday, March 10, 2013 4:04:31 AM(UTC)
wabbit

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)
The simplest answer I can give is to employ the MDK and write your own data to external files and analyse them outside MS.

Without the MDK, you could combine the 120 criteria into say 12 groups of ten criteria and use binary values (1,2,4,8,16,32,64... 1024) to set flags for each of the criteria to "compress" the results; then use Excel or another application to restore the values, e.g

Code:

c1:={criteria1};
c2:={criteria2};
c3:={criteria3};
...
c10:={criteria10};

c1+
2*c2+
4*c3+
...
1024*c10;


If using MS Excel, you'll find the DEC2BIN() function useful.



wabbit [:D]

Users browsing this topic
Similar Topics
How to program the Explorer to get quotes for an exact day? (Formula Assistance)
by Rafael 7/19/2016 3:33:10 PM(UTC)
MACD (5,35,5) plus crossing zero line for the explorer function (Formula Assistance)
by nizniz 7/31/2014 1:16:26 AM(UTC)
Inertia indicator calculation delivers different values in the chart and in the explorer modules... (MetaStock)
by zentrader 4/8/2012 11:24:51 AM(UTC)
« pp:» explorations missing in the Explorer and the Expert Advisor in MS11. (MetaStock)
by metanewbie 9/9/2011 2:28:43 PM(UTC)
Access to the explorer requires the existence of a valid indicator builder file (MetaStock)
by ageitalia 7/2/2011 3:18:48 AM(UTC)
Schedule task for downloading eod and schedule a. Configure and schedule multiple downloads using the Downloader b. Scheduling and running multiple explorations using the Explorer (MetaStock)
by adeline 1/23/2011 1:20:28 AM(UTC)
The Explorer - Periods (Formula Assistance)
by Ploufplouf 2/13/2010 9:22:40 AM(UTC)
Using the Explorer on composite securities (MetaStock)
by Vinny Chase 5/7/2009 2:54:48 PM(UTC)
The explorer Data Does not represent to the last data (Formula Assistance)
by supsup 11/8/2008 1:51:31 PM(UTC)
ADX and SAR Indicators do not represent the last value in the explorer (Formula Assistance)
by supsup 4/16/2008 3:06:20 AM(UTC)
How to get the Explorer to not reject securities (Basic Coding Techniques)
by bullenr 4/5/2008 11:49:06 AM(UTC)
securities list in The Explorer [RESOLVED] (MetaStock)
by minnamor 2/23/2006 8:06:41 AM(UTC)
many-to-many relationship in The Explorer (Product Wish List)
by cassianoqs 7/21/2005 6:57:19 PM(UTC)
The Explorer speed (MetaStock)
by VolTrader 2/11/2005 8:57:56 PM(UTC)
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.