Pages:
Actions
  • #1 by bobh on 08 Sep 2015
  • 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
  • #2 by MarkV on 08 Sep 2015
  • 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

     
  • #3 by bobh on 08 Sep 2015
  • Thanks Mark.

    I was using CalculationSheet!A1 - exclamation mark.

    I'll try your suggestion tonight.

    bobh
  • #4 by bobh on 08 Sep 2015
  • Perfect, thank you.

    bobh
Pages:
Actions