## I used Python to crawl the data of 800 funds and found that

Rocky0429 2021-04-08 13:09:34
used python crawl data funds

Now many students have tried to buy funds , After all, it's called The easiest way to invest for lazy people

However, as long as automatic investment plan Once and for all ？ Of course not. , Which tough guy can resist the heartache that the fixed investment income drops bit by bit ？

see , Recently, the stock market has gone down sharply , So many funders started “ The winner is Mr. Cai , If you lose, it's CAI ” . Many 12 month ,1 Students who just started to cast their ballots in June , The withdrawal of holding fund may exceed the income of years ago . therefore , We need to target revenue at the right stop .

My friends in the group who invest in fixed funds summed up their common There are four ways Profit strategy , And use Python visualization To realize the fixed investment and stop profit of the fund , I tried , The effect is very good .

The commonly used valuation indexes are p / E ratio and P / B ratio . This paper takes p / E ratio as an example , It refers to the ratio of the total market value of the index component to the total profit . Generally speaking, it is calculated according to the total profit of that year , How many years does it take for the investment to recover its cost . We can compare the historical level of the index , To measure whether an index is overvalued or undervalued .

Here's the Fund E Fonda Shanghai and Shenzhen 300ETF join For example , The fund is corresponding to Shanghai and Shenzhen 300 Index . We use crawlers or directly copy the web page to obtain Shanghai and Shenzhen 300 The history of the index PE data .

After data acquisition , We take advantage of matplotlib drawing , You can get Shanghai and Shenzhen 300 The historical P / E trend of the index .

``plt.figure(dpi=100)plt.plot(df["pe"],c="r",ls="--")a = list(range(1,516,256))plt.xticks(a,[df["ts"][i] for i in a])plt.axhline(y=float(line_value_30),c="g",ls="--",lw=2)plt.axhline(y=float(line_value_median),c="y",ls="--",lw=2)plt.axhline(y=float(line_value_70),c="b",ls="--",lw=2)plt.show()``

（ Green in the picture 、 yellow 、 The three blue lines represent 30 Quantile value 、 The median and 70 Quantile value .

When the index exceeds 70 Quantile value , Consider continuing to hold Or reduce the position appropriately . When the index is below 30 Quantile value , Consider continuing to buy or keep a fixed investment .

However, according to the valuation strategy to sell also has disadvantages ： One is that the holding time is too long , Second, is it suitable for all industries to sell by valuation method , It's not suitable for those whose performance growth is slowing down or negative .）

The above is what we use Python visualization Intuitively show the valuation of the current index fund . It's just using Python Let me show you the charm of data analysis , We can actually do it in the future Deep data mining and fund stock quantification ！ and , In fact, data analysis is not only about getting data , Store the data , Also need to be able to preprocess the data , extract , Then analysis , Statistics , Report and other operations .

If you use Python Data analysis interested , Want to get a good paying job , But there's still a little bit of confusion , There's a lot of ambiguity , such as What is the learning path of data analysis ？ How to make a beautiful visual view ？ How to quantify stocks and so on ？

I have specially summarized a mind map for you this time , Click to enlarge to see more clearly .

（ Click to see the big HD picture ）

Based on this , I'm here E-books that I used in my previous study （ Skills 、 Statistics 、 Business class ）, There are also related videos Free to share For everyone , You don't have to pick videos , I hope it will be helpful to your study .

PS： I have summarized a lot of information , Is almost 4G, We must give you Baidu cloud disk space to Oh ！

Get free materials and live classes from big factories

Follow these steps , Get the books that I've picked up 、 video .

1、 Scan the QR code and sign up for the course for free （ Time limit 300 Places ）

2、 After successful registration, add a little assistant to get the information free of charge

( Scan the code for details of the course ）

If you encounter some environment configuration , There are also some errors and exceptions bug, The information is not enough , Then we need to find the teacher , Give us a special explanation .

Or you want to learn data analysis knowledge quickly , Let's look for a live class first , Understand the most practical learning ideas at present , Set your own direction .

Netease live course content details

I Special recommendation Netease cloud classroom Of 《3 Day data analysis training camp 》 , Update dry goods knowledge regularly .
also Netease specially invited data architecture lecturer —— Certificate Troll ”Mars teacher , Through live teaching and actual combat at the same time , Open interactive participation And learning , Make your journey of data analysis one step faster ！

4 month 13 Japan   20:00& Introduction to data visualization ：
60 minute , use Tableau Quickly achieve cool Visualization
Process analysis ：5 A key step , Master the core method
Process handling ：2 A key tool , Improve work efficiency
Actual project ： Second hand car website data crawling + visualization

4 month 14 Japan 20:00& Advanced data visualization

4 A case , use Python Realization 【 Interactive visual reports 】

Entry level charts ： use Python Fast implementation

Advanced interaction diagram ： The trend of stock price

Dynamic trend chart ： Analysis of e-commerce live broadcast

Map renderings ： Sales data summary

4 month 15 Japan  20:00& Introduction and advancement of quantitative trading :
utilize Python, Choose quality stocks quickly

Scene tools ： utilize pandas Tool decomposition KDJ Index composition

Process handling :  Transaction data crawling , Business scenario analysis modeling and Visualization

The results of the analysis ： use KDJ Index model compared with special currency market point of sale search & Trade backtracking

Actual project ： Master the principle of finding virtual currency trading according to data index and analysis tools

They regularly share some dry goods every week for your reference , It's very helpful to study .

（ Deep learning DeepLearning.ai Laboratory Certification ）

（ Microsoft / Oracle /Cloudera Data analysis certificate issued by the company ）

4 Learn how to visualize data , Office efficiency tripled

（ More highlights When you unlock ）

## Get free materials and live classes from big factories

Follow these steps , Get the books that I've picked up 、 video .

1、 Scan the QR code and sign up for the course for free （ Time limit 300 Places ）

2、 After successful registration, add a little assistant to get the information free of charge

( Scan the code for details of the course ）

If you encounter some environment configuration , There are also some errors and exceptions bug, The information is not enough , Then we need to find the teacher , Give us a special explanation .

Or you want to learn the knowledge of data visualization quickly , Let's look for a live class first , Understand the most practical learning ideas at present , Set your own direction .

（ Remember to add a little assistant to collect information , Maybe you'll use it one day ）

This article is from WeChat official account. - Python Space （Devtogether）.
If there is any infringement , Please contact the support@oschina.cn Delete .
Participation of this paper “OSC Source creation plan ”, You are welcome to join us , share .

https://pythonmana.com/2021/04/20210408120353937X.html