Where do you find these stats/graphs??

Discussion in 'Data Sets and Feeds' started by Hiperfly, May 28, 2014.

  1. Hiperfly

    Hiperfly

    I mean, these kind of:

    [​IMG]

    Random data and interesting statistics about SP500, NQ, etc. I just know zerohedge fund (each day closer to an end of the world :D ) and seekingalpha.

    Any more suggestions?

    Ty!
     
  2. 2rosy

    2rosy

    what stuff are you looking for? you can get data from quandl and play

    Code:
    import pandas as pd
    import Quandl
    
    df= Quandl.get('YAHOO/INDEX_GSPC')
    df['pct'] = df['Adjusted Close'].pct_change()
    df['dt'] = df.index
    df['cumdiff']= df['dt'].where(df['pct']< -.02)
    df.cumdiff   = df.cumdiff.ffill()
    df['tdelta'] = df.dt - df.cumdiff
    df['tdelta'] = df.tdelta.astype('timedelta64[D]')
    df.tail(750)['tdelta'].plot()
    
    
    
     
  3. Hiperfly

    Hiperfly

    wut bro

    Sorry, I'm not into programming yet :D

    Other example (again from zerohedge), these kind of things are what I'm talking about:

    [​IMG]

    Tuesdays' results of the SP500

    Do you know more pages with interesting but uncommon data about markets?
     
  4. Arti

    Arti

    Last picture is misleading, it looks only on 2013, where we have a strong up trend and it obvious that one of the five days will give more up's than down's. On the long run it's not true.
     
  5. [​IMG]

    Fun to go back to these exercises. But, the newer excel is pretty dreadful to navigate and chart, IMO.
    If you're not that familiar with programming, a spreadsheet is a great way to start doing these studies.
     
  6. Sergio77

    Sergio77

  7. Maverick74

    Maverick74

    This is by far the best site I know of and one of my favs:

    http://bespokeinvest.typepad.com/
     
  8. 2rosy

    2rosy

  9. Hiperfly

    Hiperfly

    Thank you guys, you are the best! I'll try a couple of things in Excel too.

    luv u :p
     
    #10     May 29, 2014