Googlefinance

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 ?
 
T

tizianofrat

Another issue that sometimes happen is that I am using the "italian version" so sometimes i have to write functions in Italian language...
 
T

tizianofrat

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...
 
C

Claus Busch

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.
 
T

tizianofrat

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 ??
 
C

Claus Busch

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.
 
C

Claus Busch

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.
 
T

tizianofrat

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
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Title change with Drop Down Selection 2
Calculating Returns 15
XIRR 1
Error Message: debug target...is missing 1
Alphabetical Sorting 1
Auto Stock Quote Updates 1
Capturing The First Change in a Formula 9
Excel Excel 2010 take data from one spreadsheet to paste to another 1

Top