- Works automatically. You only need to attach it to Guardian.
- It will show your manual trade 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.
- Easy to use
- Spot where exactly you lose or win money with your manual trades
More info and free download here:
http://excelbettingbots.com/manual-trade-analyser/
Let me know if you see bugs, errors!
Manual Trade Analyser (fully automatic)
Little bug fixed for race type 2 and 3.
Download the new version 7:
http://excelbettingbots.com/manual-trade-analyser/
Download the new version 7:
http://excelbettingbots.com/manual-trade-analyser/
Recommended guardian setup for manual pre trading with the Trade Analyser Bot:
- Load up all the horse racing markets into Guardian.
- Set Guardian to Auto-Bind Bet Angel Sheets. Second tab: “Excel”.
- Set Guardian to Auto-Clear Bindings. Second tab: “Excel”.
- Restrict Refresh: 900 sec (before start time) and 0 sec (after start time), “Advanced Settings” tab.
- Go to Guardian’s “Excel” tab and browse the excel bot file (select “All files” if you don’t see xlsm file) and click open workbook and tick ‘connect’.
You must close your trades (green all) before 0 (start time)! Because the bot will jump to the next market at 0 with these settings!
Obviously if you want to trade in-play you need a different time setup at the "restrict refresh" values.
http://excelbettingbots.com/manual-trade-analyser/
- Load up all the horse racing markets into Guardian.
- Set Guardian to Auto-Bind Bet Angel Sheets. Second tab: “Excel”.
- Set Guardian to Auto-Clear Bindings. Second tab: “Excel”.
- Restrict Refresh: 900 sec (before start time) and 0 sec (after start time), “Advanced Settings” tab.
- Go to Guardian’s “Excel” tab and browse the excel bot file (select “All files” if you don’t see xlsm file) and click open workbook and tick ‘connect’.
You must close your trades (green all) before 0 (start time)! Because the bot will jump to the next market at 0 with these settings!
Obviously if you want to trade in-play you need a different time setup at the "restrict refresh" values.
http://excelbettingbots.com/manual-trade-analyser/
New version 8:
- IRE Markets are added to the categories!
- New Number of Runners are added to the analyser matrix!
Download v8 here for free:
http://excelbettingbots.com/manual-trade-analyser/
- IRE Markets are added to the categories!
- New Number of Runners are added to the analyser matrix!
Download v8 here for free:
http://excelbettingbots.com/manual-trade-analyser/
New Version 9:
- Conditional Formatting color scale fixed!
Download the new version here:
http://excelbettingbots.com/manual-trade-analyser/
- Conditional Formatting color scale fixed!
Download the new version here:
http://excelbettingbots.com/manual-trade-analyser/
- MemphisFlash
- Posts: 2203
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
when are you ever going to produce a video that has narration rather than just wildly clicking boxes in excel. Useless!!!!
lol. Never! Grow up instead!MemphisFlash wrote: ↑Tue Sep 24, 2019 10:16 pmwhen are you ever going to produce a video that has narration rather than just wildly clicking boxes in excel. Useless!!!!
Probro is an extremely CC, but a clueless teacher.MemphisFlash wrote: ↑Tue Sep 24, 2019 10:16 pmwhen are you ever going to produce a video that has narration rather than just wildly clicking boxes in excel. Useless!!!!
yesrostov wrote: ↑Wed Sep 25, 2019 12:43 pmProbro is an extremely CC, but a clueless teacher.MemphisFlash wrote: ↑Tue Sep 24, 2019 10:16 pmwhen are you ever going to produce a video that has narration rather than just wildly clicking boxes in excel. Useless!!!!
New Version 10:
- Cleaned vba code. Less space.
- New matrix categories: Listed, Grp, Claim, Chs, Hunt, Beg, NHF, INHF, Flat
- New odds characteristic categories for Runner 1, 2, 3
Download here for free:
http://excelbettingbots.com/manual-trade-analyser/
- Cleaned vba code. Less space.
- New matrix categories: Listed, Grp, Claim, Chs, Hunt, Beg, NHF, INHF, Flat
- New odds characteristic categories for Runner 1, 2, 3
Download here for free:
http://excelbettingbots.com/manual-trade-analyser/
- MemphisFlash
- Posts: 2203
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
can't be much good if you bring out a new version every few days.
Sorry for the improvements!MemphisFlash wrote: ↑Sun Sep 29, 2019 10:46 amcan't be much good if you bring out a new version every few days.
- MemphisFlash
- Posts: 2203
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
you mean the improvements you corrected from the mistakes a few days ago. when can we expect version 11
New version 11:
- Conditional color scales fixed on the new bigger matrix from v10.
Download here for free:
http://excelbettingbots.com/manual-trade-analyser/
- Conditional color scales fixed on the new bigger matrix from v10.
Download here for free:
http://excelbettingbots.com/manual-trade-analyser/