Customer column pulling value from "dynamic" web URL based on another column value

Hello everyone,

I'd like to bring some information from Yahoo Finance in my powerbi model such as the price at closing and be able to get the lastest value each time I refresh my report.

example:

//finance.yahoo.com/quote/GOOG

There is a table that give me the price at the closing

I've a table in PowerBI to contains the list of all the stocks ticker in a column. 

I'd like to add a custom column on that table that brings the price at closing based on the stock ticker for each rows.

For that I have to pass the column "Ticker" into the web URL for each row then pull the specific value in the calculated column.

I did some research and saw that I should use parameter for dynamic Web URL, but I don't find how to change the parameter based a table column.

Thanks in advance for your support