Author Topic: Excel macro and bets  (Read 1891 times)

Tags:
  • All members
  • Posts: 2
  • Karma: +0/-0
Excel macro and bets
« on: Mon, 25 March, 2013, 13:39 »
Hello,
I would like to use MF for some automatic betting, but how could I do this? :
- if in cell A1 is value TRUE then lay team 1 for stake 50euro ...
(I will you macros for determining if I want to lay, back or what)

I found triggers and this > "cell_{sheet_name}_{cell_address}" but I have no idea if I can use it and dont know how ... It is possible to help me somehow? thank you for any help !

  • Administrator
  • Posts: 6933
  • Karma: +231/-0
  • Gender: Female
*
Re: Excel macro and bets
« Reply #1 on: Mon, 25 March, 2013, 20:18 »
Hello,

Yes, checking the value of the variable cell_{sheet_name}_{cell_address} is the right thing to do in your case. You don't need any macros though.

So for instance you need to check A1 in the sheet named "MySheet". Then the variable containing this value will have a name of cell_MySheet_A1.

I'm attaching a sample trigger that will lay on the first team if this variable is less than 10. You need to make sure that by the time you start triggers you have MF Pro connected to an Excel worksheet where there is a sheet named "MySheet".
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Usuários brasileiros, bem vindos ao nosso WhatsApp chat!

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

  • All members
  • Posts: 2
  • Karma: +0/-0
Re: Excel macro and bets
« Reply #2 on: Tue, 26 March, 2013, 16:11 »
thank you, but I have to use macro because ... because :)
I will try your solution, I thought It should work, will see :)

  • Administrator
  • Posts: 6933
  • Karma: +231/-0
  • Gender: Female
*
Re: Excel macro and bets
« Reply #3 on: Tue, 26 March, 2013, 18:46 »
I didn't mean you can't use macros. By all means do it if you must. What I meant was that you don't have to create a special macro for doing something that a simple trigger can do.

By the way, if you want to use MF Pro in connection with a spreadsheet that has macros, then first create such a spreadsheet, program it as needed and always open it before pressing the "Launch Excel" button. This way MF Pro will connect to it rather than create a new Excel instance.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Usuários brasileiros, bem vindos ao nosso WhatsApp chat!

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