Author Topic: A spreadsheet query please  (Read 906 times)

Tags:
  • All members
  • Posts: 191
  • Karma: +2/-0
  • Gender: Male
A spreadsheet query please
« on: Fri, 03 March, 2017, 05:27 »
For every race that qualifies, I create a spreadsheet through the Settings/Excel options.

As you will be aware, many of the cells in each spreadsheet are reserved for MFP functions. One of those cells is J2, into which the winner of each race is inserted after the result is declared.

In "test" mode, this works perfectly.

In "real" mode it rarely works.

In most cases, I have to insert the result myself.

Why is this so, please?

bobh

  • Administrator
  • Posts: 6421
  • Karma: +212/-2
  • Gender: Female
*
Re: A spreadsheet query please
« Reply #1 on: Fri, 03 March, 2017, 06:47 »
Hello!

I will look into it later today and post here.
Always try your triggers in Test Mode before switching to real money!

You can get a faster response from us if you contact us via FaceBook Messenger.

Присоединяйтесь к нашей официальной группе ВКонтакте!

  • All members
  • Posts: 191
  • Karma: +2/-0
  • Gender: Male
Re: A spreadsheet query please
« Reply #2 on: Wed, 08 March, 2017, 04:25 »
Hi Oxa,

Any joy with my query?

bobh

  • Administrator
  • Posts: 6421
  • Karma: +212/-2
  • Gender: Female
*
Re: A spreadsheet query please
« Reply #3 on: Wed, 08 March, 2017, 10:22 »
Hello!

So far, I've been unable to reproduce this problem. The winner's name appears in the corresponding cell each time the event is settled. Could you please email me your settings at oxa at welldonesoft dot com?
Always try your triggers in Test Mode before switching to real money!

You can get a faster response from us if you contact us via FaceBook Messenger.

Присоединяйтесь к нашей официальной группе ВКонтакте!

  • All members
  • Posts: 191
  • Karma: +2/-0
  • Gender: Male
Re: A spreadsheet query please
« Reply #4 on: Thu, 09 March, 2017, 00:08 »
Thanks Oxa,

I will wait a day or so before I send my settings (straight forward standard).

Just after I sent my latest email, it seemed to be working OK, but intermittently. I can assure you it has not been working for at least 2 weeks, maybe longer, as I have been manually inputting for that period of time.

I will report again in a day or so.

Regards,

bobh

  • Administrator
  • Posts: 6421
  • Karma: +212/-2
  • Gender: Female
*
Re: A spreadsheet query please
« Reply #5 on: Thu, 09 March, 2017, 06:24 »
I have no reason to not believe you, please report as soon as you've spotted this behaviour once again. I just need some details as to what markets it was (greyhound/horse racing/soccer etc.), whether finished markets are deleted automatically and some other details.
Always try your triggers in Test Mode before switching to real money!

You can get a faster response from us if you contact us via FaceBook Messenger.

Присоединяйтесь к нашей официальной группе ВКонтакте!

  • All members
  • Posts: 191
  • Karma: +2/-0
  • Gender: Male
Re: A spreadsheet query please
« Reply #6 on: Thu, 09 March, 2017, 23:25 »
I will slightly amend "delete settled events automatically"  by keeping the last event settled, just in case there is a time delay between the spreadsheet and the results being updated.

I'll let you know.

Thanks for your help,

bobh

  • All members
  • Posts: 191
  • Karma: +2/-0
  • Gender: Male
Re: A spreadsheet query please
« Reply #7 on: Fri, 10 March, 2017, 05:30 »
Well that has fixed the problem. All is working well today.

So, it would appear that the last race result is being updated in MFP before the Betfair statement.

It's not a problem now that I know what it is, but would be ideal if the result could be delayed until after the statement is updated, then I would only have upcoming races on the screen.

Thanks again for your help.

bobh

  • Administrator
  • Posts: 6421
  • Karma: +212/-2
  • Gender: Female
*
Re: A spreadsheet query please
« Reply #8 on: Mon, 13 March, 2017, 11:18 »
The problem should now be fixed in the newest update.
Always try your triggers in Test Mode before switching to real money!

You can get a faster response from us if you contact us via FaceBook Messenger.

Присоединяйтесь к нашей официальной группе ВКонтакте!

  • All members
  • Posts: 191
  • Karma: +2/-0
  • Gender: Male
Re: A spreadsheet query please
« Reply #9 on: Tue, 14 March, 2017, 04:22 »
Thanks Oxa.

bobh