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     www.energyefficientbuild.com.

user oyz79 said: (http://productforums.google.com/forum/#!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 inhttp://finance.yahoo.com/q/
hp?s=DBC&a=01&b=6&c=2006&d=07&

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

2 comments:

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

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete