Author: Rainbow Coin

Thought processes & problem solving

I finally discovered how to utilise pivot tables for data analysis. It looks cheem to me when I first looked it up (I only know pie charts and line graphs for the sake of presentations), until I discovered the ‘woah’ moment with trial-and-error and things suddenly fall into place like magic. Not without some data chewing that was quite frustrating initially as I have 800+ lines of data with assorted information such as timing, category etc. — When it comes to problem solving, many times we tend to fall into the trap of focusing on ‘What I can do?’...

Read More

Insights from interviewing candidates

Being the sai kang Ops Manager, my new add-on duty currently is to hire for a HR generalist position for the SME I am working at (before I get a new add-on duty of HR manager too). Here are some interesting takeaways from the interviews I have conducted. 1) Those who don’t know how to give ‘model answers’ for the standard questions asked, I know they have little or no experience in interviewing and recruiting people, as well as being interviewed. “What do you know about our company xxx?” *stumped* “Thank you, exit is over there.” 2) “What makes you...

Read More

Unattractive Lunar New Year bank promo

Till end Feb… The only low-hanging fruit promo that I could find is the DBS $28 Hong Bao giveaway for opening a new deposit account or SAYE account online. T&C applies. So I have gotten myself a Multiplier Account. POSB is offering 1.45% for 4 months if you open a higher interest account with fresh fund deposit. Last year was 8 months. Standard Chartered is offering a miserly 1.15% for 11 months FD tenor with minimum deposit of 25k. (If I didn’t recall wrongly, new year period was 1.25%.) https://www.sc.com/sg/save/term-deposit-sgd-dollar.html CIMB is offering 1.25% for a 12 months FD tenor...

Read More

Sequel to CAGR, XIRR simplified

A sequel to my previous post. Can I make use of XIRR’s value to help in my investment portfolio goal setting? Think come, think go… cannot leh. :( WHY? Because XIRR % is like a report card grade which shows how my portfolio has performed over a fixed period of time, say last year. However, it is not practical to set a goal based on the % or confer a meaning to it as the current market value of my portfolio is controlled by Mr Market (although you may argue investment timing matters *cough cough*). So on sunny days, XIRR...

Read More

CAGR, XIRR simplified

Inspired by SMOL’s post, I decided to do some reading and a short post on these “cheem cheem” terms that previously I do not use. CAGR stands for Compound Annual Growth Rate. It is useful in measuring (in %) how much an investment has increased in value over a fixed period of time. Watch the illustration in this video here – http://www.investopedia.com/calculator/cagr.aspx  So if your investment grew from $1000 to $1500 over a period of 3 years, the CAGR is 14.5%. Which means the amount increased by 14.5% on its compounded value each year, as follow Year 1: $1000+14.5% Year 2: Year 1...

Read More

Time to contribute $$ to CPF for tax relief again

It’s the time of the year again – time to contribute money to your CPF or your parents’ CPF accounts if you are looking for some income tax rebate. Better do it soon too, because there are less than 5 working days to new year (and to qualify)! Another way of getting the tax rebate is to do some good by donating back to society. :) Here is the IRAS link to check out the top-up relief...

Read More

Past tense, Present tense, Future tense of stock market

Past tense = dividends, P/E Present tense = current share price, news Future tense = prospect / business analysis, projected earning, speculation Some people like to make decision looking at the rearview mirror, some people like to make decision based on trend and gut feel, some people like to analyse and try to foresee things. Which describes you? ————————- My stocks portfolio adventure in 2016: – Earned an ok dividend of 4.3% by year end – My worst paper loss this year was -29% in January – Rode through the boring market period and terrible paper loss by not...

Read More

Stay-at-home long weekend… to shop

Who says 宅女 don’t go shopping? From the rise of ebay, blog shops to Alibaba, we could practically find anything we want online and have it delivered to our house – at times at a better price. Qoo10 is having some cool deals of cart coupon offer here. $3 off $20 min purchase, $10 off $50 and $30 off $200. I usually shop for clothings, PC and handphone accessories. Because of these great deals, I decided to get something more adventurous – a robot vacuum cleaner. For only $82 after the coupon discount! :) My mom doesn’t like to clean the floor, neither...

