Author Topic: How to retrieve values from excel  (Read 2042 times)

Tags:
  • All members
  • Posts: 7
How to retrieve values from excel
« on: 23 Nov 2015, 09:55 »
Hi

Can i retrieve a value from excel?

Something like:
set user variable
Name: myvar value: =VLOOKUP(123,Sheet1!A1:B10,2)



Many thanks

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: How to retrieve values from excel
« Reply #1 on: 23 Nov 2015, 10:16 »
Yes, here's an extract from the manual, chapter "Triggered Betting - Reference - Variables - Excel-Bound Variables":

Syntax

cell_[sheet_name]_[cell_address]

The [sheet_name] and [cell_address] are the address of the cell a value is stored in. The sheet must exist in the Excel file MF Pro is connected to, and the cell's address must comply with Excel notation. For example:

- cell_sheet1_B3

- cell_mysheet_A4
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

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

  • All members
  • Posts: 7
Re: How to retrieve values from excel
« Reply #2 on: 23 Nov 2015, 10:59 »
Thanks for your quick reply,

but you can see from my example i want a value from a formula. I dont have a cell with a value. It's the return of vlookup that i'm interested.

Many thanks

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: How to retrieve values from excel
« Reply #3 on: 23 Nov 2015, 11:04 »
But you can insert this formula (or any formula for that matter) into a specific cell in your sheet and then read the value of that cell from inside MF Pro.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

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

  • All members
  • Posts: 7
Re: How to retrieve values from excel
« Reply #4 on: 23 Nov 2015, 11:20 »
I expressed myself badly.

From my example 123 is a variable.

I want something like a function.

So, i want to send a var to a cell with vlookup and catch the return value.

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: How to retrieve values from excel
« Reply #5 on: 23 Nov 2015, 11:23 »
You can try the Custom Cells then: it is possible to feed any variable or trigger expression to a predefined cell in Excel, and then read it back using a trigger.
Plenty of examples in the manual too, section "Excel Interface - Custom Cells".
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

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

  • All members
  • Posts: 7
Re: How to retrieve values from excel
« Reply #6 on: 23 Nov 2015, 11:56 »
I had read that part of the manual but didnt understand that way.

Feeling silly now.


Many thanks.

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: How to retrieve values from excel
« Reply #7 on: 23 Nov 2015, 12:32 »
Don't be, I'm here to shed light on all the obscurities of the manual. :)
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

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

 

Please note, BetFair is seems to be currently OFFLINE