3

I need to parse balance sheet data for a given set of stocks on otcmarkets.com. I'm trying to use the importXML function in Google Spreadsheet, but it is not returning any data for me. The xPath query did not return any data. Here is the function I'm using:

=importxml("http://www.otcmarkets.com/stock/AAEH/financials","//*[@id=’totalCurrentLiabilities’]")

Let me know what I'm doing wrong and if there is a better way to parse specific balance sheet data.

Rubén
  • 34,714
  • 9
  • 70
  • 166
user3133308
  • 41
  • 1
  • 4

2 Answers2

4

The page contents are loaded using JavaScript, which is not executed in Google Spreadsheets. You cannot parse this page using =importxml(...).

What to do now?

  • Ask the providers if they offer an API. Most probably they don't want to be scraped anyway.
  • Analyze the page logic and find the JavaScript call which loads the data, and fetch it yourself. Most probably it is in JSON format, which is not easy to parse in Google Spreadsheets without external libraries.
  • Use some environment to query the data which will execute the JavaScript calls, for example Selenium. Will result in much more programming than using Google Spreadsheets.
Jens Erat
  • 37,523
  • 16
  • 80
  • 96
0

Try using the importdata function:

=IMPORTDATA("http://www.otcmarkets.com/otciq/ajax/EdgarFinancialsController.json?ticker=AAEH&mode=annual")
Aurielle Perlmann
  • 5,323
  • 1
  • 15
  • 26