Make Google Sheet Retrieve Option Prices from Yahoo Finance

I need someone with Google Spreadsheet experience to configure an automation, so that cells will refer to a Yahoo Finance link to retrieve an option prices.

The process is explained in this video:
https://www.youtube.com/watch?v=Be7z9YeeVY0

However, I can't get it to work.

I want 12 links established, 4 each on these 3 pages;
https://docs.google.com/spreadsheets/d/1kz_dmCwC2X1wLCUlTev5zTJJyFNv6LxfuGNGoWdDghA/edit#gid=1374051754

https://docs.google.com/spreadsheets/d/1kz_dmCwC2X1wLCUlTev5zTJJyFNv6LxfuGNGoWdDghA/edit#gid=1839921384

https://docs.google.com/spreadsheets/d/1kz_dmCwC2X1wLCUlTev5zTJJyFNv6LxfuGNGoWdDghA/edit#gid=1737194923

Here is the master link:
https://docs.google.com/spreadsheets/d/1kz_dmCwC2X1wLCUlTev5zTJJyFNv6LxfuGNGoWdDghA/edit?usp=sharing

NO phone calls or emails;
Quote your price for the job, not your hourly rate.
Freelancer applications only