Intelligent Money - your investment questions answered

[JulianPH]

Kingdom35 said:

Just wanted to check in and say. For all the ups and downs, bumpy roads etc. This venture with IM has been very interesting and a very good learning curve.

I’m wondering if IM have any kind of Income fund in the pipeline, my Dad currently has 50k sat in a Pru Income Fund that he earns 5% off. I’ve wanted to get him to move across to IM for over a year now.

I was hoping at one of the motorsports events last year I could have had some support from Julian to persuade him even more haha

Hi Kingdom35

Thanks for your kind words.

Your Dad is very welcome to join you with us at the races this year (it looks like they will be open) and we can chat over things with him.

The 5% annual withdrawal from his Pru fund sounds to be part of the original capital return rules (5% a year over 20 years is classed as a return of the original investment and is therefore tax free), rather than actual income/growth returns on the investment.

We won't try and persuade him do do anything, just explain his options in plain English. It may be the case that he is better where he is, it may not be. Either way we can give him all the information and guidancehe he needs to make his own informed decisions.

And we can watch some racing and take him round the garages and the grid lane!

Cheers

Julian

[paralla]

JulianPH said:

Send Coops and email ([e-mail]) and he will have it added for you.

Welcome to Private Clients and just let us know if there is anything we can do for you.

Cheers

Julian

Thanks Julian 🙏

[JulianPH]

CAPP0 said:

This has probably been asked before (and quite possibly by me ) but are the target prices for PHR known to us all or is that top secret/NTK info?

I use the extremely helpful Google Sheets tracker to keep an eye on where the PHR holdings are, and where they are compared to my (late) buy price. There are a couple which (selfishly!) I wouldn't want sold any time soon!

Top secret mate, just me, Apollo and Mowgli know this, though I might have left a list in the glove box of the Aston.



Yes, I'll post them over the weekend!

[CAPP0]

JulianPH said:

CAPP0 said:

This has probably been asked before (and quite possibly by me ) but are the target prices for PHR known to us all or is that top secret/NTK info?

I use the extremely helpful Google Sheets tracker to keep an eye on where the PHR holdings are, and where they are compared to my (late) buy price. There are a couple which (selfishly!) I wouldn't want sold any time soon!

I might have left a list in the glove box of the Aston.

No, not there - as you probably recall, a piece of A4 folded in half is far too big and too thick to fit in the glove box of a DB9!

JulianPH said:

Yes, I'll post them over the weekend!

Thanks!

[Phooey]

JulianPH said:

Hi mate

• Delta was sold at £33.65, so approximately. $46.74 which is 73% up of the base price of $27.01

• Norwegian was sold at £23.26, so approximately $32.30 which is 111.5% up on base price of $15.27

Not a bad 8 months there! Everyone will get an email early next week as the cash comes through. Both have fallen quite hard today (Delta c. 4% and Norwegian c. 12%). I am sure they will recover, but we got out before this and our work here is done!

Have a great weekend!

Cheers

Julian

Thanks mate - much appreciated



On a separate (concerning) note - whats your thoughts on Joe Biden fking the big tech companies - Amazon, Apple etc.

Today:

“ Tim Wu, a prominent critic of Big Tech companies, is joining the White House as an adviser on competition policy, sending a clear message to Silicon Valley that Joe Biden hopes to tame America’s most valuable companies.”

“ Wu has described the wealth and power of Big Tech companies — particularly Facebook, Google and Amazon — as creating a “new gilded age” akin to the late-19th and early 20th-century era of US railroad-building and “robber barons”. He has said that his “life mission” is to “fight bullies”. ”

[Insurancejon]

don't suppose we also sold ccl as well as norwegian and delta?.....wishfull thinking i realise....but thought I'd check

[Phooey]

Insurancejon said:

don't suppose we also sold ccl as well as norwegian and delta?.....wishfull thinking i realise....but thought I'd check

Hope we didn’t, looking forward to throwing some more ££ into PHR next week if Carnival is still on Sale

[Simpo Two]

Phooey said:

On a separate (concerning) note - whats your thoughts on Joe Biden fking the big tech companies - Amazon, Apple etc.

Today:

“ Tim Wu, a prominent critic of Big Tech companies, is joining the White House as an adviser on competition policy, sending a clear message to Silicon Valley that Joe Biden hopes to tame America’s most valuable companies.”

“ Wu has described the wealth and power of Big Tech companies — particularly Facebook, Google and Amazon — as creating a “new gilded age” akin to the late-19th and early 20th-century era of US railroad-building and “robber barons”. He has said that his “life mission” is to “fight bullies”. ”

As investors it's up to us to jump from one opportunity to another. If the next profit is in tofu windmills, we invest in tofu windmills.

Where would the US be without its railways and industrial tycoons? Not where it is today.

[Burwood]

Facebook is a miscreant company. A scourge and will be broken up IMO. google has issues. Apple is not at risk notwithstanding its App policy. Amazon is facing competition so no reason to anti trust them.they are all ruthless and balance the law, ethics and what they can get away with. I think Facebook operate like organised crime. Insidious. It’s what you get with a company that is bigger than some countries.

