Reversal is a technical term used by the technical analysts to reflect the onset of an opposite trend in an ongoing trend. The stock generally shows reversal signs, which could be either technical indicators or price patterns such as Head & Shoulder, which could be analysed to gauge the reverse side movement in an ongoing trend.
What is data warehousing? Data warehousing is defined as the method of gathering & handling data from different sources to get meaningful output and insights. Data warehousing is central to the BI system and is built for data analysis and reporting. Source: © nfo40555 | Megapixl.com In simple terms, a data warehouse is a large collection of data utilized by businesses to make investment decisions. What are the characteristics of data warehousing? Data warehouse has supported businesses in making informed decisions efficiently. Some of its key features are highlighted below: The data in a data warehouse is structured for easy access, and there is high-speed query performance. The end users generally look for high speed and faster response time – two features present in data warehousing. Large amount of historical data is used. Data warehouse provides a large amount of data for a particular query. The data load comprises various sources & transformations. What are the benefits of data warehousing? The Companies which used data warehousing for analytics and business intelligence found several advantages. Below are some of them: Better Data: When data sources are linked to a data warehouse, the Company can collect consistent and relevant data from the source. Also, the user would not have to worry about the consistency and accessibility of the data. Thus, it ensures data quality and integrity for sound decision making. Faster decisions: Through data warehousing, it is possible to make quicker decisions as the data available is in a consistent format. It offers analytical power and a comprehensive dataset to base decisions on tough truths. Thus, the people involved in decision making do not have to rely on hunches, incomplete data, and poor quality data. It also reduces the risk of delivering slow and inaccurate data. How does a data warehouse work? A data warehouse is like a central repository where the data comes from various sources. The data streams into the data warehouse from the transactional system and other relational databases. These data could either be structured, semi-structured or unstructured. These data get processed, altered, and consumed in a way that the end-user can gain access to the processed data in the data warehouse via business intelligence (BI) devices, SQL clients and spreadsheets. A data warehouse merges the data that comes from various sources into a complete database. The biggest advantage of this merged data is that the Company can analyze the data more holistically. It also makes the process of data mining smooth. Copyright © 2021 Kalkine Media Pty Ltd. Component of a data warehouse A data warehouse can be divided into four components. These are: Load Manager Load Manager, also known as the front component, does operations related to the mining and loading the data into a data warehouse. Load manager transforms the data for entering into Data warehouse. Warehouse Manager The warehouse manager manages the data within the data warehouse. It analyses data to confirm that the data in the data warehouse is steady. It also conducts operations such as the creation of indexes and views, generation of denormalization and aggregations, modifying and integrating the source data. Query Manager Query Manager is a backend component that does operations concerning the supervision of user queries. End-User access tools End-User access tools comprise data reporting, query tools, application development tools, EIS tools, data mining tools, and OLAP tools. Roles of Data Warehouse Tools and Utilities The tools and utilities in a data warehouse are used for: Data extraction: The data extraction process involves gathering data from heterogeneous sources. Data cleaning: Data cleaning consists of searching for any error in the data. Data transformation: Data transformation process involves changing the data into a data warehouse setup. Data loading: This process involves data sorting, recapping, consolidating, verifying integrity. Refreshing: This process requires revising data sources to the warehouse. Application of data warehouse Data warehouse plays a considerable role across multiple sectors. Some of the sectors it caters to are highlighted below. Aviation sector In the aviation sector, a data warehouse’s role can be seen in crew assignment, route profitability analysis, any promotional activity. Banking Industry In the banking sector, the focus is on risk management, policy reversal, customer data analysis, market trends, government rules and regulations and making financial decision. Through a data warehouse, banks can manage the resources available on the deck effectively. Banks also take the help of a data warehouse to do market research, analyze the products they offer, develop marketing programs. Retail industry Retailers act as an intermediary between the producers and the customers. Hence, these retailers use a data warehouse to maintain the records of both producers as well as the customer to maintain their existence in the market. Data warehouses help track inventory, advertisement promotions, tracking customer buying trends and many more. Healthcare industry In the healthcare industry, a data warehouse is used to predict the outcome of any test and taking relevant action accordingly. Data warehouses help them to generate patient treatment report, offer medical services, track the medicine inventory. Many patients visiting hospital have health insurance. Through a data warehouse, hospitals maintain the list of insurance providers. Investment and insurance sector In the insurance and investment sector, the role of data warehouse becomes important in tracking the data pattern, customer trend and market movement. Services sector In the services sector, a data warehouse is used for maintaining financial records, studying the revenue pattern, customer profiling, resource management and human resource management. Telecom The telecom sector uses a data warehouse in the promotion of its offerings, making sales decision, distribution decision, features to include in case they decide to launch a new product based on the customer requirement. Hospitality The hospitality sector involves hotel and restaurant services, car rental services etc. In this sector, the companies use a data warehouse to study the customer feedback on the various services offered and accordingly design and evaluate their advertising and promotion campaigns.
Dead Cat Bounce Dead Cat bounce is a colloquial phrase which is quite popular in the financial markets. The term was coined a long time ago and generally referred to the peculiar behaviour of the price. The phrase denotes a recovery in the asset’s price, often a sharp one after a prolonged downtrend. Sometimes it is also referred to a short but sharp fall, succeeded by an equally sharp recovery. How does a downtrend continue for a long time? Quite often, some securities in the financial markets depict a very long downtrend which may last from a few months to a few years depending on the severity of the fundamental headwinds. These prolonged downtrends are so strong that no support levels can withhold the downtrend and the prices keep on falling. Every support level gets taken out by excessive selling, which pushes the prices even lower. These lower prices force the long holders to liquidate their positions as no visible halt in the downtrend is noticed. This liquidation from existing buyers further fuels the selling, leading to the continuation of the downtrend. As the price keeps on falling, the buyers do not get enough confidence to buy and consequently keep getting overpowered by selling pressure continues the downtrend. So what is the ideology behind “Dead Cat Bounce”? In due course of a downtrend, the security tends to become oversold for the time being. Oversold is a technical term is used for security which seems to have fallen quite a bit in a specified period. In other words, a security that has been continually sold in a specified period tends to reach a level wherein the sellers are no more interested in selling at further lower rates. This is where the buyers’ step in and try to buy these stocks at low prices, leading to an increase in demand over the supply. This fresh buying tends to push the price up hence resulting in a short upside movement or, in technical parlance a “Bounce”. This point is where the downtrend witnesses a temporary upside momentum which is exactly quoted as a “Dead Cat Bounce”. The ideology is “Even a dead cat will bounce if fallen from a great height.” Likewise, a short bounce is quite expected after a prolonged downtrend which does not change the trend as a bounce does not mean the cat has become alive. Image Source ©Kalkine Group Does it signify a reversal from a downtrend? A Dead Cat bounce is an upside momentum, witnessed after a prolonged downward trend, generally near the oversold price region. But it is to be noted that this price bounce is merely a reaction of the downtrend which is often witnessed in the oversold areas. This does not change the entire trend, and more often than not, the trend continues in the primary direction after the bounce fizzles out. Why is it difficult to trade a Dead Cat Bounce? Most of the time it is difficult to trade a move like a Dead Cat Bounce as the bounce is often very quick and short-lived. The overall trend remains negative, which is in contradictory to the short-term bounce. Also, few investors mistake it for the trend change, which often proves to be a mistake. It generally becomes difficult to estimate some key support areas from where the bounce may occur as the downtrend is quite strong and lacks demand to support the price. However, there are some momentum indicators like RSI (Relative Strength Index), Stochastics oscillator etc. which may help to gauge oversold zones from where the bounce may occur. What are the reasons for a Dead Cat Bounce? There could be many reasons for a Dead Cat Bounce to occur on the charts as the sudden demand may come due to numerous reasons. Some of the reasons are Oversold Price As discussed, due to a prolonged downtrend and continued selling the price often comes to a level wherein the sellers are no more interested in selling at these lower prices and at the same time buyers often find a value proposition. This leads to a spike in demand, which ultimately results in a Dead Cat Bounce. Strong support area There are some levels of support on the price chart that are quite prominent. In other words, there are some regions of support which are quite strong and may remain relevant for years. These support levels are generally hard to break at the first attempt, which results in a bounce or a complete reversal. How to profit from a Dead Cat Bounce There are two different strategies when it comes to trading these kinds of sharp and against the trend moves. They are contradictory to each other, but both are based on proven price behaviour. Short Selling the rally As the primary trend of the underlying is still downward, one thought arises to go short on the bounce. This strategy one to participate in the downtrend but with a much better price. If these rallies are met with a resistance level like a falling trendline, horizontal price resistance etc. then these areas are ideal to sell the bounce in a downtrend. Buying into the rally Another opinion arises, why not to participate in the bounce? This strategy can also be fruitful provided the bounce should be stronger and last for a while, which is not always the case. This essentially calls for a very quick decision making while capitalising on the temporary bounce. Bottomline A Dead Cat Bounce is a prolonged downtrend followed by a short-term bounce. These bounces generally don’t last long, and once they fade, the trend continues towards the south. However, sometimes a bounce may also act as a reversal, but for the added confirmation a trader should also look at other signals of a reversal like bullish divergence at the bottom or a double bottom chart pattern.
Hammer candlestick found in price charts of financial assets, refers to a type of bullish reversal candlestick pattern, that consists of only one candle which resembles a hammer.
What is an impairment? Impairment is accounting write off of a company’s asset, which can be an intangible asset as well as a fixed asset. An impairment loss is incurred when the fair value of the asset is lower than the carrying value in the balance sheet. Alternatively, impairment charges can be incurred when the recoverable value of the asset is lower than the book value. Impairment charges are recorded in the income statement of the company as an expense. Image Source: © Kalkine Group 2020 A widespread economic crisis is followed by a recession, which usually impacts the value of assets held by a company. Such events force companies to test the value of assets in the balance sheet, and this often leads to an impairment charge. IFRS accounting standards ensure that a company’s carrying value of assets depicts a value which is not in excess of the recoverable amount. Why are impairments charged by companies? As per the accounting rules, a business is often measured by its book value of assets. Specifically, the assets of the company carry the capability to generate future cash flows for the firm. When the ability of an asset to deliver expected future returns is hampered, the value of assets is decreased. Therefore, it becomes an ethical responsibility of the companies to show a fair picture of the assets. Goodwill generated at the time of business combination is required to be tested for impairments annually. Companies are required to assess any indication that could cause a potential devaluation to the asset. When a company is holding intangible assets with an indefinite life, they are required to test the assets for impairments annually. Cash generating units are often valued on the discounted value of future cash flows. Consequently, when market interest rates are rising, it impacts the discount rate used in estimating the recoverable amount. Assets can be impaired because of other reasons as well. Suppose the plant and machinery of the company were damaged due to earthquake, it would result in a reduction in the value of an asset or even full write-off of the asset. Image Source: © Kalkine Group 2020 Companies often avail consulting services to improve the performance of the business. Consultants may advise companies to shut down operations at any plant, which could result in the sale of the asset at a consideration lower than carrying value. Oftentimes, internal reporting of the companies indicate that the performance of the asset may not yield expected benefit. This would force the management to undertake impairment testing for the asset. Impairment vs amortisation Amortisation is a systematic decrease in the value of an intangible asset. Amortisation of intangible assets is a process of capitalising the expense incurred on the acquisition of the asset, and then periodically recording the expense on the income statement. Impairment, on the other hand, is an irreversible decrease in the value of the asset, which is shown as an expense in the income statement. It is charged when the recoverable amount from the asset is lower than the carrying value of the asset. Impairment vs depreciation Depreciation is a periodic devaluation of fixed assets. It is undertaken by the companies to account for the wear and tear caused to the asset during its useful life. When a firm seeks to sell an existing asset, the buyer of the asset will deduct the depreciation from the cost of the asset before adding any premium or discount to the value for arriving at the purchase price. Impairment on fixed assets could be related to an unusual fall in the fair value of the asset. For instance, the fair value of the machinery could be impacted significantly when a new and more efficient machine is available in the market. Similarly, an earthquake or fire can also devalue the value of the fixed asset in the balance sheet. Reversal of impairment loss Under the reversal of impairment loss, the approach used to determine reversal is similar to the approach used in identifying the impairment loss. Reversal of impairment loss cannot be undertaken for goodwill, and it is prohibited. Companies assess whether any impairment loss recognised in the prior periods may no longer exist or have decreased. Impairment losses can only be reversed when the estimates used in determining recoverable amount are changed. Individual asset Previously incurred impaired individual asset can be reversed only when the estimates used in calculating the recoverable amount have changed. For instance, the changes in market interest rates could impact the discount rates used in calculating the recoverable amount. Unless the reversal relates to a revalued asset, the reversal of impairment loss is recognised in the income statement. The revalued asset should not be more than depreciated historical cost without impairment. Cash generating unit In a cash-generating unit, the reversal of impairment loss is allocated on a pro-rata basis with the carrying amounts of the assets. The carrying value of an asset must not be increased above the lower of: recoverable amount and carrying amount should have been determined without any prior impairment loss, net of amortisation and depreciation.