Manual Trade Analyser (fully automatic)

Example spreadsheets and comments on example spreadsheets.
Post Reply
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

- 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!
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

Little bug fixed for race type 2 and 3.

Download the new version 7:
http://excelbettingbots.com/manual-trade-analyser/
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

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/
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

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/
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

New Version 9:

- Conditional Formatting color scale fixed!

Download the new version here:
http://excelbettingbots.com/manual-trade-analyser/
User avatar
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!!!!
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

MemphisFlash wrote:
Tue Sep 24, 2019 10:16 pm
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!
rostov
Posts: 50
Joined: Mon Jul 02, 2012 3:45 pm

MemphisFlash wrote:
Tue Sep 24, 2019 10:16 pm
when 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.
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

rostov wrote:
Wed Sep 25, 2019 12:43 pm
MemphisFlash wrote:
Tue Sep 24, 2019 10:16 pm
when 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.
yes
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

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/
User avatar
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.
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

MemphisFlash wrote:
Sun Sep 29, 2019 10:46 am
can't be much good if you bring out a new version every few days.
:lol: Sorry for the improvements!
User avatar
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
User avatar
probro
Posts: 81
Joined: Sun Jun 19, 2011 6:32 pm

New version 11:

- Conditional color scales fixed on the new bigger matrix from v10.

Download here for free:
http://excelbettingbots.com/manual-trade-analyser/
User avatar
MemphisFlash
Posts: 2203
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Boring!!!!!
Post Reply

Return to “Bet Angel - Example spreadsheets”