Fill each Baseball team specific MV values on specific days

Boy282828

New member
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
 

Attachments

Last edited by a moderator:
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

https://www.covers.com/sport/baseball/mlb/teams

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
Thank you for reaching out and your kind words about our past collaboration. We are glad that the VBA code Lutfor provided for your baseball data collection has been helpful.

However, we want to let you know that we've decided to no longer work on projects related to betting or gambling. This decision is based on personal and professional reasons.

We appreciate your understanding in this matter. If you need assistance with other types of data analysis or VBA-related tasks that do not involve betting, We'd be happy to help where we can.

Thank you for being so understanding and best of luck with your project.
 
Dear Shamimarita,



Thank you for letting me know that you are against anything with gambling or

betting. The purpose of my collection Baseball data is to prove that Betting is

not Good, you will LOSE MONEY, therefore discourage people from betting

with Mathematical real data proof, not encouraging people to gamble.

In other words we have the same ideology, I must explain it clearly to avoid

misunderstanding that I encourage people to gamble.



Next time when I need Lutfor’s help, I will state it clearly what is my intended

Use of VBA Code to get approval from you. Can I use the VBA Code to do

research work in Stock Trading Investment? It is perfectly legal, not something

illegal. If you don’t like the Stock Investment Research work, I will not ask

Lutfor for help to save both of us precious time. What do you think? Is it OK

or not? Your response is deeply appreciated.



Thanks and regards,



Boy282828 8/3/2024
 

Online statistics

Members online
0
Guests online
17
Total visitors
17

Forum statistics

Threads
361
Messages
1,581
Members
673
Latest member
smathieu13
Back
Top