[Kingdom35]

JulianPH said:

Kingdom35 said:

Just wanted to check in and say. For all the ups and downs, bumpy roads etc. This venture with IM has been very interesting and a very good learning curve.

I’m wondering if IM have any kind of Income fund in the pipeline, my Dad currently has 50k sat in a Pru Income Fund that he earns 5% off. I’ve wanted to get him to move across to IM for over a year now.

I was hoping at one of the motorsports events last year I could have had some support from Julian to persuade him even more haha

Hi Kingdom35

Thanks for your kind words.

Your Dad is very welcome to join you with us at the races this year (it looks like they will be open) and we can chat over things with him.

The 5% annual withdrawal from his Pru fund sounds to be part of the original capital return rules (5% a year over 20 years is classed as a return of the original investment and is therefore tax free), rather than actual income/growth returns on the investment.

We won't try and persuade him do do anything, just explain his options in plain English. It may be the case that he is better where he is, it may not be. Either way we can give him all the information and guidancehe he needs to make his own informed decisions.

And we can watch some racing and take him round the garages and the grid lane!

Cheers

Julian

Thanks Julian.
That would be great. I will find out exactly the fund he has in the mean time. It’s supplemented his annuity well so far. But always good to see if there are better options.

That’s good news on the racing front.
How do we put our names down for some tickets for this year? We were in place for last year I believe Silverstone. I’ve just had a look at the calendar, Silverstone or Brands Hatch would be great, if possible 2/3 tickets (my uncle loves the racing too).

Thanks again for all the help and guidance on here it’s been interesting.

Have a good weekend

[CAPP0]

JulianPH said:

Hi mate

• Delta was sold at £33.65, so approximately. $46.74 which is 73% up of the base price of $27.01

• Norwegian was sold at £23.26, so approximately $32.30 which is 111.5% up on base price of $15.27

Not a bad 8 months there! Everyone will get an email early next week as the cash comes through. Both have fallen quite hard today (Delta c. 4% and Norwegian c. 12%). I am sure they will recover, but we got out before this and our work here is done!

Have a great weekend!

Cheers

Julian

Question for the Google Finance/Google Sheets gurus (Goorus?? ) - are all the figures returned shown in dollars?

[i4got]

CAPP0 said:

Question for the Google Finance/Google Sheets gurus (Goorus?? ) - are all the figures returned shown in dollars?

Yes - you need to convert into GBP

You can use =GOOGLEFINANCE("CURRENCY:USDGBP") to get a GBP rate then just multiply the shares USD price by the result to get the GBP price.

[CAPP0]

i4got said:

CAPP0 said:

Question for the Google Finance/Google Sheets gurus (Goorus?? ) - are all the figures returned shown in dollars?

Yes - you need to convert into GBP

You can use =GOOGLEFINANCE("CURRENCY:USDGBP") to get a GBP rate then just multiply the shares USD price by the result to get the GBP price.

Perfect - thanks!

[i4got]

CAPP0 said:

i4got said:

CAPP0 said:

Question for the Google Finance/Google Sheets gurus (Goorus?? ) - are all the figures returned shown in dollars?

Yes - you need to convert into GBP

You can use =GOOGLEFINANCE("CURRENCY:USDGBP") to get a GBP rate then just multiply the shares USD price by the result to get the GBP price.

Perfect - thanks!

Just. to clarify it is only US stock which are returned in dollars. Basically all prices are returned in their domestic currency.

I use this to convert from either USD or EUR to GBP
=F4*switch(A4,"UK",1,"US",$B$1,"EUR",1/$D$1)

A4 is one of the values UK, US or EUR
F4 is the price in domestic currency.
$B$1 is the USD GBP rate. =GOOGLEFINANCE("CURRENCY:USDGBP")
$D$1 is the EUR GBP rate =GOOGLEFINANCE("CURRENCY:GBPEUR")

[CAPP0]

i4got said:

Just. to clarify it is only US stock which are returned in dollars. Basically all prices are returned in their domestic currency.

I use this to convert from either USD or EUR to GBP
=F4*switch(A4,"UK",1,"US",$B$1,"EUR",1/$D$1)

A4 is one of the values UK, US or EUR
F4 is the price in domestic currency.
$B$1 is the USD GBP rate. =GOOGLEFINANCE("CURRENCY:USDGBP")
$D$1 is the EUR GBP rate =GOOGLEFINANCE("CURRENCY:GBPEUR")

