Google Sheets API integration

I need an engineer who specialises in API development.

I would like to integrate a Trading brokers API with Google sheets.
This is the API link to the broker : https://labs.ig.com
I would like to pull in some live data from the broker into my Google Sheets spreadhsheet.
I believe Sheets supports something similat to Javasript.

I'd like to try and keep it quite simple to begin with, pulling in only live price data and then we can look at enhancing it later. (Perhaps executing trades within my Sheets)

So initially, I would just like to try and pull live stock prices through the API and deliver them to my
spreadsheet.
Eg. When I enter a Stock ticker ie. 'AAPL' into a cell in my sheet, I would like to pull the live Buy and Sell prices to be into some designated cells in my Sheet.

Note. I already have a specific Sheet that I would like to try and integrate the API with. I can provide more details if you would like to proceed further.