Support » Plugin: Inline Google Spreadsheet Viewer » Yahoo Finance & IMPORTXML concatenate

  • Resolved gverderamo

    (@gverderamo)


    I have two versions of the same Google Sheets file pointing to two website pages. One has an error and the other does not.

    The page that has the error uses this in the Sheets file.

    =split(IMPORTXML(concatenate(“http://finance.yahoo.com/quote/”,B12),$B$198),”()”)

    B12 refers to a cell with a stock symbol.

    B198 contains //*[@id=”quote-summary”]/div[2]/table/tbody/tr[6]/td[2] which is an Xpath

    The idea is to pull stock dividend and yield data from Yahoo finance and then display that data in the appropriate fields.

    Everything worked fine before I added this data. I know this because if you visit
    https://theptinewsletter.com/portfolios/the-kiss-portfolio/
    you will see the exact same spreadsheet, but without the Yahoo Finance data pull.

    So, the two website pages are identical, except one points to one Google Sheets file and the other points to a different Sheets file.

    One Sheets file has the Yahoo data pull and the other does not. Beyond that, everything is identical.

    If you visit the link in the “Link to the page you need help with:” field, you will see the blank lines. If you click to see page 2, the spreadsheet data I want is displayed.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    The page you linked asking for help with returns an HTTP 404 Not Found error, so I cannot help you with that page.

    My apologies. You should be able to access the page now.

    Plugin Author Meitar

    (@meitar)

    There does not appear to be an error on any of these pages. The WordPress page exactly matches the data in your Google Sheet, which is the expected outcome. View your Google Sheet in “View only” mode (the way the plugin sees it) and you’ll see the same thing.

    Additionally, in general, if you’re going to work with dynamic data sets, it’s not a good idea to set variables on the same Sheet as your data. Create a new Sheet and reference the variables’s Sheet’s cells from the Sheet containing your actual data (and/or formulas).

    You may have found a limitation in Google Sheets such that the IMPORTXML() function does not run in some certain situations, but I’m not sure because I’m not a Google Spreadsheets engineer. As far as the plugin is concerned, though, everything is working as expected, because what I see when I view your Google Sheet exactly matches what I see when I view the page you linked.

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.