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?
|
|
|
|
|
|
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]
|
|
|
|
|
|
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?
|
|
|
|
|
|
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 |
|
Guest (Hidden)
|
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.
