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.
Retrieve last entry via ImportXML
google spreadsheets;import