We recently added the STOCK function in Zoho Sheet. Using this, you can now add stock quotes to your spreadsheets. You just need to specify the symbol and the type of data you want (optional).
Examples:
=STOCK(“MSFT”)
=STOCK(“AAPL”, “VOLUME”)
Change in stock quotes are automatically reflected in your spreadsheets with a max of 30 minutes delay. But you would need to reopen your spreadsheet or your published spreadsheet for the changes to show. Stock function is available under the Stock category and under the Financial category in our functions dialog that appears when you click on the fx icon.
There are some limitations to it. This cannot be currently used in nested functions, nor can it refer other cells. We hope to support these things in the future.
Note: Stock details are provided from free stock sources available in the Web. The data may be delayed up to 30 minutes. Also the data provided is solely for informational purposes.
We have also added support for 7 more languages – Portuguese (Brazilian and European), Danish, Italian, Russian, Swedish, and Dutch. This is in addition to the existing languages of English, French, German, Japanese and Spanish. Do you want Zoho Sheet in your own language? Send us a mail to support at zohosheet dot com.
Other features include HTML and printable views of public spreadsheets, more shortcuts like Ctrl+Home, Ctrl+End and some fixes in charts. Have a look at our What’s New page for more information.
Why is the STOCK() function disabled and will it ever be enabled again?
Hi Vicky, Sorry for the delay in response. The STOCK() function in Zoho Sheet has been enabled currently for the US Exchanges alone, powered by IEX. We're working on the other Exchanges, and it'll be made available in the near future. For any update on the same please follow https://help.zoho.com/support/zohocorp/ShowHomePage.do#Community/singlepost/temporary-glitch-in-stock-function.
With our recent update we support cell reference in Stock() function. You can now pass a cell reference as an argument. eg: = STOCK(B5;"Price"). You can now use Stock() function in a nested formula. You can also copy-paste this function and the cell references are automatically adjusted.
With our recent update we support cell reference in Stock() function. You can now pass a cell reference as an argument. eg: = STOCK(B5;"Price"). You can now use Stock() function in a nested formula. You can also copy-paste this function and the cell references are automatically adjusted.
I'd also like to see the ability to pull in some additional data. Marketcap and/or shares outstanding is a must. It would also be very good to pull in some fundamental data like Revenue and Net Income if that is available.
I'd also like to see the ability to pull in some additional data. Marketcap and/or shares outstanding is a must. It would also be very good to pull in some fundamental data like Revenue and Net Income if that is available.
We haven't enhanced the stock functions after initial update. We will enhance the stock function to support cell reference in a future update. We will keep you posted when we start working on this enhancement.
We haven't enhanced the stock functions after initial update. We will enhance the stock function to support cell reference in a future update. We will keep you posted when we start working on this enhancement.
This posting is dated July 11, 2007, and you STILL cannot refer to other cells within these Stock functions. What is going on? Who wants to have to edit the function when, instead, you can refer a function to a cell where you can type in the ticker and the function automatically retrieves that data for the inputted ticker. Get with it!
This posting is dated July 11, 2007, and you STILL cannot refer to other cells within these Stock functions. What is going on? Who wants to have to edit the function when, instead, you can refer a function to a cell where you can type in the ticker and the function automatically retrieves that data for the inputted ticker. Get with it!