Include Cell ref in Google sheets to form a URL when using Importxml function

0
votes

Can anyone help with an Error i'm getting when trying to include a Cell ref to form the URL on Google Sheets ImportXML? I've followed other examples on here but I'm still getting an error returned.

=JOIN(",",Importxml(CONCATENATE("https://finance.yahoo.com/quote/",B1,"/cash-flow?p=",B1,""//*[@id="Col1-1-Financials-Proxy"]//span"),1)")))

In addition, on other successful ImportXML commands I have running, the data is being returned as 20B (as an example) when I need this in my spreadsheet as 2,000,000,000. Can this conversion be included as part of the Import command?

1
regexweb-scrapinggoogle-sheetsgoogle-sheets-formulagoogle-sheets-importxml
Looks like an issue with quotes. Can you give a sample of what your working formula looks like when you implement the value of B1 by hardcoding? – ziganotschka
Here's an example: =JOIN(",",Importxml(CONCATENATE("finance.yahoo.com/quote/msft/cash-flow?p="msft"/*[@id="Col1-1-Financials-Proxy"]//span"),1)"))) (ignore the https:// being stripped out above) – harrysdad
This formula does not work for me. – ziganotschka
Well, i'm hoping somebody will be able to help me correct the formula so it does work. – harrysdad
share a copy of your sheet – player0

1 Answers

0
votes

replace A80 with your formulas:

=REGEXEXTRACT(A80, "\d+")*1000000000

0