HI all, I have a simple dilemma that I do not know the answer to. I have a spreadsheet with two cells, B1 and B2, and in B1 would be a stock ticker symbol (like GOOG or AAPL for example) and in B2, I have the function:
=GoogleFinance(B1,"price") I would need the spreadsheet to interact with my site so that when a user comes into my site, they would be able to see the stock price of any stock they choose. I would only want the price of one stock on one page at a time so here's the problem: I have 12k stocks to choose from (plus some miscellaneous mutual funds). I figured it would be easier to set up a js code to programmatically put the stock ticker symbol into a put function that would put the symbol itself into the cell B1 and from that point, get the data from B2. I don't know how to do this though, because I do not know how to get the site to even connect to my spreadsheet. I see the publishing option, but I do not know how to incorporate that into my page in a way that would allow me to write code using the put function. I appreciate the help, let me know if you have any questions. Thanks! ss0luu --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" 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-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
