Panda price research site

Discussion in 'Modern Chinese Coins & Medallions' started by fishball, Apr 23, 2012.

  1. Chillidog

    Chillidog New Member Silver Stacker

    Joined:
    Feb 19, 2011
    Messages:
    1,236
    Likes Received:
    1
    Trophy Points:
    0
    Location:
    In the dog house SEQ
    Wow I am in need of this great service.
    Many thanks fishball.
     
  2. tel

    tel New Member

    Joined:
    Feb 5, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    South Europe
    Sign me up for an account please.
     
  3. comeaux

    comeaux Member Silver Stacker

    Joined:
    Sep 29, 2011
    Messages:
    907
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    South Louisiana
    Most excellent job fishball VERY impressive bud !!!

    What a herculean task to embark on and accomplish this is going to be extremely useful !!!

    Hells yea I want an account that's like asking a cockroach if he wants to live at McDonalds ! :p
     
  4. mmm....shiney!

    mmm....shiney! Administrator Staff Member Silver Stacker

    Joined:
    Nov 15, 2010
    Messages:
    18,681
    Likes Received:
    4,442
    Trophy Points:
    113
    Fishguts, you are member of the century, AGAIN. :D

    Beam sign me up Scotty Fishy ;)
     
  5. silverstar1

    silverstar1 New Member

    Joined:
    Oct 6, 2011
    Messages:
    966
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    Thanks Fishball ! That is very cool! and totally easy to use ,I just looked at a few, happy to see some of the lowest prices were ones I bought..
     
  6. fishball

    fishball New Member Silver Stacker

    Joined:
    Apr 11, 2011
    Messages:
    6,509
    Likes Received:
    1
    Trophy Points:
    0
    Location:
    Shin Sekai Yori
    Possible to do and you can do it currently through two searches.

    You can first search for 'ncs' to be included to get a list of listings which have NCS in the title & then exclude 'ncs' to get the ones which don't have or didn't list NCS.

    Some sellers don't list that their coin is NCS'd in the title and that makes it difficult so this is the best that can be done for now.

    eg. Frosted 2000

    NCS (include):
    Average Price: $426.27
    Highest Price: $432.55
    Lowest Price: $419.99
    Total Sales in Dollars: $852.54
    Number of Sales: 2
    Standard Deviation: $8.881261171703
    Median Price: $426.27

    NCS (exclude):
    Average Price: $383.81
    Highest Price: $425
    Lowest Price: $305
    Total Sales in Dollars: $4221.89
    Number of Sales: 11
    Standard Deviation: $39.106984751623
    Median Price: $382.77

    In the future I think I will allow OMPs to be added manually. Currently there are no OMPs.

    % over spot is relatively easy to implement, I will do that when I have time :)

    % gain from start is something that is possible. I would however need to modify the codebase a fair bit to accomodate this as I'd need to uniquely classify every different coin as opposed to relying on you guys to search and then there are the varieties... Will add it to the list of things I may do in the future but for now you can search and pull all the data then compare it manually.

    Here's some graphs I did for the 2012 S10Y MS70 comparing the prices of the first 200 sales & current 200 sales.

    [​IMG]

    [​IMG]

    You can view these in the stats & graphs page. Not too much there at the moment though.

    As for comparing the suggested RRP/pricepedia price I won't be including this because the prices fluctuate a lot and there is no fixed RRP. Also, not everybody who uses my site subscribes to pricepedia so that won't be fair.

    Since there are multiple calls for OMP to be added I will (when I have time... high priority!) create a page that allows users to add OMP listings to the database. Unfortunately it has to be manual for now so if you have time it'll be helpful, if not then don't worry for now as the graded stuff is still fully automated :).

    Cheers for the feedback
     
  7. slappy70

    slappy70 Member

    Joined:
    Dec 11, 2011
    Messages:
    121
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Pennsylvania
    Could I please get an account. Thanks!!
     
  8. STC

    STC Well-Known Member Silver Stacker

    Joined:
    Mar 16, 2011
    Messages:
    1,172
    Likes Received:
    271
    Trophy Points:
    83
    Location:
    Perth
    Please sign me up FB, sounds like a great tool & thanks for all your hard work!
     
  9. musemellow

    musemellow Member

    Joined:
    Dec 4, 2011
    Messages:
    465
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Perth, WA
    I love it FB, I can see that I will use this more often than eBay "completed listing" search.
     
  10. mmm....shiney!

    mmm....shiney! Administrator Staff Member Silver Stacker

    Joined:
    Nov 15, 2010
    Messages:
    18,681
    Likes Received:
    4,442
    Trophy Points:
    113
    Thanks mate
     
  11. comeaux

    comeaux Member Silver Stacker

    Joined:
    Sep 29, 2011
    Messages:
    907
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    South Louisiana
    Site is f(k!n dope !!!!!!!!!!!!!!!!!! hells yea !
     
  12. fishball

    fishball New Member Silver Stacker

    Joined:
    Apr 11, 2011
    Messages:
    6,509
    Likes Received:
    1
    Trophy Points:
    0
    Location:
    Shin Sekai Yori
    If anybody runs into any technical issues let me know.

    I've only tested the site on IE6, IE8, FF10, Opera 9 and a few mobile browsers.

    The graphs break on IE6 (Y U NO SUPPORT PNG PROPERLY) but it's a shyt browser and I bet I'm the only one here who has to use it (due to work comp).

    Edit: Yes FF is Firefox :p
     
  13. mmm....shiney!

    mmm....shiney! Administrator Staff Member Silver Stacker

    Joined:
    Nov 15, 2010
    Messages:
    18,681
    Likes Received:
    4,442
    Trophy Points:
    113
    This ^^^^^ is a language of which I am unfamiliar. I assume he likes your sight fishguts. Works with Firefox too.

    Edit to add: hang one, firefox might be FF10 hey?
     
  14. Thor122

    Thor122 New Member

    Joined:
    Jul 15, 2011
    Messages:
    1,461
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Valhalla
    Add safari in ipad2. Perfect job
     
  15. fishball

    fishball New Member Silver Stacker

    Joined:
    Apr 11, 2011
    Messages:
    6,509
    Likes Received:
    1
    Trophy Points:
    0
    Location:
    Shin Sekai Yori
    Added OMP as per request. Although all the data has to be manually submitted :p

    I entered around 75 150+ coins myself and everyone should have a link to manually add (if they wish!) any coins in next to the control panel link.

    All you need is the eBay ID number, the bid # & tick the OMP check box and it'll pull the info itself.

    You could also add graded pandas here by not checking the OMP box, in case my script misses something.

    v0.2 now with some new features and bug fixes, more to come in the future :)

    edit: added RAW too for the coins not in OMP...
     
  16. Dave92029

    Dave92029 New Member

    Joined:
    Feb 4, 2012
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    San Diego, Calif.
    please sign me up!

    Thank you

    Dave
     
  17. Dave92029

    Dave92029 New Member

    Joined:
    Feb 4, 2012
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    San Diego, Calif.
    Wow! An awesome tool, and the data retrieval is very fast.

    Well done!

    Thank you
     
  18. jc888888888

    jc888888888 New Member Silver Stacker

    Joined:
    Dec 12, 2011
    Messages:
    1,399
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    usa
    Shiney ,not to sound rude or sexist, if that is a picture of you ,you are also f(k!n dope !!!!!!!!!!!!!!!!!!!!!!! :):):)
     
  19. Reggie Perrin

    Reggie Perrin New Member

    Joined:
    Mar 26, 2012
    Messages:
    276
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    UK
    Could you sign me up please fishball

    cheers
     
  20. Reggie Perrin

    Reggie Perrin New Member

    Joined:
    Mar 26, 2012
    Messages:
    276
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    UK
    Fishball, thanks and that's a brilliant piece of work and an extremely useful tool..
     

Share This Page