Who says yahoo ticker search is good, they sucks, I have reported number of times using feedback, but seems like no body listens. Try putting something like "yhoo\" it does not work. Now "\" is a special character has to ignore, and goog finance does that. Apart from they they just...
Basically you need to save your request with the name "Binance" and then copy and paste the first function provided into your sheet:=IMPORTAPI("Binance","https://api.binance.com/api/v1/trades?symbol=BTCUSDT",$A$1) Then in cell A1 copy and paste the second function provided:=GOOGLEFINA...
For example, in the context of finance, principles of the present invention can be used to generate a book or portfolio of finance entities in which the user is interested, such as exchanges (e.g., NYSE, OTC, etc), stocks (e.g., including company name, ticker symbol, and share price...