Search found 886 matches

by Insomniac
09 Nov 2017 16:53
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 171
Views: 27565

Re: How to download data?

WADR, consider buying an annual $90 subscription to Quicken and spend your valuable time elsewhere. It has served me well for over 20 years. I've never quite understood 'make work' projects. Many of us enjoy DIY. It's educational and good exercise for the brain. Good thing to do on a day in the cra...
by Insomniac
09 Nov 2017 00:22
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 171
Views: 27565

Re: How to download data?

Here is a link to an (adapted) spreadsheet (Google sheet) I use to track my portfolio daily changes https://docs.google.com/spreadsheets/d/1R-NEuA0EU8VRbWb5Zyn-awZ7vpx3afrKer8eifTIqXY/edit?usp=sharing Just select make a copy (You will need to be logged into a google account to do this) under file t...
by Insomniac
19 Oct 2017 00:07
Forum: Financial News, Policy and Economics
Topic: NAFTA is dead. So now what?
Replies: 19
Views: 891

Re: NAFTA is dead. So now what?

RIP NAFTA. Go TPP w/o USA!
by Insomniac
13 Oct 2017 00:21
Forum: Under the Mattress: Protecting Your Money
Topic: Wire Transfer - RBC to Van City
Replies: 6
Views: 155

Re: Wire Transfer - RBC to Van City

I'm a member of a BC credit union. The account number is 12 digits, but you can simply ignore the first 4 numbers if you only have room for 8. For those who are interested: The institution number "809" is used by Coast Capital as well as VanCity. "809" is for BC Central. http://canada-banks-info.com...
by Insomniac
12 Jan 2017 15:29
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Preferreds
Replies: 1137
Views: 81624

Re: Preferreds

