Just ORL and IND
-
Comment -
hey 808,
Your numbers and mine do not match and i'm wondering why? Do you change the date on the spread sheet?? and if so what is the date that your system is calculating from??
thanksComment -
Formulawiz... Why is Nuggets not a play??? Yikes! I knew I didn't totally understand this yet! Please explain if you have time.
SOXROCK... The numbers I've been using just comes from the website that Formulawiz referred to in an earlier post. I don't have the spreadsheet.
Good Luck Everyone!!Comment -
Formulawiz or anyone,
I just downloaded the excel spreadsheet Ver7, & I am going thru the Procedures to use the spreadsheet (found on page 11 post #354) I was doing just great on all the Procedures until I got to Procedure #8, can someone please walk me thru this procedure. It states " Make sure you entered lines from the Stats tab only, if lines are not entered you will get incorrect plays." I am not sure what lines in the State tab you are referring to & where do I enter them. Please help, I would love to learn this system I read thru every post & I am really trying to do my homework before I ask any questions. Thanks in advance for your Time & SupportComment -
Formulawiz
I almost forgot to ask, What is the date I should put inside the Green Box labled (Compute Power Averages based upon date). Thank YouComment -
Todays Plays
Yesterday our system went 1-1
YTD 81-51=61.4
Yesterday we were saved again by Sportrends opposite play on ORL/PHO game and therefore there was no play. Sportrends PR's went 2-0 yesterday and the PR plays have been kicking ass the entire season.
Todays plays based on early lines
BOS - 9 or <
ATL - 1, @ pick no play
WAS + 4 or > sportrends PR has opposite play so staying away from game.
GS + 5 or >Comment -
Formulawiz,
Please walk me thru procedure #8 , I dont want to make a mistake, Please give me a example of how to use this program when I get to step #8. I am not very good with excell but I do learn quick,
Also when I open up the spreadsheet it asked me do I want Macros Enabled or Disable Macros what should I put there.
(Compute Power averages based upon date) What should this date read, I accidently changed it and dont remember what it was before I changed It. Sorry
My Bad !!!! Thank you for your Support with this Newbie.Comment -
Formulawiz... PR plays are going off!
Here's the plays I get today off the website. Should I be downloading the spreadsheet instead of using the one they post? Or am I getting discrepancies for other reasons? Thanks again!
Nets (95+3+7) vs. Celts (108)... advantage Celts by 3
OKC (97+3-4.5) vs. Wiz (91)... advantage OKC by 4.5
Clips (88+3-2) vs. Mem (92)... advantage Mem by 3
Good Luck Everyone!Comment -
I read all thread, and printed most important post. If I understood... according Formulawiz
Capper808
a) you are using H or A PR: you have to use Overall
b) don't add +3 (no OKC)
c) Clips rule 3 (no play)
I'm a correct?
Formulawiz....
I downloaded database 7
a) closing lines and score 03/03 are in Lines
b) in Stats results and line only till 02/06.... why?
c) running macro updat score "error 91 run time": debugging startRow = rFound.row is yellow
can anyone help me?
txComment -
so the plays are?Comment -
caracalla... I'm verifying Sportrends PR plays and not Formulawiz's system. He was helping me get a handle on how to use that system. Sorry for the misunderstanding. Thanks for you input though.
Good luck to all!Comment -
what is the consistency of these picks?Comment -
Todays NBA Plays
Yesterday our system went 0-2
YTD 81-53=60.4%
Based on early lines DAL + 4 or >Comment -
I beg your pardon.... i read all thread
I downloaded database7 and I tried to run it, but....
a) yesterday automatic lines and scores are OK (today I've 04March)
b) Schedule is OK Updated till 04March
c) Stats are updated only till 06Feb (have I to fill manually?)
d) Ratings till 06Feb
e) team stats till 03March (when I downloaded database7)
When I try macro update-scores error run-time 91 (debugging startRow = rFound.row is yellow) (either excel2003 than excl2007)
Can anyone explain me , step by step, what have I to do?
Best greetings from Italy
CaracallaComment -
But have you to insert something manually?
Can you attach your updatd database7 so I can study with all data inserted and, perhaps, find error?
TxComment -
Todays NBA Plays
Yesterday our system went 0-1
YTD 81-54=60%
Based on early lines todays plays are as follows
PHO + 4 or >
GS + 5.5 or > @ 10 no playComment -
Today's NBA Plays
Yesterday our system went 1-0
YTD 82-54=60.3%
Ill be back later. As of now GS is an opposite sportrends PR play and will stay away from game.
IND - 5.5 or <Comment -
I understood my spreadsheet problem.... my excel is italian version, so date is gg/MM/aa and in number . is , and , is .
I'm trying to have an english excel version, mainwhile a friend of mine are changing VBA macro.
More... I have my method for NCAA BB and I posted my bets on NCAA forum. I stopped, as usual, 2 weeks before ending regular season because unpredictable. Yesterday I filtered my choices with your method and so, from 10 I had only 2: James madison (-3 won) and Ill State (-4.5 won)... $$$ for me
Today from 30 I had only one: Sou Caro -5Comment -
South Caro 68/51... bet won
I stopped 19Feb with final result 333/282/13 0.541463 % (last week was 53/62)
From 20Feb, if I had bet, I would have 40/52 (next year last 3 weeks probably I'll really bet, but contrarian)
Yesterday I started studying Your method: if i had bet only mine I would have 4/6: mine+yours 2/0
so far today only mine 3/4, mine+yours 1/0
VERY GOOD FILTER,
THANK YOUComment -
Todays Plays
Yesterday our system had no plays
YTD 82-54=60.3
Yesterday we all should have had a win with sportrends PR play on CLE. As I also mentioned yesterday we had opposite plays on the GS/MIL game so you should have passed on this game.
As far as the IND game that line went from - 5 to - 7 and thats why its important to wait until 10 to 15 minutes before game time to see where the public is driving the lines to.
Based on Early lines today
PHO + 6 or > if not sportrends opposite play
DEN - 9.5 or <Comment -
No bet for me on NCAAComment -
i have phoenix +4.5 is this the oppiste play now?Comment -
According my system there was 10 bets. No one good for yours... so no bet for me!!
Pho lost by 5,so +4.5 was bad, +6 was good (I bet +5)
But why +6? Table said +4.5 or more
Filtered by other system?Comment -
Todays NBA Plays
Yesterday our system went 0-1
YTD 82-55=59.9%
Yesterday sportrends PR plays went 2-1 and their PR play on SAN saved us a loss on PHO.
Based on early lines today
ORL - 4.5 or <Comment -
Todays NBA games
Yesterday our system went 0-1
YTD 82-56=59.4%
As I mentioned in earlier posts we should be looking at our systems overall PR's, H/A PR's and sportrends PR's to get our plays. Yesterday our systems H/A PR's went 2-1 with ATL, ORL and POR. Since Data one of our contributers helped updated the NBA spreadsheet on FEB 20th so it can keep win/loss records, I have been keeping a win/loss record of the H/A PR plays which is now at 23-13 = 64%. Just a reminder to look at everything.
Data has also helped automatically update scores, lines and keep win/loss records for the college hoops spreadsheet which will be posted next year.
I would like to thank Data for all his time and effort.
Based on early lines we have nothing yet.Comment -
Tx, formulawiz
I'll wait for college hoops spreadsheet.... remember my email?
Tx DataComment -
Dallas
Clevland DDComment
