调用我的自定义yahoofinance函数时,它将标准'XMAS.INGA作为输入,然后切断场地(XAMS),并查找雅虎名称(AS),然后将INGA.AS传递给雅虎API: =yahoofinance(index(split(A2, "."), 0, 2) & "." & vlookup(index(split(A2, "."), 0, 1), Exchanges!E:J, 6, false)) function yahoofinance(ticker) { ...
=GOOGLEFINANCE(A2,"price") / index(GOOGLEFINANCE(A2,"price", datevalue(today()-365) ) , 2,2) - 1 it has A2 to refer to the ticker in A2 cell,so i can use it in a table. "A2 is currently the ticker COIN" When I save as an excel file it shows the following and is no lo...
As far as I know, Binance doesn't provide any endpoint that returns only volume, so you have to use the /api/v3/ticker/24hr endpoint and pull it out yourself. There are 2 ways to do this: 1) Use standard Google Sheets functions like HLOOKUP or MATCH to extract the metric you want...
The google finance formula is for a 52 week performance of a stock that will only use one cell. =GOOGLEFINANCE(A2,"price") / index(GOOGLEFINANCE(A2,"price", datevalue(today()-365) ) , 2,2) - 1 it has A2 to refer to the ticker in A2 cell,so i can use it in a ...