Python Forum
SMA (simple moving avg) Not receiving Data (stock prices).
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SMA (simple moving avg) Not receiving Data (stock prices).
#3
Hi,
See the code below.


import yfinance as yf
 
ticker = "AAPL"
date1 = '2010-01-01'   # start and end date 
date2 = '2020-01-01'    
df=yf.download(ticker,date1, date2)

def SMA(data, period=10):
    return data['Close'].rolling(window=period).mean()
#
df['SMA10']=SMA(df)

df.head(11)
Out[895]: 
                Open      High       Low     Close  Adj Close     Volume  \
Date                                                                       
2010-01-04  7.622500  7.660714  7.585000  7.643214   6.535085  493729600   
2010-01-05  7.664286  7.699643  7.616071  7.656429   6.546385  601904800   
2010-01-06  7.656429  7.686786  7.526786  7.534643   6.442255  552160000   
2010-01-07  7.562500  7.571429  7.466071  7.520714   6.430344  477131200   
2010-01-08  7.510714  7.571429  7.466429  7.570714   6.473095  447610800   
2010-01-11  7.600000  7.607143  7.444643  7.503929   6.415992  462229600   
2010-01-12  7.471071  7.491786  7.372143  7.418571   6.343011  594459600   
2010-01-13  7.423929  7.533214  7.289286  7.523214   6.432483  605892000   
2010-01-14  7.503929  7.516429  7.465000  7.479643   6.395229  432894000   
2010-01-15  7.533214  7.557143  7.352500  7.354643   6.288351  594067600   
2010-01-19  7.440357  7.685357  7.401429  7.680000   6.566539  730007600   

               SMA10  
Date                  
2010-01-04       NaN  
2010-01-05       NaN  
2010-01-06       NaN  
2010-01-07       NaN  
2010-01-08       NaN  
2010-01-11       NaN  
2010-01-12       NaN  
2010-01-13       NaN  
2010-01-14       NaN  
2010-01-15  7.520571  
2010-01-19  7.524250  

np.mean(df.Close[0:10])
Out[900]: 7.520571374893189
Reply


Messages In This Thread
RE: SMA (simple moving avg) Not receiving Data (stock prices). - by paulyan - Jul-31-2022, 08:20 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Receiving this error in my "response" and causes script to return wrong status cubangt 18 2,376 Aug-13-2023, 12:16 AM
Last Post: cubangt
  Need help with creating dynamic columns with for loops for stock prices PaDat 2 1,003 Feb-22-2023, 04:34 AM
Last Post: PaDat
  Create simple live plot of stock data dram 2 3,024 Jan-27-2023, 04:34 AM
Last Post: CucumberNox
  Moving data from one Excel to another and finding maximum profit azizrasul 7 1,593 Oct-06-2022, 06:13 PM
Last Post: azizrasul
  Exporting Stock Fundamental Data to a CSV file with yahoo_fin DustinKlent 2 4,845 Aug-01-2022, 06:08 PM
Last Post: paulyan
  Yfinance - Intraday stock data with yf.download diogo_80 2 6,220 Apr-29-2022, 05:07 AM
Last Post: processingclouds
  Receiving snmp traps with more than one Community String ilknurg 0 2,329 Jan-19-2022, 09:02 AM
Last Post: ilknurg
  simple html page with update data korenron 3 2,797 Nov-15-2021, 09:31 AM
Last Post: jamesaarr
  Plotting sum of data files using simple code Laplace12 3 3,186 Jun-16-2021, 02:06 PM
Last Post: BashBedlam
  Suggestions for a simple data analysis program t4keheart 0 1,820 Mar-08-2021, 03:45 PM
Last Post: t4keheart

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020