See, now you've pulled the rug from under me again . So I would take that to mean any stock which is prefaced NASDAQ: or NYSE:? But then NCLH returns the same numbers whether you add the NYSE: or not. What's the best way of determining which is US and in dollars and which is not? (Sorry, been a long week and I'n VERY tired!).

[PorkInsider]

JulianPH said:

Phooey said:

Hi mate, what price did we get?

Hi mate

• Delta was sold at £33.65, so approximately. $46.74 which is 73% up of the base price of $27.01

• Norwegian was sold at £23.26, so approximately $32.30 which is 111.5% up on base price of $15.27

Not a bad 8 months there! Everyone will get an email early next week as the cash comes through. Both have fallen quite hard today (Delta c. 4% and Norwegian c. 12%). I am sure they will recover, but we got out before this and our work here is done!

Have a great weekend!

Cheers

Julian

Nice work, Julian (and the team).

Just need to sort the remaining PHR stocks and work your magic on pushing the dollar down to help PHE and I think we'll be looking pretty chipper.



Joking apart, it's been an impressive performance so far with PHR.

[Simpo Two]

i4got said:

I use this to convert from either USD or EUR to GBP
=F4*switch(A4,"UK",1,"US",$B$1,"EUR",1/$D$1)

A4 is one of the values UK, US or EUR
F4 is the price in domestic currency.
$B$1 is the USD GBP rate. =GOOGLEFINANCE("CURRENCY:USDGBP")
$D$1 is the EUR GBP rate =GOOGLEFINANCE("CURRENCY:GBPEUR")

I just put 'USD to GBP' into Google.

[Ron-ski]

CAPP0 said:

See, now you've pulled the rug from under me again . So I would take that to mean any stock which is prefaced NASDAQ: or NYSE:? But then NCLH returns the same numbers whether you add the NYSE: or not. What's the best way of determining which is US and in dollars and which is not? (Sorry, been a long week and I'n VERY tired!).

If you don't specify an exchange Google Finance will attempt to match the correct one, so it's best to always specify the exchange where the stock is listed just in case there is more than one NCLH code. The value returned will always be the currency of the exchange your using, that I think is the only way you know.

This formula gets the close price on the date that PHR opened and converts it to Sterling.

=index(GOOGLEFINANCE(B18,"close",date(2020,7,7)),2,2)*INDEX(GOOGLEFINANCE("CURRENCY:USDGBP","PRICE",DATE(2020,7,7)),2,2)

B18 contains NYSE:NCLH

If you ask Google Finance for a price on a date it will actually return an index / array, containing 2 rows, each row has two columns - if you enter

=GOOGLEFINANCE("CURRENCY:USDGBP","PRICE",DATE(2020,7,7))

into a cell you'll see what I mean, using the index part with 2,2 you're asking google to just return the second row and second column result, ie the close price on the date specified.

For the current price I use:

=GOOGLEFINANCE(B18,"price")*INDEX(GOOGLEFINANCE("CURRENCY:USDGBP","PRICE",TODAY()),2,2)

I've found some of the more complicate formula's often don't work and simply return #N/A, sometimes hitting F5 fixes it, sometimes not. Also funny things can happen on days when an exchange is closed.
I built my spreadsheet entirely from googling what I wanted, although I've dabbled with Excel and programming for years, which helps a lot.

Edited by Ron-ski on Saturday 6th March 09:32

[pingu393]

Ron-ski said:

...Also funny things can happen on days when an exchange is closed...

I use IFERROR(stuff,cell above)

This returns the value of the cell above if "stuff" returns an error.

[CAPP0]

Ron-ski said:

CAPP0 said:

See, now you've pulled the rug from under me again . So I would take that to mean any stock which is prefaced NASDAQ: or NYSE:? But then NCLH returns the same numbers whether you add the NYSE: or not. What's the best way of determining which is US and in dollars and which is not? (Sorry, been a long week and I'n VERY tired!).

If you don't specify an exchange Google Finance will attempt to match the correct one, so it's best to always specify the exchange where the stock is listed just in case there is more than one NCLH code. The value returned will always be the currency of the exchange your using, that I think is the only way you know.

This formula gets the close price on the date that PHR opened and converts it to Sterling.

=index(GOOGLEFINANCE(B18,"close",date(2020,7,7)),2,2)*INDEX(GOOGLEFINANCE("CURRENCY:USDGBP","PRICE",DATE(2020,7,7)),2,2)

B18 contains NYSE:NCLH

If you ask Google Finance for a price on a date it will actually return an index / array, containing 2 rows, each row has two columns - if you enter

=GOOGLEFINANCE("CURRENCY:USDGBP","PRICE",DATE(2020,7,7))

into a cell you'll see what I mean, using the index part with 2,2 you're asking google to just return the second row and second column result, ie the close price on the date specified.

For the current price I use:

=GOOGLEFINANCE(B18,"price")*INDEX(GOOGLEFINANCE("CURRENCY:USDGBP","PRICE",TODAY()),2,2)

I've found some of the more complicate formula's often don't work and simply return #N/A, sometimes hitting F5 fixes it, sometimes not. Also funny things can happen on days when an exchange is closed.
I built my spreadsheet entirely from googling what I wanted, although I've dabbled with Excel and programming for years, which helps a lot.

Edited by Ron-ski on Saturday 6th March 09:32

That's great, thank you, I'll have play with that later. I find it really interesting looking at the data you can get to from Google Finance/Sheets.