0

Looking for help pulling specific cells from a web site into a Google Spreadsheet. I want to pull "last" price from this page but only a few specific ones. Such as Dow, Nasdaq 100, S&P 500, S&P 400 Mid Cap and Russell 2000. I tried using ImportXMLand managed to import the whole table but can't seem to figure out how to pull just those cells. I also want to be able to do each cell individually so I can move and adjust the spreadsheet to my liking.

  • So what’s your question? – Alex May 27 '14 at 7:55
2

You might try:

=index(importhtml("http://bigcharts.marketwatch.com/markets/indexes.asp","Table"),5,4)  

for the NASDAQ 100 Index and adjust the 5 to suit for others.

| improve this answer | |
1

The following setup will return the last price for NASDAQ 100 Index (NASDAQ Calculation)

A1: http://bigcharts.marketwatch.com/markets/indexes.asp
A2: =//tr[contains(.,'NASDAQ 100 Index (NASDAQ Calculation)')]/td[4]
A3 Formula: =IMPORTXML(A1,A2)
A3 Result: 4,512.54

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.