How to import options data from yahoo finance with G.sheets?

Fool Community Help Desk Help with this STUPID computer!
1

Hi,
i have a google sheet, and imported optionsdata with a script. In the past i did it via the Yahoo API like this: UrlFetchApp.fetch(“https://query1.finance.yahoo.com/v7/finance/options/” + ticker)

But in 2023? Yahoo closed the usage of their API. How can i import options data to my sheet?
Thank you for any feedback

2

Google sheets still works for me to import stock prices. I don’t know about options.

3

For Stock prices, Googlefinance works fine. But Google delivers no Options Data.

4

I gave up on downloading option prices from Yahoo! I now use the CBOE

https://www.cboe.com/delayed_quotes/vix/quote_table

The Captain

2 Likes