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
Help analysing data from Guardian in CSV file
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
Niko
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
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