Saturday, May 21, 2011

yogi_Insert A Cell Value In An Import Function

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
franzellin said:
I have a function where I import from yahoo finance the value of an option, the value is defined as:
I would like to modify TBT110618p00035000 in
&A1&A2&A3&000&A4&000 where
a1= cell with the content "TBT"
a2= cell with the content "110618"
a3= cell with the content "c"
a4= cell with the content "35"
I tried to simplify
cell B18=TBT110618p00035000
cell C18=index(ImportHtml("";"table";1);1;2)
but I have still no success
In reference to the first question I have incorporated the values of variable entries in cells A1,A2,A3, and A4 in the formula in cell B6
in cell B10 the formula in cell b2 is modified to incorporate the variable entry in cell A10


  1. I looked at this blog and passed through all the posts
    I am sure is going to be the "Reference" for the Google Spreadsheet users
    You should think about a Summary where at once we can find ALL your Solutions and not only those of the current month.. thanks

  2. Hi franzellin:

    Thanks for your comment.
    If you scroll to the bottom of the blog you will see the Blog Archive ... where you can click on any month and the hyper-linked list of my posts for that month is displayed.