tag:blogger.com,1999:blog-6799428426680372912.post262211632456703655..comments2023-11-15T17:26:49.562+05:30Comments on iGoogleDrive: Google Spreadsheet How To Freeze Dynamic ValuesKishhttp://www.blogger.com/profile/13751098853627072874noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6799428426680372912.post-85241723235039499662020-03-12T09:40:09.099+05:302020-03-12T09:40:09.099+05:30Note that when GOOGLEFINANCE retrieves historical ...Note that when GOOGLEFINANCE retrieves historical results it will return an array with column headers and the date. If you want a singular value, use INDEX to extract the second row, second column, for example:<br />=INDEX(GoogleFinance("GOOG","price",DATE(2020,1,1)),2,2)Yossarian Kinghttps://www.blogger.com/profile/09241424843786195149noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-1166019678028762422020-03-12T09:24:37.010+05:302020-03-12T09:24:37.010+05:30I think a better solution is to use the date param...I think a better solution is to use the date parameter to GOOGLEFINANCE to look up a value as of a specific date. See documentation for details - https://support.google.com/docs/answer/3093281?hl=enYossarian Kinghttps://www.blogger.com/profile/09241424843786195149noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-28088031823219922152017-12-26T03:01:41.664+05:302017-12-26T03:01:41.664+05:30I am wondering how to replace GOOGLEFINANCE with a...I am wondering how to replace GOOGLEFINANCE with another function?Anonymoushttps://www.blogger.com/profile/17602852061986490450noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-2774627321369531482014-04-03T22:54:33.848+05:302014-04-03T22:54:33.848+05:30Hi,
how can I use IMPORTXML() instead of GOOGLEFI...Hi,<br /><br />how can I use IMPORTXML() instead of GOOGLEFINANCE()?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-77079447658995744892013-08-07T02:13:18.596+05:302013-08-07T02:13:18.596+05:30Hi Kishan,
I'm not sure if this solution will...Hi Kishan,<br /><br />I'm not sure if this solution will help and I don't know if I explained correctly. Please see the example spreadsheet:<br />https://docs.google.com/spreadsheet/ccc?key=0AnEYa1POf3VhdGt4aWk0MTIxVTlvRm56dmpFZ21Yd0E&usp=sharing<br /><br />1. I want to place the current exchange rate on the spreadsheet for reference. (Cell B1)<br />2. I want to freeze the amounts Raphaelhttps://www.blogger.com/profile/07745602091831926478noreply@blogger.com