Read More

Savings account promotions

POSB is currently running a ‘Get 1.55% p.a. interest for 6 months!’ promotion. Check it out here. How to get the deal? Deposit fresh funds* into your POSB Fresh Funds Account by 4 August 2016. Fresh funds deposit via cheque(s), cashier’s order(s) and demand draft(s) must be done by 4 August 2016, 3.30pm. During the POSB Fresh Funds Account opening process, you will be prompted to select an existing POSB/DBS Current or Savings Account to be used for signature reference. This same account will be used for the crediting of the Cash Gift Interest. This account has no applicable...

Read More

Stocks app review – Call Levels

There are many Android apps which monitor stock prices and show stock charts but I could hardly find one that gives you Price Alert feature. Call levels (I came to know about it from a DBS Vickers ad) is a mobile app that would alert you when any stocks you chose hits a certain price. It has a simple and clean interface that shows you nothing else on screen but the price of the stocks that you are following. Upon reaching your keyed in price, it will automatically alert you via mobile notifcation. You could also choose to receive...

Read More

My thoughts on rights issuance

Rights issue = an issue of shares offered at a special price by a company to its existing shareholders in proportion to their holding of old shares. When I think of rights, I think of share dilution. More shares at cheap price for existing shareholders, some would scurry to sell off once they get hold of the rights share before the full dilution takes effect. Not all rights are right to get. However, if you decided not to get then you might be better off selling away the shares instead of holding them (before full dilution takes place as mentioned)....

Read More

Trendline drawing is fun!

Decided to do some trendline drawing practice out of boredom. Just a few stocks I was watching. Pictures paint a thousand words? (Hack care about macd, stoch, rsi and what not… just kidding) Keppel Can’t seem to break out of its downtrend channel. Secondary uptrend occurred since my previous update but uptrend broken once ex-dividend. :(  Lippomall Going sideway soon?  Noble...

Read More

Back to school – SGX academy

Yoz! Am back from Taiwan. Since now I am so free and officially a slacker, I thought I would sign up for course or two at SGX academy. Good to be student again once in a while. My advise for this is don’t attend FOC preview courses, because most of the time you will be listening to just-some-ideas and much self-selling (to make you attend the actual course). For better learning experience and not waste time, go for the paid courses that suit your level. The recent course I went for is on technical trend trading for beginners (3...

Read More

Recent reads: The Next Apple, Bull’s Eye Investing

The Next Apple I find that the strategy that the authors advocate is applicable only in the start of a bull run or in good market times (stable economy) because it’s main tactic is to pick stock when it keeps climbing and goes past its 52-week high with at least 50% break out from a technical base. More of a technical read than fundamental. Teaching us how to ride on momentum stocks. However, it contradicts itself by saying you should buy stocks that fulfilled the momentum criteria when not many people of the public know about the stocks yet...

Read More

Use Skillsfuture Credit to up your financial literacy

In view of the Skillsfuture Credit kicking into effect from this year, SG citizens age 25 and above are given $500 to kickstart learning. Since it’s free lunch given by ‘ah gong’ (sg government), why not? BUT before you excitedly start signing for courses around, you might want to first find out what courses are eligible for the $500 subsidy. Check out the list here http://www.skillsfuture.sg/credit. What courses can help you improve on financial literacy or understand investing better? Check them out here: https://portal.wda.gov.sg/content/wda/course-search-directory.html?CourseTitle=finance https://portal.wda.gov.sg/content/wda/course-search-directory.html?CourseTitle=invest SIM modular courses: http://www.unisim.edu.sg/CET/Documents/SkillsFuture%20Courses%202015.pdf You could also check out SGX Academy for more investment courses...

Read More

Like us on Facebook

Follow us on Twitter