{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Parameters","AAPL.US_dividends","MSFT.US_dividends"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Parameters","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[0]
["APIKEY","demo",null,null,null,null,null,true]
["Start Date","2015-02-02",null,null,null,null,null,false]
["End Date",{"$f":"TODAY()","v":"2024-09-30"}]
["Period","d"]
[null,"c:\\temp\\",null,null,null,null,null,null,null,"Failed for These Tickers"]
[]
[]
["Enter Tickers Below",null,"Enter a list of stock tickers and",null,null,null,null,null,null,null,null,"AAPL.US"]
["AAPL.US",null,"click the button to automatically",null,null,null,null,null,null,null,null,"MSFT.US"]
["MSFT.US",null,"retrieve historical stock quotes"]
[null,null,"from EOD Historical Data"]
[]
[null,null,"Data for each ticker is downloaded"]
[null,null,"into separate sheets, each titled"]
[null,null,"with the ticker symbol"]
[]
[null,null,"Collate Data stacks Close, Open, High, Low, Adjusted Close"]
[null,null,"and Volume into the same sheets (with the date) for all tickers."]
[]
[null,null,"The VBA for this spreadsheet is viewable and editable"]

{"sheet":"AAPL.US_dividends","index":1,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Dividends for AAPL.US"]
["Date","Dividends"]
["2015-02-05","0.1175"]
["2015-05-07","0.13"]
["2015-08-06","0.13"]
["2015-11-05","0.13"]
["2016-02-04","0.13"]
["2016-05-05","0.1425"]
["2016-08-04","0.1425"]
["2016-11-03","0.1425"]
["2017-02-09","0.1425"]
["2017-05-11","0.1575"]
["2017-08-10","0.1575"]
["2017-11-10","0.1575"]
["2018-02-09","0.1575"]
["2018-05-11","0.1825"]
["2018-08-10","0.1825"]
["2018-11-08","0.1825"]
["2019-02-08","0.1825"]
["2019-05-10","0.1925"]
["2019-08-09","0.1925"]
["2019-11-07","0.1925"]
["2020-02-07","0.1925"]
["2020-05-08","0.205"]
["2020-08-07","0.205"]
["2020-11-06","0.205"]
["2021-02-05","0.205"]
["2021-05-07","0.22"]
["2021-08-06","0.22"]
["2021-11-05","0.22"]
["2022-02-04","0.22"]
["2022-05-06","0.23"]
["2022-08-05","0.23"]
["2022-11-04","0.23"]
["2023-02-10","0.23"]
["2023-05-12","0.24"]
["2023-08-11","0.24"]
["2023-11-10","0.24"]
["2024-02-09","0.24"]
["2024-05-10","0.25"]
["2024-08-12","0.25"]
[" "]

{"sheet":"MSFT.US_dividends","index":2,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Dividends for MSFT.US"]
["Date","Dividends"]
["2015-02-17","0.31"]
["2015-05-19","0.31"]
["2015-08-18","0.31"]
["2015-11-17","0.36"]
["2016-02-16","0.36"]
["2016-05-17","0.36"]
["2016-08-16","0.36"]
["2016-11-15","0.39"]
["2017-02-14","0.39"]
["2017-05-16","0.39"]
["2017-08-15","0.39"]
["2017-11-15","0.42"]
["2018-02-14","0.42"]
["2018-05-16","0.42"]
["2018-08-15","0.42"]
["2018-11-14","0.46"]
["2019-02-20","0.46"]
["2019-05-15","0.46"]
["2019-08-14","0.46"]
["2019-11-20","0.51"]
["2020-02-19","0.51"]
["2020-05-20","0.51"]
["2020-08-19","0.51"]
["2020-11-18","0.56"]
["2021-02-17","0.56"]
["2021-05-19","0.56"]
["2021-08-18","0.56"]
["2021-11-17","0.62"]
["2022-02-16","0.62"]
["2022-05-18","0.62"]
["2022-08-17","0.62"]
["2022-11-16","0.68"]
["2023-02-15","0.68"]
["2023-05-17","0.68"]
["2023-08-16","0.68"]
["2023-11-15","0.75"]
["2024-02-14","0.75"]
["2024-05-15","0.75"]
["2024-08-15","0.75"]
[" "]