Guardian profit/loss reports

Discussion regarding the spreadsheet functionality of Bet Angel.
jtrader
Posts: 160
Joined: Thu Feb 09, 2017 11:35 am

Derek27 wrote:
Mon Mar 18, 2024 7:57 pm
jtrader wrote:
Mon Mar 18, 2024 7:06 pm
Thanks,Derek27!

That's message when I've removed that row in code



Екранна снимка (814).png
Sorry, can you press the "Debug" button and show me a screenshot of the highlighted code where it failed.

That's

Екранна снимка (815).png

P.S. Could be good if I could attach pics in PMs, so as not to dilute the topics as I do right now!
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 25143
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

jtrader wrote:
Mon Mar 18, 2024 8:28 pm
Derek27 wrote:
Mon Mar 18, 2024 7:57 pm
jtrader wrote:
Mon Mar 18, 2024 7:06 pm
Thanks,Derek27!

That's message when I've removed that row in code



Екранна снимка (814).png
Sorry, can you press the "Debug" button and show me a screenshot of the highlighted code where it failed.

That's


Екранна снимка (815).png


P.S. Could be good if I could attach pics in PMs, so as not to dilute the topics as I do right now!
When it fails, try typing the first line you see in the immediate window (for ... next). It should display time, market name, win amount, lose amount and result. It may be that the CSV file is corrupt.

Also, try running it on individual days to see if it works on other CSV files and is just failing on one file. You can PM me if you wish.

Capture.PNG
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 25143
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Hi Simon, I've had to reply to your PM here because PMs don't allow attachments.

The version I'm using will be the same as the one you download from the forum, so I don't think that would help. But if you've got missing libraries, I think the problem lies there.

Go into VBA, (Alt+F11), Tools > References, and check you have the following libraries available. Not sure if all of them are necessary but these are the ones I have on my device.
Screenshot 2024-10-18 160542.png
You do not have the required permissions to view the files attached to this post.
Fugazi
Posts: 770
Joined: Wed Jan 10, 2024 7:20 pm

jamesedwards wrote:
Wed Mar 22, 2023 5:17 pm
MemphisFlash wrote:
Wed Mar 22, 2023 11:57 am
Capture.PNG

Well Pimped up now
Could you share this please?
Nah its more useful to ignore this and keep posting P&L
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”