◖◗ Installation:
[1] Open Google Sheet
[2] Go to [Extensions] and click [App Scripts]
[3] Clean up opened "Code.gs" file
[4] Copy and Paste the code from here and click "Save Project"
Now, YAHOOF() Function available in you Google Sheet File.
◖◗ ARGUMENTS of the Function =YAHOOF():
[Stock] -> Stock name (ticker) listed on Yahoo Finance (No default value)
[Interval]->Time interval of requested data (acceptable values: ["1m","2m", "5m", "15m", "30m", "60m", "90m", "1h","1d", "5d", "1wk", "1mo", "3mo"])
[Start] -> start date of the requested data (should be String format: "01/01/2022") or should be fixed range (acceptable values: ["1d","5d","1mo","3mo","6mo","1y","2y","5y","10y","ytd","max"])
[End] -> end date of the requested data (should be String format: "01/01/2022")
◖◗ EXAMPLES of usage with default and non default argument values:
= YAHOOF() - [ Help Info ]
= YAHOOF("DBK.DE") - retrives data about Stock "DBK.DE" with default "1h" [ interval = "1h" ] and default last period range "1y" [ start = "1y"]
= YAHOOF("DBK.DE", "1h") - retrives data about Stock "DBK.DE" with [ interval = "1h" ] and default period range [ start = "1y"]
= YAHOOF("DBK.DE", "30m", "1mo") - retrieves data about Stock "DBK.DE" with [ interval = "30m" ] and last one month period range [ start = "1mo"]
= YAHOOF("DBK.DE", , "1mo") - retrieves data about Stock "DBK.DE" with [ interval = "1h" (default value)] and one month period range [ start = "1mo"]
= YAHOOF("DBK.DE", "1h", "10/01/2022", "11/01/2022") - retrieves data about Stock "DBK.DE" with [ interval = "1h" ] from [ start = "10/01/2022"] to [ end = "11/01/2022"]]
= YAHOOF("DBK.DE", "1h", "10/01/2022", "11/01/2021") - you will get the notification: [End] date can't be less then [Start] date
= YAHOOF("DBK.DE", "1h", "10/01/2022" ) - retrieves data about Stock "DBK.DE" with [ interval = "1h" ] from [ start = "10/01/2022" ] till current date [ end = today() ] because period is less then 1 year
= YAHOOF("DBK.DE", "1h", "10/01/2020" ) - retrieves the default 1 year data about Stock "DBK.DE" with [ interval = "1h" ] from [ start = "10/01/2022" ] because range is more then 1 year
= YAHOOF("DBK.DE", "1h", "1mo", "10/01/2022") - you will get the notification to correct start date (it should be the same format as the last argument "MM/DD/YYYY")
= YAHOOF("DBK.DE", "1h", , "10/01/2022") - retrieves data about Stock "DBK.DE" with [ interval = "1h" ] and one year backward default period range from [ end = "10/01/2022"] because argument [ start = null]
= YAHOOF("DBK.DE", , , "10/01/2022") - retrieves data about Stock "DBK.DE" with [ interval = "1h" (default value)] and one year backward default period range from [ end = "10/01/2022"] because argument [ start = null]
If you get date values in the date column instead of date format, just change format of the column (go to Format --> Number --> Date)
◖⚆ᴥ⚆◗ ADDITIONAL INFO:
You are welcome for further contributions, ideas and 🪲 reports:
Wish you profitable investment !!!! and hot ☕
P.S.
Your interest is the best motivation for me to add more API functionality to this script. 🚀