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.