Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. Open High Low Close
  2. 2016-06-01 69.60 70.20 69.44 69.76
  3. 2016-06-02 70.00 70.15 69.45 69.54
  4. 2016-06-03 69.51 70.48 68.62 68.91
  5. 2016-06-04 69.51 70.48 68.62 68.91
  6. 2016-06-05 69.51 70.48 68.62 68.91
  7. 2016-06-06 70.49 71.44 69.84 70.11
  8. 2016-06-07 70.11 70.11 68.00 68.35
  9.  
  10. import pandas as pd
  11. import numpy as np
  12. import matplotlib.pyplot as plt
  13. import matplotlib.ticker as mticker
  14. from matplotlib.finance import candlestick2_ochl
  15. import matplotlib.dates as mdates
  16. import datetime as dt
  17.  
  18. start_date='2016-06-01'
  19. end_date='2017-02-13'
  20. symbols=['EFERT']
  21.  
  22. def data(symbols):
  23. dates=pd.date_range(start_date,end_date)
  24. df=pd.DataFrame(index=dates)
  25. for symbol in symbols:
  26. df_temp=pd.read_csv('/home/furqan/Desktop/Data/{}.csv'.format(str(symbols[0])),
  27. usecols=['Date','Open','High','Low','Close'],
  28. parse_dates=True,index_col='Date',na_values=['nan'])
  29. #df_temp = df_temp.rename(columns={'Close': symbol})
  30. #df.index=df['Date']
  31. df=df.join(df_temp)
  32. df=df.fillna(method='ffill')
  33. df=df.fillna(method='bfill')
  34. return df
  35. df=data(symbols)
  36. #df['index']=mdates.date2num(df['index'].astype(dt.date))
  37. print(df)
  38.  
  39. ax1=plt.plot()
  40. candlestick2_ochl(ax1,df['Open'],df['Close'],df['High'],df['Low'],alpha=0.75)
  41. plt.show()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement