Outline ·
[ Standard ] ·
Linear+
STOCK MARKET DISCUSSION V130, Bull rally after GE
|
SUSPink Spider
|
 May 17 2013, 01:59 PM
|
|
QUOTE(bursalchemy @ May 17 2013, 01:55 PM) I consistently do it for 3 yrs ady. I dont know hw to do it on spreadsheet. Previously i tried to use my iphone apps to monitor my income n expenses. But i dont like it at last. I still prefer do it manually. Let say i do it on spreadsheet, is there a way the excel will consol all my assets n liabilities on a balance sheet? So tht i could have clearer picture of my current finl position. U never attended Excel workshop/training?  I have separate worksheets for each significant class of asset: (1) FDs (2) Unit trusts (3) Stocks And a working worksheet where I record my bank balances, credit card balances etc. Then all will be linked to a master summary balance sheet, where all are laid down. Assets - Liabilities = Net Worth And I track my net worth growth over time, growth rate is also calculated. |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:00 PM
|
|
|
QUOTE(panasonic88 @ May 17 2013, 01:56 PM) I was impressed by the way Chong did the balance sheet, handwrittenly, only.When u are doing an accountancy course like ACCA, u can too. Thinking back on those days makes me  |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:03 PM
|
|
|
QUOTE(bursalchemy @ May 17 2013, 02:01 PM) Can u send me the file? Hehe, u can delete all yr sensitive info. I jz wan to have a rough guidance on hw it can be done WTF so many things to delete nia Please bank in money for a large botol Guinness Stout to my akaun first, to compensate me for the headache  |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:05 PM
|
|
|
Basically u just do all your records in Excel, and link to sum total of each record to a master balance sheet. Just trial and error til u find a format that u like  |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:10 PM
|
|
|
QUOTE(SKY 1809 @ May 17 2013, 02:08 PM) U got any spreadsheets for auto analyzing stocks for investments I only use to track my IRR and Profit/Loss. Analyse...I'm not that anal  I just do very basic analysis, analyse 5 year revenue growth, profit growth, profit margins, dividend payout ratio, dividend yield etc. Simple stuff only. |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:18 PM
|
|
|
QUOTE(SKY 1809 @ May 17 2013, 02:12 PM) No cashflow analysis FCF things Cash flow, I just glance thru its Cash Flow Statements and cash position in the balance sheet, no thorough analysis on that. QUOTE(panasonic88 @ May 17 2013, 02:15 PM) 6432 homework sudah buat? Your plate of waffle or not? Sifu Warren Buffett say invest in things u understand. I see supermarkets and kedai runcit, bukannya banyak orang beli Ah-Paul-Lo products...so profitable meh? |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:33 PM
|
|
|
QUOTE(yhtan @ May 17 2013, 02:31 PM) 99% u are accountant Akauntan Tak Berlesen, to be precise This post has been edited by Pink Spider: May 17 2013, 02:34 PM |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:35 PM
|
|
|
QUOTE(SKY 1809 @ May 17 2013, 02:34 PM) Accountants also hve 24 hours a day, no more or less than others. Opportunity costs on your time managements too. How well u keep does not always tally on how good the returns are. Sori for saying that  Agree. Akauntans are to make sure that management don't go too far wrong, our job is to raise red flags before it's too late, it's never our job to make money. My record-keeping is more or less automated already.  This post has been edited by Pink Spider: May 17 2013, 02:38 PM |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:36 PM
|
|
|
QUOTE(panasonic88 @ May 17 2013, 02:32 PM) Honestly I am not a baked cake fans either. The waffle cake targets children market. School canteens are the places you'll find'em. In fact their export market are doing better than local market. Revenue, gross profit & gross profit margin are growing. Healthy cash flow, good dividends are the reason I buy it. Cheaper than competitor Hupseng in terms of PE. Ping Pong biskut is starting to get expensive. Luckily I bought in early. Starting to attract the attention of yield seekers? Yes, during my schooldays, I eat their waffles/cakes almost every day  This post has been edited by Pink Spider: May 17 2013, 02:37 PM |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:41 PM
|
|
|
QUOTE(SKY 1809 @ May 17 2013, 02:39 PM) Sori, I talk of keeping personal investment records, not the records of the co u work with. Sama lar...personal finances/budgeting red flag I was referring to just now Accounts are backward-looking. So that when I see "eh, my investments not performing", then its time to re-evaluate This post has been edited by Pink Spider: May 17 2013, 02:42 PM |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 02:56 PM
|
|
|
FIXED ASSETS is old term, nothing is "fixed" nowadays |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 03:04 PM
|
|
|
QUOTE(foofoosasa @ May 17 2013, 03:01 PM) Some of my father's friend nothing to do after retirement, everyday stay in Broker house to trade, earn few hundred or the other way round everyday. Like a mini casino broker house no free meal and pretty casino croupier to cuci mata on |
|
|
|
|
|
SUSPink Spider
|
May 17 2013, 06:04 PM
|
|
|
QUOTE(bursalchemy @ May 17 2013, 05:40 PM) I do not have finance stock in my portfolio. As most of them are so expensive. Should i buy board lot on finance stock first or wait another financial crisis? Affin mana ada expensive. |
|
|
|
|
|
SUSPink Spider
|
May 20 2013, 02:43 PM
|
|
|
QUOTE(gark @ May 20 2013, 01:00 PM) For plantation you need to see the locations as well, some location is much more fertile and FFB yield + OER can have 20%-30% differences. Most fertile locations. 1. West Semenanjung - Perak/Selangor 2. Sabah - East Coast (Tawau, Kunak, Lahad Datu) 3. Kalimantan - South/East Kalimanatan 4. Sumatera Utara (Central + East) 5. Riau (Eastern near Dumai) 6. Palembang (Southern incl. Bangka Island) In fact Indonesia is generally approx 10-20% more fertile than Malaysia... U working in plantation sector? Else how cum u know all that detailed technical stuff |
|
|
|
|
|
SUSPink Spider
|
May 21 2013, 10:31 AM
|
|
|
Panasonic jie jie, Pinky sudah masuk waffle stock  This post has been edited by Pink Spider: May 21 2013, 10:31 AM |
|
|
|
|
|
SUSPink Spider
|
May 21 2013, 10:38 AM
|
|
|
QUOTE(panasonic88 @ May 21 2013, 10:36 AM) So it was you! No wonder it moved. Lucky pinky! You bring luck to this stock  4.18 only got 2 lots, no choice I had to pick 'em up and then sapu a few more lots at 4.20  Now another shopping list, rokok Mild Seven or susu wanita Holland 2 days in a row TOPGLOV kena selldown, my URP from 20% dropped to 10%  Insider news? |
|
|
|
|
|
SUSPink Spider
|
May 21 2013, 10:43 AM
|
|
|
QUOTE(panasonic88 @ May 21 2013, 10:40 AM) Mild 7 is JTI right? Got one senior told me, when you can't decide, TAKE BOTH. "senior"...u work in audit/tax? Yeah JTI u ingat I got a bottomless war chest meh This post has been edited by Pink Spider: May 21 2013, 10:44 AM |
|
|
|
|
|
SUSPink Spider
|
May 21 2013, 10:47 AM
|
|
|
QUOTE(panasonic88 @ May 21 2013, 10:46 AM) One year one month from now We have FIFA World Cup 2014 World Cup theme usually linked to Beers, Mamak  No wonder Cows Berk has been moving up steadily |
|
|
|
|
|
SUSPink Spider
|
May 21 2013, 10:52 AM
|
|
|
Ping Pong crackers' crazy rally continues |
|
|
|
|
|
SUSPink Spider
|
May 22 2013, 09:21 AM
|
|
|
QUOTE(panasonic88 @ May 22 2013, 08:59 AM) lol what did I read, Prisons reits? Pana jie jie Last nite I did an analysis of their fundamentals, I think Ping Pong biskut is cheaper valued compared to Waffle in terms of DY, but P/E-wise Waffle cheaper. Ping Pong has been very generous with their dividend payout for the past few years. |
|
|
|
|
Quote
0.0253sec
0.43
7 queries
GZIP Disabled