What would EditGrid mean to you other than a spreadsheet application? Our smart users have demonstrated some of the great uses in the financial world.

This spreadsheet makes good use of the power of remote data. It fetches stock quotes of the Hong Kong Hang Seng Index companies and incorporates them in conjunction with the latest prices of the corresponding ADRs. In this way it compares the stocks’ performance in the two markets and, owing to the 13-hour time difference between New York and Hongkong, predicts the resulting impact to the Hang Seng Index on the next day.

Additionally, its second sheet comprises a comparison between prices of H-shares listed in Hong Kong and the corresponding prices of A-shares in Shanghai. You may probably discover that the prices in Hong Kong are to some extent influenced by the A-shares.

The spreadsheet has become one of the most popular spreadsheet on editgrid.com. Many visitors keep their eyes on the ADRs every night (in Hong Kong time) and the A-shares every morning. It really showcases EditGrid’s capabilities to manage and structure financial data (and most importantly the data is live!) in order to create useful presentations of instant market trends, analysis and even charts .

Hong Kong ADR prices to affect HSI and H-shares vs A-shares


Live currencies exchange table

Our team has also made a number of spreadsheets that contain the quotes of the component stocks of the world major indexes, including DJI and GSPC of US, HSI and HSCEI of Hongkong, and a live currencies exchange table, etc.

Similar usage can be found in this spreadsheet, where world major indexes quotes are centralized to produce a nice watch-list for busy investors.

Have you thought of any other clever usage of EditGrid to manage your portfolio?

This entry was posted on Wednesday, July 4th, 2007 at 12:09 pm and is filed under Talks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.