Author Topic: Importing a cell value from Excel  (Read 1697 times)

Tags:
  • All members
  • Posts: 231
  • Gender: Male
Importing a cell value from Excel
« on: 08 Sep 2015, 07:06 »
Hi again,

Apologies, but my brain has frozen today!

The value of my next bet is calculated in Excel which is connected to MFP. It needs to be calculated in Excel because it depend on several factors non related to MFP (eg self assessment of race quality etc).

How can I import that amount to bet into the trigger? If so, what is the import convention?

The value is calculated in an Excel worksheet named CalculationSheet.

Thanks,

bobh

  • Moderator
  • Posts: 3597
*
Re: Importing a cell value from Excel
« Reply #1 on: 08 Sep 2015, 08:55 »
Hi
In the amount field try: cell_CalculationSheet_A1
where A1 is the Excel cell reference

or to use in a condition for example:
and selections back price is greater than cell_CalculationSheet_A1

 
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: 231
  • Gender: Male
Re: Importing a cell value from Excel
« Reply #2 on: 08 Sep 2015, 09:45 »
Thanks Mark.

I was using CalculationSheet!A1 - exclamation mark.

I'll try your suggestion tonight.

bobh

  • All members
  • Posts: 231
  • Gender: Male
Re: Importing a cell value from Excel
« Reply #3 on: 08 Sep 2015, 12:23 »
Perfect, thank you.

bobh

 

Please note, BetFair is seems to be currently OFFLINE