Chat GPT
-
I know I'm late to the show, but I just downloaded Chat GPT today.
I then copied my filter results from the 19th May and asked Chat GPT this....
"Show me the scores for 19th may 2024 for these teams and put them in a google sheet"
It then showed me the scores for all 84 teams I asked for and put them into a Google sheet for me.
This is an absolute game changer for me, no more inputting each score for each team individually, I just copied and pasted from Chat GPT into my spreadsheet, I'm no tech god so this just mega wow for me, wish I'd discovered this ages ago
Does anyone else do this and do they have any tips on what more it can do to help.
-
Morning Simon,
I have been looking into Chat GPT for the very same thing over last month, as completing my spreadsheets is the most time consuming aspect of my trading. I was uploading a spreadsheet to GPT of around 10 matches at a time requesting HT,FT and goal times for the respective matches.
However even using chat 4o, when I cross referenced the results, I found it to be inaccurate around 50% of time with either incorrect scores and /or goal times. I even directed it to specific websites and it still retrieved incorrect information.
For me I lost confidence in chat to provide me with accurate info, so have gone back to the manual updates of my spreadsheet.
Maybe I wasn't using the correct prompts, but to get all 84 matches correct is a game changer..!! -
I had used GPT previously and found it really useful stuff so many things for me I've never thought about it for inputting results so I upgraded to the latest version as per Ryan's suggestion and it actually started bringing in my results to the spreadsheet, I made sure I did it in small chunks but after 20 or so results the Chat GPT bot came back saying it was unable to obtain the data ...I guess the server on sofascore etc is set up to refuse multiple requests ....I thought about learning some coding skills and although it would be useful it would take me just as long as it would to input manually all the results Im missing ...
has anyone else found a way to get previous results for simple stuff like HT FT score shots and timings of goals ? -
@Gary-Calvert Nice bit of verification there! Thanks.
-
@Ryan Pretty impressive isn’t it, so if you have a mathematical problem you can’t work out trading or want an instant answer, definitely worth running it through AI.
I’ve often wondered how to calculate combined probabilities for strategies such as this and others that are similar; Home and away have plus 50% chance each of something happening or if there are 4 probabilities involved that amount to what seems like more than 100%..Thank you AI, I’ll think of the ideas, you can do the maths! Lol.
-
In football if the two teams each have a 45% of scoring a goal and a 45% of conceding a goal what is the overall percentage chance of a goal being scored?
This is what Pi Said
To find the overall percentage chance of a goal being scored in a football match when both teams have a 45% chance of scoring and a 45% chance of conceding, you can use the concept of complementary probabilities.
First, let's calculate the probability of neither team scoring a goal. Assuming the events are independent, the probability of both teams not scoring is:
(1 - 0.45) * (1 - 0.45) = 0.55 * 0.55 ≈ 0.3025 or 30.25%Now, the overall percentage chance of a goal being scored (either by Team A or Team B) is equal to 1 minus the probability of neither team scoring:
1 - 0.3025 = 0.6975 or 69.75%
So, in this scenario, there is approximately a 69.75% chance that a goal will be scored in the match. -
@Chris-King That's insane!!!
-
@declan-henderson Just google your question chap, and you’ll get all the info.
‘ChatGPT is a chatbot and virtual assistant developed by OpenAI and launched on November 30, 2022. Based on large language models, it enables users to refine and steer a conversation towards a desired length, format, style, level of detail, and language. Wikipedia’
-
@Simon-Bates whats chat gtp.
Apologies, I'm only subscribed 3 months and still working out this forum. This would be pretty cool for pulling up scores as I do it manually
-
Been playing about with Chat GPT myself and wanting to create a filter for SHG between 60’ mins and FT to split stake the over 0.5G market entering at 60’ and 75’ minutes and looking to achieve a strike rate of approx 70% chance of a goal using the following filter;
I asked Chat GPT the following, and received this response which i was pretty pleased about;
Me - In football if the two teams each have a 45% of scoring a goal and a 45% of conceding a goal what is the overall percentage chance of a goal being scored?
Chat GPT - To determine the overall percentage chance of a goal being scored in a football match, given that each team has a 45% chance of scoring and a 45% chance of conceding a goal, we can use the following reasoning:
1. The probability that Team A scores a goal is 45% (or 0.45). 2. The probability that Team B scores a goal is also 45% (or 0.45).To find the probability that at least one goal is scored in the match, we need to consider the complementary probability — that is, the probability that no goals are scored by either team.
The probability that Team A does not score a goal is (1 - 0.45 = 0.55).
The probability that Team B does not score a goal is also 1 - 0.45 = 0.55.The probability that neither team scores a goal (no goals at all) is:
P(\text{no goals}) = 0.55 \times 0.55 = 0.3025Therefore, the probability that at least one goal is scored is:
P(\text{at least one goal}) = 1 - P(\text{no goals}) = 1 - 0.3025 = 0.6975So, the overall percentage chance of at least one goal being scored in the match is:
0.6975 \times 100% = 69.75%Thus, the overall percentage chance of a goal being scored in the match is 69.75%.
-
@Gary-Calvert thanks for this, I'm going to have a play around with it and see what I can get it doing, I'll update this post with any progress I make from it
-
3 simple example questions for help from Ai
any off the cuff calculations can be asked and help with spreadsheet formulas,
eg: I have had 4 wins from 14 trades, what minimum odds do I need and how do I get this into a spreadsheet.
You have to be carefull with answers and double check them certainly when first asking, as I found out that if I asked for true odds based on probability answer was 2.5, if I asked for true betting decimal odds based on probability answer was 3.5
answers can be long winded but useful
What % of 14 is 4
To find the percentage, you can divide the value (4) by the total value (14) and then multiply the result by 100. Using this formula, we get:
(4 / 14) * 100 = 28.57
So, 4 is approximately 28.57% of 14.If the probability of a win is 28.57%, what are the true decimal betting odds
If the probability of a win is 28.57%, the true decimal betting odds can be calculated by taking the inverse of the probability. Here's the calculation:
1 / 0.2857 = 3.5
So, the true decimal betting odds for a win with a probability of 28.57% are approximately 3.5. This means that for every 1 unit you bet, you would win 3.5 units (including your initial stake) if your prediction turns out to be correct.in excel, Column A = Games, Column B = Wins, Column C = Probability, can you create me the formula work out the probability for column c
To calculate the Probability in Excel using the given columns, follow these steps:
Add headers to your columns if not already present:
Column A: "Games"
Column B: "Wins"
Column C "Probability"
Enter the following formula in cell C2 to calculate the probability:
=B2 / A2
This formula calculates the probability of winning by dividing the number of wins (Column B) by the total number of games played (Column A).
Press Enter to calculate the result for the first row.
Select cell C2 and click and drag the fill handle (the small square at the bottom right corner of the cell) to apply the formula to the remaining cells in column C.
Now, the "Probability" column will display the calculated values based on the number of games and wins in columns A and B.
Note that this formula assumes that columns A and B contain whole numbers representing the number of games and wins, respectively.in excel, Column C = Probability, Column D = True decimal betting odds can you create me the formula work out the column d
To calculate the True Decimal Betting Odds in Excel using the given columns, follow these steps:
Add headers to your columns if not already present:
Column C "Probability"
Column D "True Decimal Betting Odds"
Enter the following formula in cell D2 to calculate the True Decimal Betting Odds:
=1 / C2
This formula calculates the True Decimal Betting Odds by taking the inverse of the probability value in Column C.
Press Enter to calculate the result for the first row.
Select cell D2 and click and drag the fill handle (the small square at the bottom right corner of the cell) to apply the formula to the remaining cells in column D.
Now, the "True Decimal Betting Odds" column will display the calculated values based on the probability in column C.
Note that this formula assumes that column C contains decimal probabilities rather than percentages. If your probabilities are in percentage format, adjust the formula to:
=1 / C2 / 100
This version of the formula converts the percentage values to decimal probabilities before calculating the true decimal betting odds. -
@Simon-Bates I used a free Ai called Pi https://pi.ai
I tried it again with about 8 matches from yesterday and its first results it gave were all historical, so pretty useless, if I point it to the webpage it gave the correct results from yesterday, I'll keep trying to see if it starts to learn where to get upto date data from.
I think that the best possible use for Ai going forward will probably be in data analysis of trading records/results.
I've checked the Flashscore website for the Obos-ligaen (Norway) results, and it looks like there were several matches played yesterday, May 22, 2024. Here are the scores for those matches:
Bryne 2-0 Aalesund
Ranheim TF 3-0 Stabæk
Kongsvinger 3-2 Mjøndalen
Egersund 2-2 Levanger
Sogndal 1-1 Raufoss
These scores are based on the information available on Flashscore and may be subject to change or correction. I hope this helps! Let me know if you need any more information. -
@Gary-Calvert have you tried this with other games to get the results, what was the app you used, the one you used seems to be able to go to websites, Chat GPT that I tried wasn't allowed.
-
@Akiva-Anderson I've seen you mention this before, is it an app or website, and what does it do for you?
-
I tried this in Pi, Ai after your post, it got there in the end.
Ansan Police Suwon Bluewings
Henan Jianye Shanghai Shenhua
Show me the scores for 21st may 2024 for these teams and put them in a google sheetSure, I can do that! But before I do, could you clarify if you're interested in the scores of both the Chinese Super League (Henan Jianye vs Shanghai Shenhua) and K League 2 (Ansan Police vs Suwon Bluewings) matches? Or just one of them?
both
Unfortunately, I wasn't able to find any specific scores for the Ansan Police vs Suwon Bluewings and Henan Jianye vs Shanghai Shenhua matches scheduled for May 21, 2024. It's possible that these matches haven't taken place yet, or that the scores haven't been updated online.
If you'd like, I can help you keep an eye out for updates on these matches and let you know as soon as I find any information about the scores. Would you like me to do that?have you looked on the flashscores site for the results, they have been played and the results are online
Ah, my apologies! I found the score for the Ansan Greeners vs Suwon Bluewings match on May 21, 2024. The final score was 1-0, with Ansan Greeners winning the match. However, I was unable to find any results for the Henan Jianye vs Shanghai Shenhua match. Could it be possible that this match was postponed or canceled?
Henan Jianye are sometimes called Henan Songshan Longmen, try looking for that
Thank you for the additional information! I was able to find the score for the Henan Songshan Longmen vs Shanghai Shenhua match on May 21, 2024. The final score was 1-2, with Shanghai Shenhua winning the match.
So, to summarize, the scores for the matches you requested are:
Ansan Greeners 1-0 Suwon Bluewings
Henan Songshan Longmen 1-2 Shanghai Shenhua
I can add these scores to a Google Sheet for you if you'd like. Just let me know if you want me to create a new sheet or add the scores to an existing one. -
I prefer Grok. It has up-to-date information as it gleans it from Twitter
le jeu avant tout
Am Yisrael Chai
When you got skin in the game, you stay in the game
But you don’t get a win unless you play in the game... -
@Simon-Bates This could have been brilliant, I can't wait till you can upload your google sheet and say fill in the scores....
-
Scrap this, I knew it was too good to be true
I double checked a few scores after it gave me the info I asked for yesterday and a few were wrong, apparently it doesn't give up to date scores.
-
@Simon-Bates said in Chat GPT:
@Martin no more, copy team, going to Google, finding the result, inputting result into your spreadsheet, next team, repeat, I don't mind having all them filter selections now cos recording results just got a whole lot easier
Forward testing just got a whole lot easier! Good work!
