TOOLS FORUM

Comments

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    New and Improved RG Bankroll Tracker Tool Live

    Thanks to some really impressive work from your fellow Grinder, Cruzin2Victory, the RG Bankroll Tracker is much improved from the original product we launched a few months back. Here are some of the changes:

    Check Out the New Bankroll Tracker Here

    1) 2014 Tracking Added
    2) DraftDay and StarStreet Results Tracking Added (in addition to FanDuel)
    3) More concise data, including graphs for profits over time
    4) Suggested Bankroll Play Tool to help you better understand how to distribute your bankroll based on other winning strategies

    Feel free to post any feedback or questions here, and Cruzin or I will get to them as quickly as possible. You can also find the bankroll tracker in the FanDuel daily research section, and we will have it added to the DD and SS Daily Research Consoles soon.

    One last note, a popular question will likely be when we can incorporate the other sites into this tool. The answer to that is we can’t accumulate enough data to produce the same information the tracker hands out for FD, DD and SS until a site has a downloadable CSV with buy in, entrants, prizes, finish, score, date and specific sport. We do not have that information on the other sites even if you copy and paste your results feed, so for that reason we can’t include those yet.

    Check Out the New Bankroll Tracker Here

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    A few quick things to add:

    1) My name is CruzinToVictory! :)
    2) In order to compile the data from all 3 sites, I needed to use a few macros, so this will only work if your version of Excel supports macros.

    Other than that, enjoy!

  • StopAndDrop

    Nice work Cruz glad I found this site.

  • bringemvaught

    • 658

      RG Overall Ranking

    • Ranked #60

      RG Tiered Ranking

    Thanks Cruz

  • bringemvaught

    • 658

      RG Overall Ranking

    • Ranked #60

      RG Tiered Ranking

    Not working for me for some reason. I copy and pasted my gamelog from the previous bankroll tracker into the FD section. All of the other tabs still show zero everywhere.

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    Did you click the Update button on the first tab after pasting your results?

    Also, that GIF is going to give me a seizure. Holy cow.

  • bringemvaught

    • 658

      RG Overall Ranking

    • Ranked #60

      RG Tiered Ranking

    It helps to read the instructions I guess. Thanks.

  • stlcardinals84

    Leading RG Analyst

    • 2018 DraftKings FBWC Finalist

    • 2018 DraftKings FBBWC Finalist

    I’m guessing there is something I am doing wrong here, but just in case:

    I know the exact amount of my total deposits, total withdrawals, and current balance at FanDuel. Therefore, I know my exact gain or loss there since the beginning of 2013 (I didn’t play there before 2013).

    I exported all my results and updated — and it’s off about $9,500 to the red.

    Does this have something to do with qualifiers, perhaps? Or live finals?

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    @stlcardinals84 said…

    I’m guessing there is something I am doing wrong here, but just in case:

    I know the exact amount of my total deposits, total withdrawals, and current balance at FanDuel. Therefore, I know my exact gain or loss there since the beginning of 2013 (I didn’t play there before 2013).

    I exported all my results and updated — and it’s off about $9,500 to the red.

    Does this have something to do with qualifiers, perhaps? Or live finals?

    It’s very possible, yes. There are a number of things that could cause the number to be off:

    1) Events like a SuperQualifier. For example, I won an entry in to the FFFC SuperQ with a $25 satellite. When I looked at my FanDuel export, it shows that I entered a $25 league, won nothing, then entered a $200 league (the SuperQ) and won nothing (I didn’t cash). So while I technically won a $200 ticket with a $25 game and only netted a loss of $25, the export shows that I lost $225. I’m sure someone with your volume could have a lot more examples of that type of thing.

    2) Deposit bonuses aren’t included anywhere, because they’re not in the log. Obviously this would increase the number, but just thought I should point that out.

    3) I only have one example of this, but it seems like custom leagues that are canceled are still recorded as losses. A few weeks ago I entered Stevie’s mini FFFC contest. It never filled and was canceled, but the
    export still showed a buy in with a net win of $0.

    Unfortunately I can’t fix the FD export, so I had to go through and make the adjustments on my own data manually :(

  • stlcardinals84

    Leading RG Analyst

    • 2018 DraftKings FBWC Finalist

    • 2018 DraftKings FBBWC Finalist

    #1 would definitely be the culprit for me in all likelihood. Thanks Cruz!

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    No problem! Now that I think of it, I should submit that as a support ticket to FD

  • nexus

    • 2011 FanDuel WFBC Finalist

    Can I use Open Office for this or does it have to be Microsoft Excel?

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    @nexus said…

    Can I use Open Office for this or does it have to be Microsoft Excel?

    I actually have no idea, never used Open Office before. I’ll download it and give it a try later tonight and get back to you.

  • nexus

    • 2011 FanDuel WFBC Finalist

    Thank you. It just keeps loading and loading and never opens, so I don’t think you can.

  • nexus

    • 2011 FanDuel WFBC Finalist

    Is there something else I can download to do this bankroll tracker? Microsoft Office is just too expensive when all I want is this bankroll tracker.

  • windchimesrrude

    2013 PFBC Qualifer

    • 2013 StarStreet MLB Playboy Mansion Finalist

    I think microsoft offers a free trial of Excel. And since it’s the most awesome program ever made and you play DFS, you should probably own it.

  • Mortalys

    Nexus and all:

    The answer to OpenOffice is “No you can not”. The previous spreadsheet (and without looking, i’m certain this one as well) has AVERAGEIFS and SUMIFS functions. OpenOffice does not support those. LibreOffice does, however the formulas in this spreadsheet require tweaking still to enable use in LibreOffice. If you do not have excel and would like spreadsheets that work in LibreOffice, please check out my post that has links to downloads on my Box.com account to DraftDay and FanDuel spreadsheets. My apologies, but I don’t play on StarStreet so no spreadsheet for there yet.

    Cruzin and Ethan: we should probably collaborate some on this stuff in the future. I didn’t realize Cruzin was working on updating the spreadsheet until after i’d spent weeks making my enhancements and fixes to allow more global usage across more spreadsheets programs than just Excel. At that point Ethan responded to my post and mentioned your efforts Cruzin. I will take a look at your work sometime this week and provide my feedback.

  • Mortalys

    @windchimesrrude said…

    I think microsoft offers a free trial of Excel. And since it’s the most awesome program ever made and you play DFS, you should probably own it.

    To be honest, LibreOffice supports 99% of Excel and is free. No thanks, i’ll use LibreOffice instead. OpenOffice is nearly as good, though currently a bit slower than LibreOffice on adding in new functions to maintain compatibility across versions (Which is why it breaks when attempting to use this spreadsheet).

  • jjarrad

    after importing my results for DD and clicking update all, i look in the summary section and there is all 0’s for my draftday section. Any idea what the cause could be?

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    @jjarrad said…

    after importing my results for DD and clicking update all, i look in the summary section and there is all 0’s for my draftday section. Any idea what the cause could be?

    Just to make sure, did you paste the results from the DD sheet into the red DD tab?

    After clicking the Update button, go to the GAMELOG tab on the far right. You should see the game information there, and the M column should have “DD” in every row that has info from DraftDay.

    Do you have that?

  • jjarrad

    @CruzinToVictory said…

    Just to make sure, did you paste the results from the DD sheet into the red DD tab?

    After clicking the Update button, go to the GAMELOG tab on the far right. You should see the game information there, and the M column should have “DD” in every row that has info from DraftDay.

    Do you have that?

    yep. Pasted the results in the red DD tab in cell A1. Verified I have DD in column M on the Gamelog tab.

    Also, in the DD tab, it does show my breakdowns so I’m a little confused.

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    @jjarrad said…

    yep. Pasted the results in the red DD tab in cell A1. Verified I have DD in column M on the Gamelog tab.

    Also, in the DD tab, it does show my breakdowns so I’m a little confused.

    I’ll send you a PM with my email address. Send me the file (you can delete all but a few lines if you don’t want to show me your stats) and I’ll take a look and see what’s happening.

  • sonicattack

    For FD, would it be possible to make the sheet differentiate between 50-man 50/50s vs all games 20+ up being considered GPPs?

  • CruzinToVictory

    RG Product Coordinator

    • Blogger of the Month

    @sonicattack said…

    For FD, would it be possible to make the sheet differentiate between 50-man 50/50s vs all games 20+ up being considered GPPs?

    I sure can. Not sure why we didn’t do that in the first place. I’ll get that fixed and ask them to upload it as soon as I can.

  • sonicattack

    suhweeeet

  • pbarrese13

    2012 DSBC Finalist

    • 2012 DraftStreet DSBC Finalist

    Awesome job on this guys. This makes it so easy to track. Thanks so much.

  • X Unread Thread
  • X Thread with New Replies*
  • *Jumps to your first unread reply

Subforum Index

RotoGrinders.com is the home of the daily fantasy sports community. Our content, rankings, member blogs, promotions and forum discussion all cater to the players that like to create a new fantasy team every day of the week.

If you or someone you know has a gambling problem, crisis counseling and referral services can be accessed by calling 1-800-GAMBLER (1-800-426-2537) (IL). Gambling problem? Call 1-800-GAMBLER (NJ/WV/PA/MI), 1-800-9-WITH-IT (IN), 1-800-522-4700 (CO), 1-800-BETS OFF (IA), 1-888-532-3500 (VA) or call/text TN REDLINE 1-800-889-9789 (TN).