@martyn-hemmens said in Spreadsheet/tools for managing trades.:

Hi, can’t seem to find any advice on how you keep track of your trades, different spreadsheets for different types of trade, or a single one, any pointers would be apppreciated, you can guess by the post I’m new to trading, thanks,
Martyn.

Hey Martin. I use this "Betting Tracker Worksheet" offered for free download at Australia Sports Betting
-GoogleSheets Version: http://www.aussportsbetting.com/tools/google-sheets-betting-tracker/
-Excel Version: http://www.aussportsbetting.com/tools/betting-tracker-excel-worksheet/

After trying dozens of simple and complex SpreadSheets Templates and those by my own craft; this is the one.

You can record as a category(s) and subcategory(s):
-Sports
-Markets
-Strategies
-Bookmakers
-Bankroll, deposits, withdrawal.

You can filter results of your TradeHistory, by Sport, by Market, by SubMarkets, by Strategy, etc.

I just work with Football, so I use that "category" to customize my strategies, and below the three, markets. Is fully adaptable to take out columns that not suit you. And add some columns for any specific data you need to keep track for every trade.

Keeping monitored you ReturnOfInvestment, Yield and BankRollover gives you a huge idea where you can improve or trash strategies, cut Losses, focus on ProfitableMarkets, etc.

Give a look and let me know any doubt. I did a few tweaks, to keep it simple and robust at the same time. An right now im adding BTCMembers strategies that i worked with, coz im new in this community.

I will be glad to offer you/any a Screenshot or ScreenAudioVideo meeting if its required. Because it would be overwhelming at first sight.

Cheers.

I use fairbot have for years, wouldn't change I love it. Simple does what I want.

I think the Q is though what do you want to use? I find personal preference with software, what do you want it to do?

@dean-adams Cheeky buggers! Nothing yet!

@martin-futter perfect thanks mate

TRhanks - not thought about scraping. I've done a little coding, enough to understand your youtube.

I need to find a site that displays soccer matches, and goal times for each match.

Then i can implement your script.

Thanks again.

maybe ask betangel customer service?

I tested traderline for Android phone last year. I have never tried trader program for pc, so perhaps I am not the right person to ask, anyway I think traderline has potential, the only anyoing thing is related to logging in. as I have turned -on two-factoring security on my Betfair account, every time I log in, I need to use both my password and the code from Google authenticater, so you loose some flexibility compared logging in with fingerprint. If we could use your fingerprint with in logging as with the Betfair app, this would be no probem. I am reluctant to turn off the two factoring security, so so far this is a major liability with this app in my opinion.

@andrew-heaney this would be cool. also the file that has the rules ready to load in

@gary-finnigan said in Trading Automation:

Don’t think geekstoy have automation or at least they didn’t hen I used it last year. Bet angel and fairbot are the most popular for automation , you also have bf bot manager if you just do automation but don’t do normal trading with the ladders

You can do all of the above with BF Bot Manager v 3.0. Normal ladder stuff is just 'Manual' system

@zachary-rascher There is some in built ones with Fairbot that they have, what are you wanting the charts to do?

Brilliant, thank you very much! Might try that in Bet Angel practice mode, but that sounds like a good idea. Cheers ledge!

This is how far I got at the moment.

Pavel has now delivered two scrap engines for the total sum of $70 (£53.13). $30 for Patternform and $40 for TimeForm. I have a folder on my desktop:

0_1551866169530_2019-03-06_1055_001.png

What I do is opening the horse_races_scraper and I get a menu where I put in a date and click on Download, either Patternform or TimeForm.

0_1551866536616_2019-03-06_1100.png

The data is then downloaded to either in PatternForm or TimeForm.

0_1551866683392_2019-03-06_1101.png

Patternform is the page I use pre race to find my selections, together with GeeGeez and Betfair. TimeForm is the page I use to get results, BSP and hi/low inplay numbers.

I have Pavel looking at GeeGeez and Betfair right now to determine what to scrape next. In the meantime, I have started to build a database in a program that I know how to handle, FileMaker.

0_1551867136280_2019-03-06_1111.png

FileMaker will not be able to cope with all the data and do all the calculations needed. I'm using it to understand, plan, test and evaluate before I pay someone to build it in SQL.

Yeh this is really sad, just started using it quite a lot! Oh well, hopefully I can improve my trading to the point I can buy it and stop being a cheap skate!

@james-h I use a lenova A10 520 All in one desk top it will run 3 Monitors one with HDMI and the other with \vga good graphics Screen size 23.5 Think i paid 700 last year from PC World

@adam-williams Thanks Adam. I will give it a try when my FastStone Capture free trial runs out. It's only about £20 anyhow but it is a good one, apart from it doesn't record Betfair for some bizarre reason.

There's a multi-match spreadsheet downloadable from the BA forum, and I think Peter's done a few videos on Youtube on how to place bets using Excel, they're linked from the BA Help document
https://www.betangel.com/user-guide/placing_basic_bets_or_trades_using_the_bet_angel_spreadsheet.html?ms=AAAAAAAA&st=MA%3D%3D&sct=MA%3D%3D&mw=MzIw

thank you very much, this makes it a lot easier.

best place to ask that would be on the bet angle forum i think you can look for matches as football-match odds and it should bring up a list