Sorry, I don't think I was too clear so let me try this again. If this
is not possible, please also let me know.
What I want to do is have this line in the spreadsheet:
=GoogleFinance("$symbol", "price", "1/1/2008″, "10/10/2008",
"WEEKLY") so that all I have to do on a site or whatever is query the
spreadsheet and it would then the line would change to
=GoogleFinance("GOOG", "price", "1/1/2008″, "10/10/2008", "WEEKLY").
If I want information on a different stock, I can use the same query
without having to go into the spreadsheet itself and changing out the
symbol.
As a continuation of the above, if my url is
http://www.xyz.com/stock.cgi?symbol=GOOG
then I want to feed the symbol "GOOG" into my spreadsheet and get the
datapoints using the formula "=GoogleFinance("GOOG", "price",
"1/1/2008″, "10/10/2008", "WEEKLY")" and show the data back on the
site. How can I do this where it would just grab the stock ticker
symbol - the last part of my url - and feed it into the spreadsheet.
If you have any further questions, please let me know. Thanks very
much for your help!
Pragan
On Nov 7, 2:43 pm, Pragan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am trying to use Spreadsheet and Visaulization API . I have not
> done anything with these two API's. I was tyring out few examples in
> getting the data through GoogleFinance formula and I would like to
> know if there is any way to feed the stock symbol dynamically like
> $symbol,
> =GoogleFinance("$symbol", "price", "1/1/2008″, "10/10/2008", "WEEKLY")
>
> so that we can get the data for the particular symbol if someone
> select a symbol, like for example: "GOOG" then it should show the
> datapoints for GOOG symbol.
>
> Is this possible? It will be helpful if we need to show many symbols
> and I guess it would be tough to write/hard code the above line of
> code for many symbols.
>
> Also, can anyone please guide me how to retrieve the data from
> spreadsheet and display the result as table/chart in a webpage?
>
> Or, if there is a way to embed the chart from
> finance.google.com(http://finance.google.com/finance?q=goog) as
> because in this case, it looks like we can change the symbol to appear
> dynamic based on the symbol we search for.
>
> Please let me know as its quite important for me to decide if I can
> proceed further
>
> thankspragan.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en
-~----------~----~----~----~------~----~------~--~---
