This is a fully automated all day working Manual Trade Analyser Spreadsheet for Betfair Horse Racing (UK) markets. It can be essential for Manual Traders! The spreadsheet collects data in the background while you trade manually on the markets and it creates an easy to see Profit/Loss distribution view about your manual trades. You need to have Bet Angel Professional subscription and Excel (min. 2010) to use this bot!
(New version) On the picture you can see an illustration of a manual trade P/L dispersion. By using this spreadsheet you can easily spot where you lose and where you win money on the long term after many trades! So you can avoid harmful situations or increase stakes where you are strong!
You can analyse your trade by every uk course name. Different courses have different market behavior.
You can see the result difference according to “when you finished your trades”: in-play or before in-play.
You can determine which course distance is the worst or the best for your trades (particularly in-play).
You can also easily see the race type impact of your trades by every UK course names. Different race types have different market behavior.
It’s well known that markets are behave differently with different odds texture, you can determine which favourite odds is the best or worst for your manual trades.
You can see which part of the day is better for your trades: after or before PM 6:00.
You can also easily see which day of the week is the best or the worst for you (sum or broken down by course names).
Important! You have to Greenup/Redup the whole market before it ends, otherwise it is not trading (it’s gambling) and the bot will not show you proper results!
- Very easy to use!
- You can attach the sheet manually to every new market or you can setup guardian to do it automatically for you as well, choose whatever it fits you better!
- Only UK horse racing markets are supported! No problem if you use it on other markets, but the results will go to the “Others” row category.
- You can use it on pre market or in-play too, but you have to close all trades (greenup the market) before the race ends and before the sheet jumps to the next market!
- You don’t have to change anything on the sheet it just works automatically!
- It will show your Profit/Loss distribution by course names and by other categories: Hcap, Not Hcap, Nov, Mdn, Sell, Nursery, Stks, Hrd, Chs, Favourite Odds 1-2, Favourite Odds 2-3, Favourite Odds 3-4, Favourite Odds 4+, Trade finished in-play, Trade finished pre market, different market distances, after or before 6:00 PM, day of the weeks.
- It will show you how many markets you have traded, All Matched Back/Lay bets, All Matched Back/Lay Stakes by course names.
- You can easily spot where exactly you lose money! And you can make more profit by simply avoid them!
- You can also spot where you are the strongest so you can increase your stake to make more money on them!
- You can use it for analyse your excel bot trades as well, but you have to run them on two separate PC-s (or virtual machines) with the same betfair account and in real money mode, since you can’t run 2 different spreadsheet on one market.
- And of course you can setup Bet Angel’s Automation Bot too, in this case you don’t have to trade manually, the Analyser spreadsheet will work anyway.
- VBA is not protected.