Where do you find these stats/graphs??

H

Hiperfly

I mean, these kind of:

2declines.jpg


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!
 
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()
 
2rosy said:
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()
More...

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:

20140527_EOD65.png


Tuesdays' results of the SP500

Do you know more pages with interesting but uncommon data about markets?
 
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.
 
21mul8k.jpg


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.
 
You must log in or register to reply here.
Back
Top