Googlefinance

  • Thread starter Thread starter tizianofrat
  • Start date Start date
T

tizianofrat

Hello.

I want to use the GoogleFinance function to get data of stocks on my spreadsheet.

If i copy spreadsheets of other users, i don't have any problem
but if i create a new spreadsheet and in a cell i type either =GoogleFinance("GOOG","price") or =GoogleFinance("GOOG") I always get #NAME? result.

Also if i type GoogleFinance on MY spreadhseet I don't get any autosuggestion about the formula, while if I type it on the already created one I also get the Autosuggestion.

Also I see that on the copied spreadsheet there is a disclaimer "Quotes may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.Disclaimer"

as if the datasheet is created JUST for stocks and not like an easy datasheet (As I am doing).

Can someone give me any help ?
 
Another issue that sometimes happen is that I am using the "italian version" so sometimes i have to write functions in Italian language...
 
Hi again,

Am Thu, 13 Nov 2014 14:54:53 +0100 schrieb Claus Busch:


the web site from above in italian:
https://support.google.com/docs/answer/3093281?hl=it


Regards
Claus B.
Click to expand...

What you mean with "It seems that the function only works with Google Finance web site:" ?

I did not find any good news from online technical docs.

I should go to Google finance and do something from there ?

I am doing this

1. I open my skydrive
2. Create new spreadsheet
3. In a cell I type =GoogleFinance("GOOG","price")
4. Doesn't work.




I know I am missing some key points, but I don't know which one and no online official doc epxlain it...
 
Hi Tiziano,

Am Thu, 13 Nov 2014 06:21:56 -0800 (PST) schrieb (e-mail address removed):
3. In a cell I type =GoogleFinance("GOOG","price")
Click to expand...

this is NOT a Excel function. Ask for help in Google Support


Regards
Claus B.
 
Hi Tiziano,


this is NOT a Excel function. Ask for help in Google Support


Regards
Claus B.
Click to expand...

But I am checking spreasheets created by other users and on the cell there is wrote that..

This is not the google support help page ??
 
Hi,

Am Thu, 13 Nov 2014 06:45:31 -0800 (PST) schrieb (e-mail address removed):
This is not the google support help page ??
Click to expand...

no, this is help page for installed Excel


Regards
Claus B.
 
Hi Tiziano,

Am Thu, 13 Nov 2014 08:30:17 -0800 (PST) schrieb (e-mail address removed):
in Google Finance help group they removed my post :(
Click to expand...

I tested that function in Google Drive and it works well to fetch stock
data from Google Finance.
That is the only thing you can do with this function.


Regards
Claus B.
 
Hi Tiziano,

Am Thu, 13 Nov 2014 08:30:17 -0800 (PST) schrieb (e-mail address removed):


I tested that function in Google Drive and it works well to fetch stock
data from Google Finance.
That is the only thing you can do with this function.


Regards
Claus B.
Click to expand...

cn u please tell me step by step what you did ? cuz really I can't find any solution
 
Hi Tiziano,

Am Sat, 15 Nov 2014 02:34:30 -0800 (PST) schrieb (e-mail address removed):
But i see just #NAME?
Click to expand...

this is NOT an Excel function. This is only a GOOGLE function and is
only known in Google Drive. Everywhere else you get the #NAME? error.


Regards
Claus B.
 
Back
Top