Auto Trade All Day - Spreadsheet

Example spreadsheets and comments on example spreadsheets.
MalleMax
Posts: 6
Joined: Thu Dec 26, 2013 9:22 am

thank you for helping , now i found the error, i must set in betangel preferences excel language to german. now it works.
uzain
Posts: 22
Joined: Mon Oct 10, 2016 8:33 pm

Added Trailing Stop.
You do not have the required permissions to view the files attached to this post.
User avatar
1clutch1
Posts: 12
Joined: Sun Feb 12, 2017 2:35 am

Is it possible to copy the dashboard to multiple sheets so the one dash would command many markets?
elofan0
Posts: 316
Joined: Fri Jan 13, 2017 4:44 pm

What i found was it greened up showed a profit then fired more bets in went negative ie loss should be a way to stop it firing ie stop at profit margin not let it carry on til loss shown
elofan0
Posts: 316
Joined: Fri Jan 13, 2017 4:44 pm

can you make it adjustable ie so can alter some settings manually that may help thanks
uzain
Posts: 22
Joined: Mon Oct 10, 2016 8:33 pm

how to upload xlsm file?
i am getting this error "Invalid file extension: BetAngel-auto-trade-v2.2.xlsm"
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Macro enabled files can host viruses so they'll be blocked by the forum software.
User avatar
Derek27
Posts: 23476
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

I'm sure I've uploaded a macro enabled spreadsheet on this forum!
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

It wouldn't have uploaded as a .xlsm file though, it is a bit silly they allow macros in earlier excel versions such as Microsoft Excel 97-2003 .xls files to be uploaded which can also contain macros just not later .xlsm files.
User avatar
Derek27
Posts: 23476
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

spreadbetting wrote:
Fri Apr 20, 2018 12:34 am
It wouldn't have uploaded as a .xlsm file though, it is a bit silly they allow macros in earlier excel versions such as Microsoft Excel 97-2003 .xls files to be uploaded which can also contain macros just not later .xlsm files.
You're right - it was an xls file containing macros.

It should really be up to the user if they trust the uploader's code, as macros are essential for much spreadsheet functionality.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

how to upload xlsm file?
you can upload it if you put it in as a zip file
uzain
Posts: 22
Joined: Mon Oct 10, 2016 8:33 pm

I did some modifications
- Sheet can record anything ( you can add any cell in CJ10:MB10 range)
- if you move to the next market it will clear data automatically .... (But for this sheet recording should be active... and DO NOT change the first cell which is market name cell)
- it will stop at certain profit ( didn't do anything for the loss because stop loss is already there)
- it can work with guardian but for that you have to add more worksheets and play around with code by pressing Alt+F11
You do not have the required permissions to view the files attached to this post.
uzain
Posts: 22
Joined: Mon Oct 10, 2016 8:33 pm

And by the way use that on simulated mode first please
eightbo
Posts: 2154
Joined: Sun May 17, 2015 8:19 pm
Location: Malta / Australia

uzain wrote:
Sun Apr 22, 2018 8:12 pm
I did some modifications
- Sheet can record anything ( you can add any cell in CJ10:MB10 range)
- if you move to the next market it will clear data automatically .... (But for this sheet recording should be active... and DO NOT change the first cell which is market name cell)
- it will stop at certain profit ( didn't do anything for the loss because stop loss is already there)
- it can work with guardian but for that you have to add more worksheets and play around with code by pressing Alt+F11
You must have accidentally unlinked the Control (Cell link) on the tickbox for the 4th runner of the dashboard which means it's stuck at TRUE in the version you uploaded. It should be linked to cell $BD$13 from what I can see.

Look forward to having a play with this tomorrow, cheers.
uzain
Posts: 22
Joined: Mon Oct 10, 2016 8:33 pm

Yea just checked. My mistake sorry
Post Reply

Return to “Bet Angel - Example spreadsheets”