You need to be logged in to your Sky Poker account above to post discussions and comments.

You might need to refresh your page afterwards.

Sharkscope for Cash?

2»

Comments

  • Patching99Patching99 Member Posts: 446
    edited September 2010
    In Response to Re: Sharkscope for Cash?:
    In Response to Re: Sharkscope for Cash? : I understand what you mean, though it's quite hard to even get the stuff to into a workable format in excel or whatever that quickly.  I have the ability to chance a sky hh into a eg pokerstars hh which can then be put through a hand history converter or into a db, though that wasn't easy and it wasn't me who managed it!!! Getting those into a db I haven't even tried to do yet as it will require alot of work!
    Posted by beaneh
    Just had a go and you can do it easily.

    I went to advanced history search in the my account page, searched for poker, dates of 1st August-31st August and selected cash games, copied the info and pasted directly into spreadsheet as HTML format.  One column is money out and one is money in, total these two up and bingo I lost £30 at NL4 in August!!!  The only thing I have proved though is I suck at poker!!
  • beanehbeaneh Member Posts: 4,079
    edited September 2010
    In Response to Re: Sharkscope for Cash?:
    In Response to Re: Sharkscope for Cash? : Just had a go and you can do it easily. I went to advanced history search in the my account page, searched for poker, dates of 1st August-31st August and selected cash games, copied the info and pasted directly into spreadsheet as HTML format.  One column is money out and one is money in, total these two up and bingo I lost £30 at NL4 in August!!!  The only thing I have proved though is I suck at poker!!
    Posted by Patching99
    yeah I realise what you're saying but that isn't detailed enough. 
  • Patching99Patching99 Member Posts: 446
    edited September 2010

    Don could do that though to see if he is back in profit yet.

  • freechips1freechips1 Member Posts: 861
    edited September 2010
    Don if you want to see if your in profit click withdraw, this will show your net deposits if it is a + then that shows how much you have put on. if it is a - then your in profit.
    How much was this fee to get all the stats?
  • ybyb Member Posts: 1,471
    edited September 2010
    In Response to Re: Sharkscope for Cash?:
    Don if you want to see if your in profit click withdraw, this will show your net deposits if it is a + then that shows how much you have put on. if it is a - then your in profit. How much was this fee to get all the stats?
    Posted by freechips1
    He was saying something about it depends on which stats you request. But tbh after he said I had to pay I got annoyed and switched off.
  • The_Don90The_Don90 Member Posts: 9,815
    edited September 2010

    freechips i know of that the problem is i want to know exactly only what ive earnt on cash, i know im in profit with my withdrawls and waht i have in my account is all 100% profit. I actually think im running cash at a loss still, thats going on withdrawls, account value, tournament and S*G profit from sharkscope.

  • beanehbeaneh Member Posts: 4,079
    edited September 2010
    In Response to Re: Sharkscope for Cash?:
    freechips i know of that the problem is i want to know exactly only what ive earnt on cash, i know im in profit with my withdrawls and waht i have in my account is all 100% profit. I actually think im running cash at a loss still, thats going on withdrawls, account value, tournament and S*G profit from sharkscope.
    Posted by The_Don90

    Go to 'My Account' click Advanced Account History Search.  

    Select 'Poker' then the date range you want to look for @step 2.

    Then select 'cash' from the drop down menu @step 3.

    This gives a possibly long list of cash game session information.

    Click and drag to highlight from the top left of date to the bottom right of the information, copy and paste this information into a spreadsheet and it should auto enter it within proper columns. 

    Go to the bottom of the pasted information in the spreadsheet and see what line number it goes down to, the number will be on the left of the excel screen [we'll call this number 'x']

    Click inside a cell below the pasted information, you want to enter 

    =(sum(F2:Fx))-(sum(G2:Gx))


    That adds up the amount taken to the table, and subtracts the amounts taken from the table and gives you your +/- figure.

    This is all obviously assuming you have a spreadsheet application ofc.



  • The_Don90The_Don90 Member Posts: 9,815
    edited September 2010
    In Response to Re: Sharkscope for Cash?:
    In Response to Re: Sharkscope for Cash? : Go to 'My Account' click Advanced Account History Search.   Select 'Poker' then the date range you want to look for @step 2. Then select 'cash' from the drop down menu @step 3. This gives a possibly long list of cash game session information. Click and drag to highlight from the top left of date to the bottom right of the information, copy and paste this information into a spreadsheet and it should auto enter it within proper columns.  Go to the bottom of the pasted information in the spreadsheet and see what line number it goes down to, the number will be on the left of the excel screen [we'll call this number 'x'] Click inside a cell below the pasted information, you want to enter  =(sum(F2:Fx))-(sum(G2:Gx)) That adds up the amount taken to the table, and subtracts the amounts taken from the table and gives you your +/- figure. This is all obviously assuming you have a spreadsheet application ofc.
    Posted by beaneh
    DOHHHHHHHHHHHHHHHH


    i dont, i managed to work out with what i had in the account, my withdrawls - profits of MTT and S&G and them remembered id played ojn Vegas and i do my bets through skybet(none of which i won lol)
  • ybyb Member Posts: 1,471
    edited September 2010
    If you dont have excel just do what beaneh said then add up both sets of figures using a calculator, then take the expenditure away from the income to get your total winnings/losses on cash.

    I did this recently for the last year because I was too thick to think of using excel lol, it takes ages!!!!
  • beanehbeaneh Member Posts: 4,079
    edited September 2010
    In Response to Re: Sharkscope for Cash?:
    If you dont have excel just do what beaneh said then add up both sets of figures using a calculator, then take the expenditure away from the income to get your total winnings/losses on cash. I did this recently for the last year because I was too thick to think of using excel lol, it takes ages!!!!
    Posted by yb

    It takes less than 30 seconds no matter how many sessions you have played, excel is your friend :-)
  • beanehbeaneh Member Posts: 4,079
    edited September 2010
    In Response to Re: Sharkscope for Cash?:
    In Response to Re: Sharkscope for Cash? : DOHHHHHHHHHHHHHHHH i dont, i managed to work out with what i had in the account, my withdrawls - profits of MTT and S&G and them remembered id played ojn Vegas and i do my bets through skybet(none of which i won lol)
    Posted by The_Don90


    You can go through all transactions made on your sky account so you should be able to total up your other bet stuff, similarly you should be able to get a spreadsheet application for free quite easily.
  • The_Don90The_Don90 Member Posts: 9,815
    edited September 2010
    im going to have a look. I used to have a system on my old pc id got for nothing, ill see if i can find out what it was called.
  • beanehbeaneh Member Posts: 4,079
    edited September 2010
    omg I wasn't thinking.


    google docs is your friend i'm sure.
  • beanehbeaneh Member Posts: 4,079
    edited September 2010
    docs.google.com

    sign in with a gmail address, sign up if you don't have one. 

    'create new' in the top left, select spreadsheet from the list, copy paste into that and follow above instructions. ez game.
Sign In or Register to comment.