Excel interface

I have a bug that is inconsistent.
I import 4 rows of data. The issue relates to a horse named Saga Miss. Horse name are not imported with ""

Please refer to the attached images.

Why does the trigger report Saga Miss's P col: value as False (is it equal to 16 ) when it clearly is.
There was another horse on the day called 'Justsaga'
That was the only other horse with a similar name.

Question?
If I have a horse name "Beauty" and there is another horse named "Beauty Queen" will this cause an error like above?

I've added another example. See attached. In this case there is no way another horse has Shamfrancisco in their name.
The number 16 is used for trigger indent.
The next number down is a price
The next number down is a book value
I formulate the price/book using a Rank formula.

I noted yesterday there was next to no action all due to the 16 not being recognized....Why?

Same day different horse. All ok
What could be causing this inconsistency.

Hello!

It is hard to tell since you have only added a snapshot showing the figures without the name of the selection next to it.

Try turning on the following setting:

"Log trigger expression" in "Betting Options"

and see what that formula (cell_querymarket_id_P(sel_index*3+1) actually evaluates too. Check that value against the one you expect to see there.

hi
sorry but i have a very bad back an if i stay on the computer to long the pain gets more than one can take.
your condition
cell_qerymarket_id_P(sel_index*3+1) does not look correct
try
cell_qerymarket_id_P((sel_index*3)+1)
note the extra ( and )
without a trigger to test it is difficult to give a correct answer.

mcbee

cell_querymarket_id_P(sel_index*3+1) does not look correct
The above parse's the same as cell_querymarket_id_P((sel_index*3)+1)

Quote from: Oxa (WellDoneSoft) on 31 Oct 2016, 14:08

Hello!

It is hard to tell since you have only added a snapshot showing the figures without the name of the selection next to it.

Try turning on the following setting:

"Log trigger expression" in "Betting Options"

and see what that formula (cell_querymarket_id_P(sel_index*3+1) actually evaluates too. Check that value against the one you expect to see there.

My first post shows Shamfranciso not resulting in '1' when it is on the Excel sheet and the second posts shown Invincible Express working correctly. Same trigger same day

What I mean is, you might want to look what sel_index and the whole expression translates into. Maybe that index is different from the selection in question. Maybe the expression is not being parsed correctly in the first place, that is why you need to use that option.

McBee> formula brackets. I followed the help file Mcbee. I have used this method for years and it seems ok.

Oxa>is the trigger expression from the program correct. Is the RANK formula working correctly. see 15:18:42 selection 4 // It shows "final=RANK(-38.11,S5:S76,1)"
Should not that show for example "final = 1"

Are my RANK formulas correct?
=RANK(cell_querymarket_id_Q(sel_index*3+2),Q5:Q76,1)

or should they be =RANK(cell_querymarket_id_Q(sel_index*3+2),cell_querymarket_id_Q5:cell_querymarket_id_Q76,1)

It still keep acting inconsistently, on Saturday costing me me $200.
Excel file with imported selections, cells A:D in imported.
I have sent the log but changed its extension from .gz to .txt (because you don't allow .gz files?)
and the trigger.

Your help is appreicated.

Is this problem too hard?
I would have thought MFPro not performing consistently was an important issue.

Sometimes MFPro recognizes names sometimes it doesn't..why?
Not really wanting to commit dollars to if it's hit or miss, sorts puts MFPro in a entertainment category not a serious market interface program.

Just seeking an explanation why this inconsistency is occurring.

Hi londolozi
Capture_27 shows the trigger attempting to parse a RANK function and failing
Capture_28 shows the trigger attempting to parse a RANK function and failing and a ROUND function and failing
all the other expressions parse correctly to values
as far as I'm aware RANK and ROUND functions are not supported by MarketFeeder, and must surely be a value before being sent to MF for processing by the trigger?

I can't capture a screen shot because once triggering starts with Excel my interaction is limited. However, I can observe both formulas and they work fine. I need to use ROUND() because MFPro rounds to say 5 decimal places and Excel 6 this no number was being recognized for RANK(). The formulas work fine its the inconsistency of identifying horses and then not that worries me.

Its appears I found the issue causing the problem. A macro with limited range criteria.
Thank you and apologies.

Excel interface

Hello Guest