Dear Lutfor,
It has been months since last time you wrote VBA Code to solve my Baseball
data collection problems successfully, I deeply appreciate your kind help.
From the Baseball official beginning day 3/28/2024 to yesterday 8/1/2024,
there are 1632 games played, suppose you bet evenly on each game $10 only,
if you bet all Favorite Team ( Before the Game Expected to win Team ), then
you will lose -$753.05 ; if you bet all Underdog Team or Dog Team ( Before
the Game Expected to lose Team ), then you will lose -$353.90.
With your consent last time I report my data analysis results to you just for
entertainment purpose, it seems that the only way you can win money is you
are the Casino boss!
It is crucial for me to get each Team ML values of each game played on
each specific day, sometimes 2 teams played 2 games on the same day
as Game1 and Game2, each Team G1 and G2 values are different,
depending on G1 and G2 Score results. Right now I spent hours after
hours manually input ML values for every Team every day and sum up
together to get the total win or lose amounts I just report to you. Enclosed
please find the Workbook named 2024MLBDEMYV3 you sent to me before,
I added new yellow highlighted Column F (V-ML) as Visitor ML Values,
yellow highlighted Column K (H-ML) as Home ML Values in Worksheet
Tab “SKD DOG”, and I added Every Team Symbol as worksheet, take the
Game played on 5/7/2024 as an example, Visitor Boston played at Home
Team Atlanta, for Boston I found its ML value in BOS worksheet tab
green highlighted L+167, then I input positive 167 in Column F(V-ML)
position, Deleting the Losing symbol L. For Atlanta I found its ML value
in ATL worksheet tab green highlighted W-183, then I input negative red
(183) in Column K(H-ML) position, Deleting the Winning symbol W.
It is too time consuming and painstaking to find each Team ML value
and input into SKD DOG worksheet. Could you design a VBA Code so
that it will fill all teams in all different days unique MV values instantly?
If the database missing the MV values you need, then fill the Blank with
“NA” which means Not Available. The whole Team name and its Symbol
Name is in the “TMS” worksheet tab. The original Team Score Results
and their specific MV values on specific days is from the website
in case you need more information from the original source site.
As everyday pass by, that website will add on new MV values
on each team, I guess I must add new MV values by hand, there is
no other way to update automatically. Correct? Anyway I appreciate
any help you can support me.
Thanks and regards,
Boy282828 8/2/2024
It has been months since last time you wrote VBA Code to solve my Baseball
data collection problems successfully, I deeply appreciate your kind help.
From the Baseball official beginning day 3/28/2024 to yesterday 8/1/2024,
there are 1632 games played, suppose you bet evenly on each game $10 only,
if you bet all Favorite Team ( Before the Game Expected to win Team ), then
you will lose -$753.05 ; if you bet all Underdog Team or Dog Team ( Before
the Game Expected to lose Team ), then you will lose -$353.90.
With your consent last time I report my data analysis results to you just for
entertainment purpose, it seems that the only way you can win money is you
are the Casino boss!
It is crucial for me to get each Team ML values of each game played on
each specific day, sometimes 2 teams played 2 games on the same day
as Game1 and Game2, each Team G1 and G2 values are different,
depending on G1 and G2 Score results. Right now I spent hours after
hours manually input ML values for every Team every day and sum up
together to get the total win or lose amounts I just report to you. Enclosed
please find the Workbook named 2024MLBDEMYV3 you sent to me before,
I added new yellow highlighted Column F (V-ML) as Visitor ML Values,
yellow highlighted Column K (H-ML) as Home ML Values in Worksheet
Tab “SKD DOG”, and I added Every Team Symbol as worksheet, take the
Game played on 5/7/2024 as an example, Visitor Boston played at Home
Team Atlanta, for Boston I found its ML value in BOS worksheet tab
green highlighted L+167, then I input positive 167 in Column F(V-ML)
position, Deleting the Losing symbol L. For Atlanta I found its ML value
in ATL worksheet tab green highlighted W-183, then I input negative red
(183) in Column K(H-ML) position, Deleting the Winning symbol W.
It is too time consuming and painstaking to find each Team ML value
and input into SKD DOG worksheet. Could you design a VBA Code so
that it will fill all teams in all different days unique MV values instantly?
If the database missing the MV values you need, then fill the Blank with
“NA” which means Not Available. The whole Team name and its Symbol
Name is in the “TMS” worksheet tab. The original Team Score Results
and their specific MV values on specific days is from the website
in case you need more information from the original source site.
As everyday pass by, that website will add on new MV values
on each team, I guess I must add new MV values by hand, there is
no other way to update automatically. Correct? Anyway I appreciate
any help you can support me.
Thanks and regards,
Boy282828 8/2/2024
Last edited by a moderator:
