Author Topic: Balance in Excel  (Read 3391 times)

Tags:
  • All members
  • Posts: 57
Balance in Excel
« on: 27 Mar 2014, 05:48 »
Is it possible to show the current balance from MF into an Excel worksheet?

I have a simple spreadsheet I update for my records, and im currently manually entering in my BF account balance.

Cheers!

  • All members
  • Posts: 3597
Re: Balance in Excel
« Reply #1 on: 27 Mar 2014, 06:55 »
Hi
Yes.
Please have a look at the Excel Interface section of the manual so you know how to connect MarketFeeder to Excel.

You can use a trigger to do it using the Write to Excel trigger action:
address: {Sheet_name}!{cell_address}  e.g. MySheet!M3
text: [balance] here you enclose the variable name balance in square brackets

You can also set up a custom cell in the settings. Please see the Excel section of the manual on how to do this.
Cell Address: MySheet!M3 Cell Value: balance

Also if you have this setting ticked:
Excel > Export Account Statement to this sheet
the balance is updated with each entry on the statement, and it is easy to use a standard Excel formula to reference the cell to a cell on another sheet.
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.

 

Please note, BetFair is seems to be currently OFFLINE