Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 3rd February 2020, 07:52 PM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 1,602
Default UB February Thread

Well we are in February so thought I would get this thread up and ready to go.

As you would have read in the January thread I only teased out a small profit of $2837.

Last Years Result
Looking back at last years results that puts me a bit behind where I want to be. But by the end of Feb last year I had only cleared a profit of $10287.

This Months Target
My aim for the end of this month is to be somewhere in the vicinity of $20K-$30K for the year. I am aiming for $500 a day this year so I need to be at $25K by the end of Feb. For those interested my result last year was over $400 a day and that is why I want to up it to $500 a day this year.

Motivation Lacking
I am currently feeling a touch burned out and have not been able to put in the effort I expect of myself. The main reason for this is because I tend to burn the candles at both ends (up early and to bed late) which is usually ok but we have a new addition to the household which is a small puppy. It likes to interrupt my sleep and where I had solid sleep before it is now broken and I am struggling to get up early and am too tired to work late into the night. I am only doing about 3 hours per day and even my weekend was down with only about 7 hours per day put in. Tiredness leads to a lack of motivation and passion. I find the best solution to this is just put your head down and look at form or do some coding. Eventually the passion and motivation returns but you don't want to slow down just because your not motivated right now.
Reply With Quote
  #2  
Old 3rd February 2020, 11:12 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,530
Default

Yeah i can understand motivation, i spent about a week setting up my auto bet sheet to the point i thought i was happy with it to only feel disappointed.

The distraction of creating a simple pricing sheet for Qtab was good.
__________________
One Drive Chrome browser doesn't work

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #3  
Old 4th February 2020, 06:41 PM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 1,602
Default

Quote:
Originally Posted by Shaun
Yeah i can understand motivation, i spent about a week setting up my auto bet sheet to the point i thought i was happy with it to only feel disappointed.

The distraction of creating a simple pricing sheet for Qtab was good.


what disappointed you about it ? Was it not working how you wanted it to ?
Reply With Quote
  #4  
Old 4th February 2020, 09:11 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,530
Default

Quote:
Originally Posted by UselessBettor
what disappointed you about it ? Was it not working how you wanted it to ?


I know i need to get away from excel and more in to sql but that is easier said than done, so i knew after creating it that it won't handle the amount of data it needs to, because i built it in the same workbook as the bet placement program it will eventually slow down, so for now i will use it as a daily log of bets and create a separate workbook to record results to, one that won't need constant price updates.

The other reason is when i had that virus that wiped out 90% of my old workbooks i was struggling to remember old code i had used in the past that work for me, all good now a couple days on a different project was good, today i fixed up most of the issues is was facing.
__________________
One Drive Chrome browser doesn't work

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #5  
Old 5th February 2020, 05:47 AM
UselessBettor UselessBettor is offline
Member
 
Join Date: Sep 2011
Posts: 1,602
Default

Shaun,

A quick side story : My daughter came home yesterday and asked do I know C#. They need to learn to program using that language this year at school. She is in year 8. I don't know C# but I expect to learn it quickly (take a weekend) so i can help her out through the year. If a 13 year old can learn to code in C# you can easily learn SQL and databases as they are much easier.

For you to learn SQL you only need to know 4 statements.

SELECT "some columns" FROM "a table" JOIN "another table" WHERE "some filter"
INSERT INTO "a table" VALUES ("the values")
UPDATE "a table" SET "values"
DELETE FROM "a table" WHERE "a filter"

Quoted bits are the only bits you need to change. uppercase are the keywords you need to learn.


That is all there is to it at the basic level and that will do 99% of what you need.

You can write to the database using your Excel workbooks. If your comfortable with VBA and it does what you need then you just need to expand it to store all the data in a database. Your about 80-90% of the way there. Don't give up on it now.

Last edited by UselessBettor : 5th February 2020 at 05:49 AM.
Reply With Quote
  #6  
Old 5th February 2020, 07:11 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,530
Default

I think i am just being lazy, i will set aside time this week to watch a few youtube videos as i find i understand things visually.

Will also take note of your post.
__________________
One Drive Chrome browser doesn't work

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:55 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655