Hi Guys,
I'm new here so be gentle - please.
I've got as far as firing dutch bets into BF via BA spreadsheet using the 'BACK' command. What I need to do is to add a 'if unmatched take SP' command. Any ideas?
Thanks
Command help for newbie
Hi Stanley,
I'm assuming you're using VBA code to make the trade on the spreasheet, and that your code is called each time the sheet is updated (by the worksheet_change sub) ?
Get your code to step down the spreadsheet and look in columns 20, 21, 22 (for BACK) and 26, 27,28 (for LAY). If these cells have any values in them, then your trade has some (or all) unmatched values.
Ian
I'm assuming you're using VBA code to make the trade on the spreasheet, and that your code is called each time the sheet is updated (by the worksheet_change sub) ?
Get your code to step down the spreadsheet and look in columns 20, 21, 22 (for BACK) and 26, 27,28 (for LAY). If these cells have any values in them, then your trade has some (or all) unmatched values.
Ian