股票分析
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import tushare as ts
用tushare包获取某支股票的历史行情数据
查询茅台酒的股票编码并获取数据
df=ts.get_k_data("600519",start='1988-01-01')
df.to_csv("600519.csv")
df.head(5)
本接口即将停止更新,请尽快使用Pro版接口:https://waditu.com/document/2
|
date |
open |
close |
high |
low |
volume |
code |
0 |
2001-08-27 |
5.392 |
5.554 |
5.902 |
5.132 |
406318.00 |
600519 |
1 |
2001-08-28 |
5.467 |
5.759 |
5.781 |
5.407 |
129647.79 |
600519 |
2 |
2001-08-29 |
5.777 |
5.684 |
5.781 |
5.640 |
53252.75 |
600519 |
3 |
2001-08-30 |
5.668 |
5.796 |
5.860 |
5.624 |
48013.06 |
600519 |
4 |
2001-08-31 |
5.804 |
5.782 |
5.877 |
5.749 |
23231.48 |
600519 |
只显示感兴趣的四列(开、收盘价,最高、最低价)
df=pd.read_csv("600519.csv",index_col="date",parse_dates=["date"])[['open','close','high','low']]
df.head(5)
|
open |
close |
high |
low |
date |
|
|
|
|
2001-08-27 |
5.392 |
5.554 |
5.902 |
5.132 |
2001-08-28 |
5.467 |
5.759 |
5.781 |
5.407 |
2001-08-29 |
5.777 |
5.684 |
5.781 |
5.640 |
2001-08-30 |
5.668 |
5.796 |
5.860 |
5.624 |
2001-08-31 |
5.804 |
5.782 |
5.877 |
5.749 |
输出该股票所有收盘比开盘上涨大于等于3%及以上的日期
该股票所有收盘比开盘上涨大于等于3%的行
(df["close"]-df["open"])/df["open"]
df[(df["close"]-df["open"])/df["open"]>=0.03 ].head(5)
|
open |
close |
high |
low |
date |
|
|
|
|
2001-08-27 |
5.392 |
5.554 |
5.902 |
5.132 |
2001-08-28 |
5.467 |
5.759 |
5.781 |
5.407 |
2001-09-10 |
5.531 |
5.734 |
5.757 |
5.470 |
2001-12-21 |
5.421 |
5.604 |
5.620 |
5.421 |
2002-01-18 |
5.437 |
5.726 |
5.762 |
5.421 |
该股票所有收盘比开盘上涨大于等于3%的日期
df[(df["close"]-df[