Search found 4931 matches

by BRIAN5000
17 Nov 2017 20:36
Forum: Under the Mattress: Protecting Your Money
Topic: Best Credit Card (2016-2017)
Replies: 224
Views: 9709

Re: Best Credit Card (2016-2017)

Trip cancellation
Check out the limits on this Capital one only covered $2000 each IIRC.
by BRIAN5000
17 Nov 2017 17:25
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 171
Views: 27552

Re: How to download data?

The lines not returning any info we're not seeing the ticker symbol in column B as a correct symbol. Example NA changed to NA.TO and Bob's your uncle. Looks good will hold 411 stocks and lots of stock data.(columns)
by BRIAN5000
17 Nov 2017 15:48
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 171
Views: 27552

Re: How to download data?

I have quotes downloading now. In the sample worksheet there are spaces between some rows I would like to get rid of the spaces. Is it a simple fix to get rid of the spaces? How do I do it? For example row 8 is blank when I paste ticker symbols into it I want NA info in that row. NA NA -- -- -- -- -...
by BRIAN5000
15 Nov 2017 15:05
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Dividend and distribution cuts (2017)
Replies: 25
Views: 2695

Re: Dividend and distribution cuts (2017)

I don't know much (very little?) about GE's specifics, but I'd want to see 2-4 quarters of improved cash flow, improved balance sheet and the sale of some business lines before dipping a toe in the water. Turnaround stories often take a few years before they show momentum. Not sure why you would po...
by BRIAN5000
14 Nov 2017 16:37
Forum: Financial Planning and Building Portfolios
Topic: Borrowing on margin
Replies: 25
Views: 696

Re: Borrowing on margin

Yeah it was just a counter intuitive statement. What it meant is that they owned a great deal of income producing property and it cash flowed. Yeah I get what was meant still wouldn't be something I'd aspire to. Maybe having revenue property generating a positive cash flow of a few $100,000 a year ...
by BRIAN5000
13 Nov 2017 16:33
Forum: Financial Planning and Building Portfolios
Topic: Borrowing on margin
Replies: 25
Views: 696

Re: Borrowing on margin

Even if you did have enough non-registered money; what will your "level of margin" be after a 30% stock market decline. After you are done with that, check out a 50% decline and think about how well you will sleep at night. Be the same as a 30 or 50% decline in Real estate values. No it won't. You ...
by BRIAN5000
10 Nov 2017 18:26
Forum: Financial News, Policy and Economics
Topic: T plus two business days Starts Sept 5 2017
Replies: 28
Views: 1187

Re: T plus two business days Starts Sept 5 2017

So if brokerages have to settle securities in 2 days and bond transactions in one day why are banks allowed to hold funds for 7 days. It's about time this is moved to two days or less when funds are released especially for meaningless amounts in relation to other holdings at the same institution. :t...
by BRIAN5000
10 Nov 2017 03:08
Forum: Financial Planning and Building Portfolios
Topic: New Investment Tracking Tool
Replies: 26
Views: 777

Re: New Investment Tracking Tool

deaddog wrote:
10 Nov 2017 01:20
I signed up and gave it a

There doesn't seem to be a way to edit a transaction once it is input. I'm a little dyslexic and need to edit quite often.
I was Able to edit the date on my Bmo transaction didn't try anything else, will try in am.
by BRIAN5000
09 Nov 2017 19:43
Forum: Financial Planning and Building Portfolios
Topic: Borrowing on margin
Replies: 25
Views: 696

Re: Borrowing on margin

Even if you did have enough non-registered money; what will your "level of margin" be after a 30% stock market decline. After you are done with that, check out a 50% decline and think about how well you will sleep at night.
Be the same as a 3 or 50% decline in Real estate values.
by BRIAN5000
09 Nov 2017 17:13
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 171
Views: 27552

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. Quicken doesn't have any of my priority algorithms or show stocks that are buys or sells or close to it and ...
by BRIAN5000
09 Nov 2017 12:45
Forum: Financial Planning and Building Portfolios
Topic: New Investment Tracking Tool
Replies: 26
Views: 777

Re: New Investment Tracking Tool

Can I enter a buy at a past date and have the dividend payouts input into the portfolio? Looks like it does to me using a simple single security as a test. 2016-02-26 2016-01-28 2016-02-01 BMO.XTSE OrdinaryDividend Quarterly CAD CA$0.84 500 CA$420.00 2016-05-26 2016-04-28 2016-05-02 BMO.XTSE Ordina...
by BRIAN5000
08 Nov 2017 18:03
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: How to download data?
Replies: 171
Views: 27552

Re: How to download data?

So does the Yahoo portfolio kluge give up-to-date data? (I use the Yahoo .csv download from My Portfolio and import it into 1-2-3, then use lookup functions.) I've come up with a bogus work around for myself takes 20-30 seconds not as easy as pushing a button as before. Data from Yahoo is delayed y...
by BRIAN5000
08 Nov 2017 02:18
Forum: Financial Planning and Building Portfolios
Topic: New Investment Tracking Tool
Replies: 26
Views: 777

Re: New Investment Tracking Tool

