Author Topic: Excel interface  (Read 4220 times)

Tags:
  • All members
  • Posts: 490
  • Gender: Male
Excel interface
« on: 30 Oct 2016, 02:26 »
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?
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #1 on: 30 Oct 2016, 02:37 »
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?
 
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #2 on: 30 Oct 2016, 02:40 »
Same day different horse. All ok
What could be causing this inconsistency.
Improvise Adapt Overcome

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: Excel interface
« Reply #3 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.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: Excel interface
« Reply #4 on: 31 Oct 2016, 17:37 »
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
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #5 on: 03 Nov 2016, 11:28 »
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)
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #6 on: 03 Nov 2016, 11:31 »
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
Improvise Adapt Overcome

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: Excel interface
« Reply #7 on: 03 Nov 2016, 19:40 »
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.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #8 on: 03 Nov 2016, 19:58 »
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"
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #9 on: 03 Nov 2016, 20:20 »
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)
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #10 on: 07 Nov 2016, 04:25 »
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.
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #11 on: 08 Nov 2016, 23:03 »
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.

 
Improvise Adapt Overcome

  • Moderator
  • Posts: 3597
*
Re: Excel interface
« Reply #12 on: 09 Nov 2016, 22:18 »
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?
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #13 on: 10 Nov 2016, 05:39 »
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.
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel interface
« Reply #14 on: 12 Nov 2016, 02:22 »
Its appears I found the issue causing the problem. A macro with limited range criteria.
Thank you and apologies.
Improvise Adapt Overcome

 

Please note, BetFair is seems to be currently OFFLINE