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

  • Dencope

    Thanks in advance as this looks like an awesome tool…however I’m having a problem. I have excel 2010 and when I download the files to my desktop it will allow me to copy but not pate in A2. I can drag and drop but in opens a new page which no longer has the tabs and the new excel page looks strange. I’m thinking maybe when I export it to my desktop my PC for some reason changes the file type? Does this make any sense and if so do you know how to change it so I can paste into excel? Thanks for any info.

  • Dencope

    continued…when I select to export csv file to desktop I can save it as “free opener” or “all files”? Not sure what free opener is or how I got it. What should I be saving the file type as? Thanks again!

  • Ganduffey95

    I need help doing this i’m not doing something right

  • Meatacus

    Here is what I do for FanDuel results. I click on download as CSV from the history page whatever page I need. Typically since I update my tracker every few days, I only need to download Page 1 and/or Page 2.

    Once I open the file with Excel, I adjust the widths of a few columns (Entry ID, Date, Title) by double clicking on the right border of the column with the letters assigned to them (A, C, D) just so none of the information is cut off.

    I then Left Click on the mouse starting at Row 2 and select all the rows I want to highlight to copy and paste to the Tracker. So if I’m just doing last nights results, I would just highlight all the rows that correspond with 06/07/2015. Once highlighted, Right Click and copy or cut whatever you prefer.

    Then go back to your Tracker, go to the FD tab and I like to paste new results to the bottom of all the other results you already have in your tracker. Go to bottom of the entries, right click (A whatever row) and pick paste.

    After pasting in new results, I Left Click the square icon next to Date and sort the column by Newest to Oldest.

    Then I go to Bankroll tab and click on ‘update all’ and that should do everything for you (takes longer and longer as your file gets larger).

    Don’t delete any tabs you don’t use as they’re used in the macro and will give you error message in the future. I deleted the Star Street or whatever it was tab and it took me awhile to correct the macro to get rid of the bugs I was encountering.

    Hope that helps

  • wwhodatxliv

    • 988

      RG Overall Ranking

    • x2

      2015 FanDuel CFB Playboy Mansion Finalist

    Hey what do I do if it keeps freezing every time i copy and past DK results?

  • AQUAFTM45

    @Meatacus said...

    Here is what I do for FanDuel results. I click on download as CSV from the history page whatever page I need. Typically since I update my tracker every few days, I only need to download Page 1 and/or Page 2.

    Once I open the file with Excel, I adjust the widths of a few columns (Entry ID, Date, Title) by double clicking on the right border of the column with the letters assigned to them (A, C, D) just so none of the information is cut off.

    I then Left Click on the mouse starting at Row 2 and select all the rows I want to highlight to copy and paste to the Tracker. So if I’m just doing last nights results, I would just highlight all the rows that correspond with 06/07/2015. Once highlighted, Right Click and copy or cut whatever you prefer.

    Then go back to your Tracker, go to the FD tab and I like to paste new results to the bottom of all the other results you already have in your tracker. Go to bottom of the entries, right click (A whatever row) and pick paste.

    After pasting in new results, I Left Click the square icon next to Date and sort the column by Newest to Oldest.

    Then I go to Bankroll tab and click on ‘update all’ and that should do everything for you (takes longer and longer as your file gets larger).

    Don’t delete any tabs you don’t use as they’re used in the macro and will give you error message in the future. I deleted the Star Street or whatever it was tab and it took me awhile to correct the macro to get rid of the bugs I was encountering.

    Hope that helps

    If you have to all of this (which I have done), you are working to hard and Roto needs to update their Tracker again. There are good free programs out there that all you have to do is drag and drop all of your different cvs. files and wala in 2-3 minutes (even with big files) you have your tracker ready.

    No disrespect Roto, but get on it.

  • Wilder

    Deleted Comment.

  • marcj76

    I am super appreciative of the effort that went into building this spreadsheet (and all of the incredible content on this site) but #1 basically makes this spreadsheet unusable. It is definitely treating Satellite wins as net losses and then, if you don’t win in the bigger tournament you Q’ed for you get a double whammy (to the Red) on your ROI. I understand qualifiers are tricky to calculate, but would it be possible to just entirely filter them out from the results?

  • MooknGradyzfranchize

    Hi there,
    trying to get familiar with Bank Tracker. I loaded my first month of matches in bank tracker and worked great. Im trying to loa my last three weeks of matches and add them on to my original spreadsheet. Is this possible or do i have to download all my match ups again? the dates start latest up top, can I add just on the next cell? Is it suppose to take 10-15 minutes to download from DK onto excel?
    Sorry for the novice questions, just learning excel.
    Thanks
    Mike

  • charger4life

    does it work with numbers for mac

  • videopoker1

    Hi,
    I was wondering if there will be a Bankroll tracker for 2016 in excel? I love bankroll tracker v7.1.
    I am excel illiterate, and I could use the 2016 excel version.
    Thanks
    Later

  • woody18

    Have been unable to get Bankroll Tracker to work. Is it possible that this version is incompatible with Excel for Mac version 15.3.1?

  • hurtner2005

    i am having issue with the draftkings bankroll. it is throwing out numbers that dont match what i did is it something i am doing with the copying or something else

  • kkrazykk1999

    Hi there-

    I just started my BR Tracker for NFL 2015. Fanduel tab seems to be calculating correctly but DK tab isn’t pulling winnings in. It shows zero for winnings. Is this a known problem?

  • eppy99

    I have the same problem with DK. I’m running a PC with Windows 10 using Excel 2010. It shows $0 for winnings and thus makes no recommendation on the summary page of what kind and how many of each game to play.

    The funny thing is last year I was able to get everything to work, not sure what happening now.

  • fantasy144123

    I’m guessing their is formatting issues with MAC and a bug with DK.

  • BillsMafia720

    Does anyone know how to set up the tracker in Libreoffice? I am running it on a Mac and everytime I try to run my data, it gives me a Syntax/Sort error

  • FourPointPlay

    how would I go about modifying this for StarsDraft?

  • Twilliams83

    @wwhodatxliv said...

    Hey what do I do if it keeps freezing every time i copy and past DK results?

    same issue here

  • serverm07

    Hey, great job thanks. I was wondering how to go about updating it for the coming year?

  • 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).