Monday, August 6, 2012

yogi_Pull Specific Cell From Yahoo Finance HTML Table

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #678   Aug 06, 2012

user oyz79 said: (!category-topic/docs/spreadsheets/ZCr_30gjP3s)
Import one cell from an html table 
Hi, Any idea how to import the top data (in this example, Aug 6th, 2012) from the table in

e=7&f=2012&g=dI can figure out how to import the whole table, but I just need that one particular data point (the first/most recent date on the table), not the entire table itself.
following is a solution for pulling the value of a specific cell based on a row number and column number in the table


  1. You Are Very Welcome Scott ... Now Let Us Keep Googling.

    Cloud Computing -- Google Docs Way