Help analysing data from Guardian in CSV file

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
bigpapaperry
Posts: 18
Joined: Sat Feb 13, 2021 1:18 pm

https://spreadsheeto.com/text-functions/

THe Left, Right or Mid function lets you get data from any string
i use this which is not very hard just takes a few practices to see what is does and what you need then it would take you seconds to convert from pic 1 to pic 2
User avatar
nikolong
Posts: 18
Joined: Thu Nov 30, 2017 8:27 pm

I have 3 or 4 parameters that I use, I store them at post time, using stored values like you. some I get from doing a small calculation from the appropriate data. I export them to a spreadsheet and it only takes about ten minutes to tidy everything up and put the profit and losses in. Maybe you could cut back on the amount of stored values that you are using?
Niko
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Jas

If you search for NigelK trading record(er) I recall that it had a sheet within it that extracted elements inline with what you are looking to do. That might help but =LEFT() =MID() =RIGHT() are handy to use
JasBarrow
Posts: 138
Joined: Tue Sep 18, 2018 3:03 pm

Thanks guys some more food for thought
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”