[quote="ockham" I stand to be corrected but doubt Insomniac ever did any serious work with regards to prefs. IIRC he bought ETFs, lost money, bailed near the lows and decided this asset class wasn't for him. Yes, I bailed on ZPR almost 2 years ago and it dropped another ~25% after that. At the time...
by Insomniac
11 Jan 2017 02:17
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Preferreds
Replies: 1137
Views: 81624

Re: Preferreds

I agree ETFs are the best choice for most investors in the pref space. I'd suggest investors really do not need prefs in their portfolios. The more I look at it, knowing what I know now, I'd probably skip them entirely. I've experimented, gotten bruised here and there, and will not add to my holdin...
by Insomniac
29 Dec 2016 23:57
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: 2016 hedge fund contest
Replies: 53
Views: 2892

Re: 2016 hedge fund contest

Apparently, you can get historical data from Yahoo: For historical data you can use something like: //*http://ichart.finance.yahoo.com/table.csv?s=WU&a=11&b=15&c=2016&d=11&e=19&f=2016&g=d&ignore=.csv*// where the FROM date is: &a=11&b=15&c=2016 and the TO date is: &d=11&e=19&f=2016 Be careful, field...
by Insomniac
29 Dec 2016 17:33
Forum: Financial Planning and Building Portfolios
Topic: What Investment Measurement is Important to You?
Replies: 72
Views: 2991

Re: What Investment Measurement is Important to You?

I look at total portfolio value (registered accounts + non-registered accounts + GICs + cash), estimated income and asset allocation. Look at estimated income for tax planning purposes. Check asset allocation to see if it's getting out of wack and needs to be adjusted. Look at total portfolio value ...
by Insomniac
26 Dec 2016 23:32
Forum: Retirement, Pensions and Peace of Mind
Topic: RIF RETURNS FOR 2016
Replies: 46
Views: 1676

Re: RIF RETURNS FOR 2016

I agree posting YTD numbers is only for bragging purposes.

e.g. You could brag that the Canadian market is up over 18% YTD. However, today XIC is at $24.41 which is still below the $24.79 it reached on Aug 29, 2014. So, not really much to brag about.
by Insomniac
22 Dec 2016 16:26
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Shaw Communications (Symbol-SJR.B)
Replies: 119
Views: 9287

Re: Shaw Communications (Symbol-SJR.B)

they have us over barrel with no alternative high speed service available here. Not sure where you are located, but many places in Canada should see some level of competition starting next year. The CRTC has ordered the incumbents to allow new entrants to use the incumbents' networks to reach custo...
by Insomniac
21 Dec 2016 18:06
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: 2016 Lessons Learned
Replies: 45
Views: 2114

Re: 2016 Lessons Learned

I didn't do anything with my portfolio this year; just let it ride. No regrets. IMO, we had 2 significant events this year which could have wreaked havoc with my portfolio; Brexit and the election of Trump as POTUS. The portfolio dipped after Brexit, but recovered fairly quickly. After Trump's elect...
by Insomniac
17 Dec 2016 15:27
Forum: Taxing Situations
Topic: Looking for a Service to handle estate returns
Replies: 12
Views: 548

Re: Looking for a Service to handle estate returns

Yes, we had 6 beneficiaries, evenly split. There was a initial payment and a final payment. $50K was withheld from the initial payment for possible taxes due, executors fees, accountant fees, etc. Final payment was made after clearance certificate was obtained.
by Insomniac
15 Dec 2016 23:45
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Marijuana Legalization [Investment opportunities]
Replies: 45
Views: 1879

Re: Marijuana Legalization

A stock that might prosper from legalization:
Cannabix Technologies Inc. (CSE: BLO, US OTC: BLOZF, Frankfurt: 8CT:FRA) is a Vancouver, B.C. based technology company.
http://www.cannabixtechnologies.com/
by Insomniac
13 Dec 2016 23:29
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Canadian Equity ETFs
Replies: 17
Views: 1435

Re: Canadian Equity ETFs

Dang. I was lazy and used Bloomberg's site to get the expense ratios. https://www.bloomberg.com/quote/XIC:CN

Looks like Bloomberg reported the rest of them OK, so the 0.55% I calculated should be good.
by Insomniac
13 Dec 2016 20:05
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Canadian Equity ETFs
Replies: 17
Views: 1435

Re: Canadian Equity ETFs

I don't have a problem with someone serving up investment advice on a webpage, blog, newsletter or whatever. There's seems to be lots of people doing it. We are free to decide if we think the ideas are good or bad. I'm not offended that AI uses this forum to promote his webpage. If the promotion bec...
by Insomniac
07 Dec 2016 14:03
Forum: Retirement, Pensions and Peace of Mind
Topic: Final Document Service
Replies: 32
Views: 1589

Re: Final Document Service

The Public Guardian and Trustee (PGT) can administer an estate when the executor, intestate successor, beneficiary or other eligible person is not able or willing to do so.
http://www.trustee.bc.ca/services/estat ... ation.aspx
by Insomniac
06 Dec 2016 13:50
Forum: Taxing Situations
Topic: An ACB question
Replies: 5
Views: 528

Re: An ACB question

This article in the finiki explains the proper way to calculate ACB.

http://www.finiki.org/wiki/Adjusted_cost_base_(ACB)
by Insomniac
05 Dec 2016 18:37
Forum: Retirement, Pensions and Peace of Mind
Topic: Final Document Service
Replies: 32
Views: 1589

Re: Final Document Service

Insurance exclusively for final expenses and the funding of prearranged funerals
http://www.purpleshield.ca/

Click "about us"
by Insomniac
05 Dec 2016 14:24
Forum: Financial News, Policy and Economics
Topic: Has your Investment Policy Changed After the US Election
Replies: 88
Views: 5150

Re: Trump Investing.

I answered the question in this thread:
viewtopic.php?f=31&t=119673

Merged topics
ModeratorW
by Insomniac
03 Dec 2016 19:14
Forum: Financial Planning and Building Portfolios
Topic: When odds are in your favour
Replies: 71
Views: 3139

Re: When odds are in your favour

My passive strategy is showing. Gambling is boring, so I buy the index.
by Insomniac
03 Dec 2016 18:57
Forum: Financial Planning and Building Portfolios
Topic: When odds are in your favour
Replies: 71
Views: 3139

Re: When odds are in your favour

Started playing and did OK. Got up to $175 and looked at the clock. Crap! Only 3 minutes gone! This is boring! I am not doing this for 30 minutes. So, I bet the lot and lost it all. :lol: Why do they allow you to bet "tails" when the odds are stacked in favour of "heads"? :? I don't understand gambl...
by Insomniac
01 Dec 2016 19:19
Forum: Under the Mattress: Protecting Your Money
Topic: Consumer Gullibility
Replies: 63
Views: 5151

Re: Consumer Gullibility

My new Yamaha receiver came with a little microphone too. Same thing: put the mike in the middle of the room and it tunes the speakers for you automatically. I think you mentioned that you have a Harmony remote. I am really annoyed. I went to the myharmonyremote website to change the programming on ...
by Insomniac
01 Dec 2016 00:19
Forum: Property: Owning, Renting, Managing, Investing and Mortgaging
Topic: Omitting the finance (and all other conditions)
Replies: 8
Views: 619

Re: Omitting the finance (and all other conditions)

I think you already answered your own question. I would never put in an offer without "subject to financing" and "subject to home inspection". You have to be firm with realtors. Remind them they are working for you. Getting approval at your bank or credit union for the mortgage before you go shoppin...
by Insomniac
22 Nov 2016 13:06
Forum: Property: Owning, Renting, Managing, Investing and Mortgaging
Topic: Housing Bust 2016
Replies: 641
Views: 30243

Re: Housing Bust 2016

If in 1960, you had put $40,000 in a portfolio of 50% bonds and 50% TSX composite, you would have about $4.3 million now.
(try it out using Stingy Investor Asset Mixer)

Of course you can't live in a portfolio.