The Shanghai Composite Index, a stock market index, tracks the performance stocks traded in Shanghai, China’s financial capital. It is one of the three most popular indices in China. The other two are Shenzhen Component Index (CSI 300) and CSI 300. It was created as a weighted average of all shares listed on the Shanghai Stock Exchange in 1990. It was officially listed as an official measure for domestic equities in December 1991, along with SSE180 Index or SSE50 Index.
The Shanghai Composite Index
The Shanghai Composite index is a composite index that aggregates the stocks of companies listed on the SSE. It’s used to help understand the development of China’s stock market and the broader economy. The benchmark index for the Chinese stock market is the SSE index.
The SSE index is calculated using a weighted combination index relative to a baseline established in 1990 when the SSE was reformated (according to the Paasche weighted comp price index formula). Although it generally gives greater weight to larger companies, the importance of each company within the index is not proportional to its market capitalization.
The main SSE index covers all companies listed on the Shanghai Stock Exchange. Therefore, smaller indices were created only to include more prominent companies. Other vital indices, SSE 180 and SSE 50, and SSE 20, only represent the performance of the largest 180 and 50 companies on the Shanghai Stock Exchange.
Five-year evolution of the SSE Index (Image: Google Finance). The Shanghai Composite index’s real-time quote can be followed using various graphical tools, such as the Shanghai Stock Exchange and Google Finance, Yahoo Finance, Bloomberg, and Yahoo Finance.
U.S. Embassy Explosion rattles Shanghai and Shenzhen Stock Exchanges.
Stock monitoring. Stock monitoring. (Image courtesy Pxhere). TAIPEI (Taiwan News – A minor explosion at the U.S. Embassy in Beijing on July 26 rattled Chinese stock market markets. The Shanghai Stock Exchange (SSE), down 1.18 percent, and the Shenzhen Stock Exchange [SZSE] is down 0.74 percent.
To limited effect, a man set off a small explosive device in the vicinity of the U.S. Embassy in Beijing. According to authorities, the bomber, who sustained minor injuries, was the only victim in police custody.
The composite Shenzhen Stock Exchange index opened today at 9,467.37 and sank to 9,334.40 after news of the Embassy explosion.
The Shenzhen Composite Index was launched on July 26. Google Finance image.
The Shanghai Stock Exchange composite index opened today with 2905.79 points and dipped from 2892.59 up to 28676.99 shortly after the event.
Shanghai Composite Index, July 26, 2007. Image courtesy Google Finance
Both markets stabilized and saw modest gains in trading before closing at 3:00 p.m. local when the severity of the explosion was known.
The incident did not cause any damage to U.S. Embassy property, and its motive is still unclear.
About Shanghai Stock Exchange Composite Indicator
This index is used to determine the performance of common stocks in Shanghai and Shenzhen.
The Shanghai Stock Exchange Composite Indicator (SHCOMP) is a weighted indicator of all stocks traded on the Shanghai and Shenzhen stock markets.
It is one of the key indices that measure China’s market performance and is an important benchmark index to gauge China’s economic health.
Since 1990, the SHCOMP has been used to calculate the Shanghai A-Share Index. In 2000, it was renamed the “Shanghai Stock Exchange Compound Index.”
The Shanghai Composite Index was launched in 1991 and tracks all class A and B shares listed on the Shanghai Stock Exchange. It is the largest stock exchange in mainland China. It was down more than 6% from the beginning of 2020 as of April 18, 2020. Kweichow Moutai Co., PetroChina Industrial and Commercial Bank, and Agriculture Bank of China are some of its most important stocks. Although the Shanghai Composite Index is a popular indicator of China’s economic health, foreign investors are generally not allowed to invest in it due to strict Chinese controls. They must instead turn to exchange-traded funds (ETFs).
How to track stocks with the GOOGLE FINANCE Function
Stocks are a portion of the company’s ownership. They can be traded on a stock exchange like NASDAQ or through brokers. Stocks can be bought for a variety of reasons, including trading and dividend income. The GOOGLE Finance function allows you to assess and track the changes in your stock quickly. It also lets you import stock data directly from Google Finance into your Google Sheets.
To determine your stock price or value, first, you need to find the ticker symbols for the companies you are interested in. It is possible to Google the symbol (e.g., “facebook ticker”) or uses Yahoo Finance. You might want to import the stock value or price of Facebook Inc. that is traded on NASDAQ. For Facebook, the ticker symbol is; for NASDAQ, it will read in the formula with the attribute.
Find currency exchange values with GOOGLE FINANCE.
It is more convenient to convert the currency value immediately from one currency to another than import a currency rate. You can quickly create a currency converter using Google Sheets and the GOOGLE FINANCE feature. Import the currency rate and multiply it with the amount you wish to convert.
The formula is found in the B2 cell.
The formula for D2 cell multiplies the exchange rate return to B2 by the value to convert to C2:
To work with currency, use the GOOGLE FINANCE feature.
It’s easy to find the current exchange rate within your sheets by using the GOOGLE FINANCE function. We will need to import, for example, the rate of the currency pairing PLN to USD. Here’s the GOOGLE FINANCE formula
Alternate methods include using the cell of your argument. Here’s how to calculate the USD to GBP currency exchange rate.