Says you can have multiple portfolios will it aggregate all the multiple portfolios into one?
Can I have US and Can currencies in two different portfolios?
by BRIAN5000
07 Nov 2017 16:20
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: What did you sell? What might you sell? (2017)
Replies: 159
Views: 15964

Re: What did you sell? What might you sell? (2017)

Thinking of reducing equity not sure what to get rid of, I have a couple of traders I may dump but I'm also considering Bombardier. Down a couple of grand will this pig ever fly? Or I could sell some winners.
by BRIAN5000
06 Nov 2017 18:16
Forum: Financial Planning and Building Portfolios
Topic: Strip bonds or Bond ETF
Replies: 16
Views: 506

Re: Strip bonds or Bond ETF

We don't use HBB but we do have access to one tax efficient bond solution that we continue to use (though it's a corporate class structure not a synthetic fund/ETF). Yeah that was the other option I was looking for last night couldn't find anything other than First Trusts short term, Mer at @ .25 (...
by BRIAN5000
06 Nov 2017 16:46
Forum: Financial Planning and Building Portfolios
Topic: Passing on a DIY portfolio after death
Replies: 35
Views: 1142

Re: Passing on a DIY portfolio after death

If you use multiple institutions for GIC investments all CDIC insured you lose 2/3 of your possible coverage upon one spouse's death!

Anyone make any allowances for this?
by BRIAN5000
05 Nov 2017 23:51
Forum: Financial Planning and Building Portfolios
Topic: Strip bonds or Bond ETF
Replies: 16
Views: 506

Re: Strip bonds or Bond ETF

I don't know. When I added bonds to my portfolio, people were having the same worries about tax efficiency, interest rates, and the unpredictability of bond funds/ETFs. Yet, since January 2014, when I added it, VAB has provided an annualized 3.9% total return. Not bad for such a "worrisome investme...
by BRIAN5000
03 Nov 2017 22:25
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: What did you Buy? What might you buy? (2017)
Replies: 500
Views: 47893

Re: What did you Buy? What might you buy? (2017)

Shakespeare wrote:
03 Nov 2017 22:16
Used excess cash in my TFSA to expand the ENB in the TFSA from 50 to 100. Last of the big-time spenders. :wink:
I too threw caution to the wind and bought 100 ENB for wifies open account, as a port total we now own 984 shares.
by BRIAN5000
01 Nov 2017 20:54
Forum: Retirement, Pensions and Peace of Mind
Topic: Annuity
Replies: 18
Views: 808

Re: Annuity

Management used to say the everyday workers were their greatest asset until they started saying they were their biggest expense, humf.
by BRIAN5000
20 Oct 2017 18:37
Forum: Financial Planning and Building Portfolios
Topic: Gifting to Grandchildren
Replies: 7
Views: 401

Re: Gifting to Grandchildren

TDDI refuses to accept from even a spouse then it took over a month to get the money back between TDDI & BNS.
Why wouldn't you just sell it take the loss, give her the money to put in her TFSA and if she really thinks CPG is now a good stock she could buy it.
by BRIAN5000
18 Oct 2017 13:33
Forum: Taxing Situations
Topic: Investment income in a CCPC
Replies: 854
Views: 72502

Re: Investment income in a CCPC

or retirement;
Why are these selected few allowed to save for retirement this way? Why are they not restricted to the 18% like the rest of us working stiffs?

Is because it can't be measured or quantified?
by BRIAN5000
13 Oct 2017 19:23
Forum: Retirement, Pensions and Peace of Mind
Topic: Severance Question
Replies: 8
Views: 532

Re: Severance Question

First time I heard about something like this was last night just before poker guy's wife was in same situation but I didn't ask for clarification. Two years pay as long as she doesn't get a new job. :shock:
by BRIAN5000
12 Oct 2017 14:56
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Power of Dividend Growth 2011 (and beyond)
Replies: 731
Views: 52432

Re: Power of Dividend Growth 2011 (and beyond)

Thus whether equity is 30%, 60% or 100% of one's portfolio, I still don't see why one would necessarily change the number of holdings in their equity allocation. Not what I'm saying surely you must understand that. Three all Canadian portfolios all shown using the same conventions, I think. Top 24 ...
by BRIAN5000
11 Oct 2017 12:19
Forum: Financial Planning and Building Portfolios
Topic: Outstanding Financial Pornography
Replies: 624
Views: 108459

Re: Outstanding Financial Pornography

A BETTER WAY TO BORROW, A SMARTER WAY TO LEND

Bringing Canadians and Businesses Together

https://www.lendingloop.ca/rates-and-fees

They take from 2.5 to 6.5% up front and 1.5% on the way back in, yowser.
by BRIAN5000
11 Oct 2017 12:08
Forum: Stocks, Bonds, ETFs, Funds, REITS and More
Topic: Power of Dividend Growth 2011 (and beyond)
Replies: 731
Views: 52432

Re: Power of Dividend Growth 2011 (and beyond)

Well I think the amount of RY is relevant, I'd like to know if they are just tracking the TSX or not with "some" of their weightings, I see they are about 36% financial. Brian, MAW104 is made up of 7 different mutual funds, only one of them which is Canadian equity (currently 14.5%). The amount of ...