Question

write a Python code:

Resample the data to get prices for the end of the business month. Select the Adjusted Close for each stock.

Date	Open	High	Low	Close	Volume	ExDividend	SplitRatio	AdjOpen	AdjHigh	AdjLow	AdjClose	AdjVolume
2017-06-30	980.12	983.47	967.61	968	3309138	0	1	980.12	983.47	967.61	968	3309138
2017-06-29	979	987.56	965.25	975.93	4246765	0	1	979	987.56	965.25	975.93	4246765
2017-06-28	978.55	990.68	969.21	990.33	3708638	0	1	978.55	990.68	969.21	990.33	3708638
2017-06-27	990.69	998.8	976	976.78	3735360	0	1	990.69	998.8	976	976.78	3735360
2017-06-26	1008.5	1009.8	992	993.98	3347195	0	1	1008.5	1009.8	992	993.98	3347195
2017-06-23	1002.54	1004.62	998.02	1003.74	2645973	0	1	1002.54	1004.62	998.02	1003.74	2645973
2017-06-22	1002.23	1006.96	997.2	1001.3	2221035	0	1	1002.23	1006.96	997.2	1001.3	2221035

Answer 1

CODE:

import xlrd

#array to store the value of Adjclose values
arr = []

#location stores the pathname of the .xlsx file
#example:
#location = ("E:/extra/python/Session3.xlsx")

location = ("enter path name")

#Opens the file
wb = xlrd.open_workbook(location)
sheet = wb.sheet_by_index(0)
  
#sheet.nrows gives the number of rows in the file
for i in range(1,sheet.nrows):
#to retrieve all values from 11th(index -10) coloumn(Adjvalue) and store in arr
arr.append(sheet.cell_value(i,10))
  
print(arr)

//Screenshot of Code:

//refer this to know the proper indentation

//Sample I/O:

//Hope this is what you asked.

//Comment if you got any doubt.

//Give thumbs up.

/Thank you!