Capitalise the alphabet
kevin cookie company
=proper (col_name)
Kevin Cookie CompanyTrim
Kevin Cookie Company
=trim(col_name)
Kevin Cookie CompanyConcat
=concat(A10, " ", B10)
Kevin Cookie Vs KevinCookieText Join
=textjoin(" ", TRUE, A18:C18), format: delimiter,ignore empty col? Yes, Col range)Extract Company Address
123 Main Street, 05486
=right(A22, 5)
result:05486Extract word before "@" ，精准extract“@” 之前的字
[email protected]
left(A28, find("@", A28)-1)
result: kevin
[email protected]
result: sue
7.Nested if
=IF(M30=P30,N30,IF(M31=P30,N31,"unknown"))
OR xlookup function (more easier and straight forward)
Stock Market Reflection
On 31st Jan 2025:
Natgate was oversold, 1.72, I was thinking to purchase the stock at a lower price without realising the fact that it is actually undervalue. Despite 2 days of sideway trading, I still stick with my plan.
Lesson learnt: Should purchase once it is undervalue, getting a small exposure will be nice enough
Hst: It is a bit dangerous to sell of a quarter of the stock given that the long run of share is going to be optimistic.
No Lesson learnt and no solution
Ytl Power: It is so fortunate that I able to secure a low price of the stock at 2.955. No idea when to sell off (Should plan one) given the fact that the demand for computing power won't lower just like the demand for electricity.
Takaful since 25th Nov to 25th Jan, It was a mistake for not profit taking at its highest pricing level, at 4.12? Even though I missed out the highest price, yet I missed out the second ideal timing, at 3.90. This is a sideway stock which have to do profit taking in appropriate timing.
---