Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
franzellin said:I have a function where I import from yahoo finance the value of an option, the value is defined as:
=arrayformula(substitute(Index(ImportHtml("http://finance.yahoo.com/q?s=TBT110618p00035000"&"&workaround="&INT(googleclock()*1e10);"table";1);1;2);"*";""))
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"
and
I tried to simplify
cell B18=TBT110618p00035000
cell C18=index(ImportHtml("http://finance.yahoo.com/q?s=&B18&";"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
and
in cell B10 the formula in cell b2 is modified to incorporate the variable entry in cell A10
I looked at this blog and passed through all the posts
ReplyDeleteI 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
Hi franzellin:
ReplyDeleteThanks 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.
Cheers!
Yogi