Yes i created a google sheet, put the googlefinance function in (and it showed correctly in the sheet), but when i linked the sheet to glide it only showed column headers and where the rate should have been it showed a blank cell.
Here is the post. It was actually not you who linked the video, but responded to it. My Apologies.
Ok, I will learn to use API calls then it seems. thanks!