03-14-2015, 09:31 AM
(This post was last modified: 03-14-2015, 09:40 AM by hendi_alex.)
Someone told me that instead of typing the $ character, you can just push the F4 button. Have not tried that to see what happens though.
How about this one, for importing the current price from Google finance directly into a spread sheet cell. Where A2 is what ever ticker in typed into cell A2. "Price" can be replaced with other metrics that can also be imported into the spread sheet. Similar formulas will import data from Yahoo and I assume from other sources. It sure is nice having the spreadsheets auto update most values.
=googlefinance({A2},"price")
How about this one, for importing the current price from Google finance directly into a spread sheet cell. Where A2 is what ever ticker in typed into cell A2. "Price" can be replaced with other metrics that can also be imported into the spread sheet. Similar formulas will import data from Yahoo and I assume from other sources. It sure is nice having the spreadsheets auto update most values.
=googlefinance({A2},"price")
Alex