Bet Angel - Example spreadsheets : Automatically Clear Individual Runners Back/Lay or Lay/Back Spreadsheet

Example spreadsheets and comments on example spreadsheets.
Post Reply
User avatar
CallumPerry
Posts: 201
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Sat May 05, 2018 6:38 pm

If anybody can come up with a better title for this spreadsheet, feel free to share lol

Firstly, thank you very much to: spreadbetting, nigelk and shaunwhite on this forum for helping me with this code this week.
BetAngel_Cal_Template.xls
Now let me explain what this spreadsheet can do. You will see a table underneath the instruction field with 6 runners available. Each has a "BACK" and a "LAY" trigger option. You write your own formulas in cells B34:G37 with outputs as 1 (BACK trigger/LAY trigger), 2 (Close a Back Trade/Close a Lay Trade) or nothing (dormant).

If you type a 1 in cell B34 then B31 will show "BACK" and you will issue a BACK order placed into the market. Once it has been placed the spreadsheet will wait for B34 to = 2 (your Close back trade formula) before doing anything else with that runner, therefore you wont be firing multiple orders into the market. This spreadsheet will be perfect for you if you have formulas to judge the direction of the market and forecast swing trade opportunities. Each time the system will reset the moment a previous trade has been placed so you can develop an autonomous system.

You can type anything into the instruction field (for example cell L9) like a normal Bet Angel template to adjust your strategies live as the system uses macros. What makes this powerful is you can control, with your formulas, specific entry/exit points for multi-directional trades.

It's difficult to explain really so I recommend just having a play (it's quite easy to figure out what's going on) and if you have any questions or feedback, i'd love to hear either :).

Please, if you spot any bugs or errors popping up, let me know in this thread. Goes without saying but for new traders, please test with your own formulas extensively in practise mode first (I recommend using alongside the ladder screen) before using your own money!

Callum :)
You do not have the required permissions to view the files attached to this post.

elofan0
Posts: 95
Joined: Fri Jan 13, 2017 4:44 pm

Fri Aug 10, 2018 12:09 pm

thanks for sharing callum a video would be nice to see on this as i get a bit mesmerised with some spread sheet inputs etc ...

User avatar
CallumPerry
Posts: 201
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Fri Aug 10, 2018 12:20 pm

Ok mate, I'll see if I can record a quick one later for you! :)

elofan0
Posts: 95
Joined: Fri Jan 13, 2017 4:44 pm

Fri Aug 10, 2018 12:50 pm

ok thanks Callum appreciated :)

User avatar
CallumPerry
Posts: 201
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Fri Aug 10, 2018 8:08 pm

https://youtu.be/MerPmAunL58

Here you go mate, first time ever using screen recording software and explaining so I didn't do a brilliant job but hopefully there's enough good info there for you to pick up on how the sheet works.

Basically once a Back has been placed only a back closed can send it back to 'A' and same with Lay, only a Lay close can follow so be careful how you programme your 'triggers'. Any questions just ask :)

elofan0
Posts: 95
Joined: Fri Jan 13, 2017 4:44 pm

Fri Aug 10, 2018 9:17 pm

thanks Callum well done with the video ... great job !!! and a new angle for you :)

elofan0
Posts: 95
Joined: Fri Jan 13, 2017 4:44 pm

Fri Aug 10, 2018 9:20 pm

left you comment and subbed you on you tube :)

User avatar
CallumPerry
Posts: 201
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Fri Aug 10, 2018 10:34 pm

Thanks mate! Was interesting doing a video today and good to finally get some screen recording software that I will use with my trading in the near future. I'm hoping you find use for the spreadsheet, any suggestions are welcome.

elofan0
Posts: 95
Joined: Fri Jan 13, 2017 4:44 pm

Fri Aug 10, 2018 10:48 pm

Hi callum for some reason its only allowing 1 runner to be used cant try it on a full field til tomorrow i just accessed a tennis match something do with the macros i think .. it says macro not available in this work book etc or disabled

User avatar
CallumPerry
Posts: 201
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Fri Aug 10, 2018 10:59 pm

PM me mate, will work out with you where it's going wrong in the morning :)

Post Reply

Return to “Bet Angel - Example spreadsheets”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest