Macro to convert the reference from relative to absolute for a selected range of cell

Note: Before you run this macro, ensure you have selected the cells, whose reference you want to convert

Sub Relative_to_Absolute()

Dim fmlaCells As Range

On Error Resume Next

Set fmlaCells = Selection

fmlaCells.Formula = Application.ConvertFormula _

(fmlaCells.Formula, xlA1, xlA1, xlAbsolute)

End Sub

 

Macro to trace dependents for a range of cells

 Sub TraceDependents()

'updateby Extendoffice

    Dim xRg As Range

    Dim xCell As Range

    Dim xTxt As String

    On Error Resume Next

    xTxt = ActiveWindow.RangeSelection.Address

    Set xRg = Application.InputBox("Please select the data range:", xTxt, , , , , 8)

        If xRg Is Nothing Then Exit Sub

    For Each xCell In xRg

        xCell.ShowDependents

    Next

End Sub

Source: https://www.extendoffice.com/documents/excel/3402-excel-trace-dependents-multiple-cells.html

Macro to consolidate data from multiple worksheets

When data are spread across multiple worksheets and one wanna put together everything in a  single sheet of the workbook, the following macro works.

Doji-s and What they mean

1. Dragonfly 

It gives a buy signal when the the doji, high is broken on the next candlestick.

2. Gravestone

It’s a bearish Doji.  If the market is in an uptrend and if you notice a Gravestone Doji candlestick, it may be the first indication that the trend may start to reverse to a downtrend.

3. Four price

This means that the price did not change at all during the period of a candlestick.

It’s common to see the Four-Price Doji in markets where trading volume and liquidity is extremely low.

If you see many Four-Price Dojis on the chart – stay out of this market.

Because liquidity is so low, you won’t be able to get in and out of your trades easily.

Sources:

https://www.tradingwithrayner.com/doji-candlestick-pattern/

https://www.investarindia.com/blog/importance-of-doji-patterns-in-trading/

Snippets from the book "The Ultimate Guide to Price Action Trading"

 Tried to snip the key-take-aways from the book authored by "Rayner Teo" on Price action trading

What are Impulsive and Corrective moves ?

Next, the author discusses four key technicalities to look gauge the trend and its strength

I found the following mention to be trivial. But the lead the Rising three method gives is what that causes me to mention this here.

Variation of rising three method- Penants, Flags- a forerunner to a breakout

To throw more light on the penants and flags, quoting from here

• Bullish Penant

To identify a bullish pennant, you’ll need to watch for two elements. Firstly, a pronounced upward movement beforehand known as the ‘pole’. Secondly, a price consolidation that forms a roughly symmetrical triangle with its support and resistance lines.

• Bearish Penant 

To identify a bearish pennant, look for a consolidation between support and resistance after a major bearish price move (the pole). The support and resistance lines will form a roughly symmetrical triangle, showing that the market is in conflict between positive and negative sentiment.

• Other similar patterns

The following readings would give a deeper understanding of the commonly observeable patterns

1. https://www.ig.com/en/trading-strategies/how-to-trade-bullish-and-bearish-pennants-200428 
2. https://www.dailyfx.com/education/technical-analysis-chart-patterns/pennant-pattern.html 

Disclaimer

The above excerpts are based on my understanding of important mentionings in the book and are not exhaustive.

 

Swaraprastharam- Mayamalawagowlai

 1. Balaji Shankar- Thulasi Dhalamulache

1. rgm

2. pmg, - rgm

3. d,ndpmgrsn- s,rgm

4. ndn- pdmp- gmrg- s,rgm

5. pmpdpm- ndpm- pdpm- ndnpdmp- mdpd- mpgm-gmgp-mdpndpm

6. pdp,- pmpdp,- dpmndpm- pdpm- pdpm- dppmg,,,(Sustains with kampitha at ga) 

gmg, rsn- srgmd, - dpmgrsn- spmd- dppmg,- gmpdnSd,- nSRSn- SSRSn- SGRRSn- SRSn- Snd- RSnd- ndpm- rgm 

(Melsthayi swaras in Caps)

7. nnS-nSn,n,n,-nSd,,,-nnS,SS,S-SR,S,SS,S-SR,S,SS,-SRSRS,,,-nSRSRS,S-ngnSRS,-RRSn-SRSn-SGRRS,n-SRSn-SGRRS,n- SRSn-SRRSn- GRSn-SRSn-RSndd,-RSd,-GRSd,-MGRSd,-nSRRSSn- nSSnS,- GRGSRnS- nnSRnSdn- pSndpmgmrgs,- rsgrmgpmdpndSnRSGRMGGRRSSndppmggrrs 😍

(Will be back with another wonderful Mayamalawagowlai soon)

Takeaways from P.R. Sundar Sir's Podcast

• 1st week of the month has got to give:
• Monthly auto sales data 
• Monthly cement sales data 
• Manufacturing PMI data 
• Services PMI data 
• US Jobs data

•   Put option open interest level = Support level

•   Call option open interest level = resistance level

•  US Interest rate increase = People tend to exit booking profits

•  In US terms, in a bull market
• < 10% fall = normal
• 10% to 20% fall = correction
• >20% = transformation to a bear market

• Manufacturing PMI > 50 = Economy in expansion mode

•  Automobile industry performing not upto the mark because of Semi-conductor shortage (As at Mar, 20)

(Will update ) 

Meme😊

 

Meme😊

 

Takeaways from Motilal Oswal's 25th Wealth Creation Report

 

• Sector-wise analysis

• Based on their studies of the performance of the market for the past 25 years, Motilal Oswal has predicted 25 stocks that could give the best returns in the next 25 years. 

Felt it's worth adding to one's watchlist

• In the former section of the report, the finance company analyzed the past 25 years(1995-2020) performance of securities, to present the top wealth creators. Since the time horizon is longer, I restricted my takeaways to latter section that discusses the time period 2015-2020.

However, few securities have fared significantly well.

1. Havells India (Mainly due to better operational leverage)

2. Vinati Organics (Driven by its USP)

3. Berger Paints, Pidilite, Shree Cement, Honeywell Automation, Motherson Sumi and Sun Pharma.