Pages:
Actions
  • #1 by SteveB on 27 Mar 2014
  • 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!
  • #2 by MarkV on 27 Mar 2014
  • 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.
Pages:
Actions