New Posts For Thread: Betfair-Excel Questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-questionMost Betfair users are familiar with the graph icon to the left of a starter's name on the market display. Click on that icon and a Market Information box opens that contains graphs on the left, and on the right, a table showing odds and amounts avStarfish, were you able to write a macro to extract an accurate weighted average or just a fair approximation ? A bit of a challenge I fear for my limited capabilities, but I'll give it a go.https://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-question?post_id=430342094#430342094Starfish, were you able to write a macro to extract an accurate weighted average or just a fair approximation ? A bit of a challenge I fear for my limited capabilities, but I'll give it a go.Tue, 27 Apr 2010 05:43:58 -0500Certainly appears to be moving me closer to it, will have to kick the brain into gear to get it sorted properly.https://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-question?post_id=430342090#430342090Certainly appears to be moving me closer to it, will have to kick the brain into gear to get it sorted properly.Tue, 27 Apr 2010 05:15:47 -0500Thanks Starfish, looking at it right now.........https://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-question?post_id=430342086#430342086Thanks Starfish, looking at it right now.........Tue, 27 Apr 2010 05:05:51 -0500DIY spreadsheet, it feeds through the constantly updating prices to a section of columns on a worksheet, you can then use that data with your own formula in other columnshttps://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-question?post_id=430342082#430342082DIY spreadsheet, it feeds through the constantly updating prices to a section of columns on a worksheet, you can then use that data with your own formula in other columnsTue, 27 Apr 2010 04:52:15 -0500Was that via an off-the-shelf solution or a DIY spreadsheet ? Or no excel usage at all ?https://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-question?post_id=430342078#430342078Was that via an off-the-shelf solution or a DIY spreadsheet ? Or no excel usage at all ?Tue, 27 Apr 2010 04:41:23 -0500Personally I achieve what you're after for horse racing by using Gruss Betting Assistanthttps://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-question?post_id=430342074#430342074Personally I achieve what you're after for horse racing by using Gruss Betting AssistantTue, 27 Apr 2010 04:29:58 -0500Most Betfair users are familiar with the graph icon to the left of a starter's name on the market display. Click on that icon and a Market Information box opens that contains graphs on the left, and on the right, a table showing odds and amounts avhttps://community.betfair.com/general_betting/go/thread/view/94082/23870246/betfair-excel-question?post_id=430342070#430342070Most Betfair users are familiar with the graph icon to the left of a starter's name on the market display. Click on that icon and a Market Information box opens that contains graphs on the left, and on the right, a table showing odds and amounts avTue, 27 Apr 2010 03:37:50 -0500