Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

MNG - M&G demerged from Prudential

Discussions regarding financial software
Davidsb
2 Lemon pips
Posts: 197
Joined: November 17th, 2016, 5:51 pm
Has thanked: 318 times
Been thanked: 31 times

MNG - M&G demerged from Prudential

#260339

Postby Davidsb » October 26th, 2019, 5:22 pm

Would anybody be able to point me towards how to modify my HYP top-up spreadsheet to include MNG in my portfolio?

Many thanks.

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: MNG - M&G demerged from Prudential

#260341

Postby monabri » October 26th, 2019, 5:34 pm

Davidsb wrote:Would anybody be able to point me towards how to modify my HYP top-up spreadsheet to include MNG in my portfolio?

Many thanks.


Hi David

Make the changes on the "Digital Look Data Sheet" in HYPTUSS - (see below) and then add MNG using the "Add" button in the usual way in the "High Yield Portfolio sheet".

You will need to scroll down the window when adding the new entrant to select MNG if you add it to the bottom of the list.

The text required - see the link below.

https://postimg.cc/YjkTzvgj



HTH
monabri

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: MNG - M&G demerged from Prudential

#260345

Postby kiloran » October 26th, 2019, 5:50 pm

Davidsb wrote:Would anybody be able to point me towards how to modify my HYP top-up spreadsheet to include MNG in my portfolio?

Many thanks.

Page 16 of the User Guide at http://lemonfoolfinancialsoftware.weebl ... op-up.html describes the process.

You have read it haven't you ;) .... it's a fascinating read, worthy of the Booker Prize

--kiloran

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: MNG - M&G demerged from Prudential

#260474

Postby kiloran » October 27th, 2019, 4:44 pm

monabri wrote:
Davidsb wrote:Would anybody be able to point me towards how to modify my HYP top-up spreadsheet to include MNG in my portfolio?

Many thanks.


Hi David

Make the changes on the "Digital Look Data Sheet" in HYPTUSS - (see below) and then add MNG using the "Add" button in the usual way in the "High Yield Portfolio sheet".

You will need to scroll down the window when adding the new entrant to select MNG if you add it to the bottom of the list.

The text required - see the link below.

https://postimg.cc/YjkTzvgj

HTH
monabri

I was about to update the Company Data Sheet at http://lemonfoolfinancialsoftware.weebl ... op-up.html but I found that Sharecast appears to have no data for MNG so the URL Suffix /equity/MNG in column A of your link does not work (and the structure looks wrong.... it is more normally a variation of the company name rather than the stock symbol)

I'll keep my eye on it over the next week or so.

--kiloran

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: MNG - M&G demerged from Prudential

#260485

Postby monabri » October 27th, 2019, 6:09 pm


kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: MNG - M&G demerged from Prudential

#260486

Postby kiloran » October 27th, 2019, 6:41 pm

monabri wrote:Worked for me...

https://postimg.cc/Xpg2gXYj

MNG will work fine for prices from Yahoo, but did you get any forecast yield data from Sharecast? That is what the URL Suffix in Column A controls.

--kiloran

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: MNG - M&G demerged from Prudential

#260493

Postby monabri » October 27th, 2019, 7:22 pm

Ok, I'll admit I use HYPTUSS to scrape share price only....I didn't press the f'cast yield button.

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: MNG - M&G demerged from Prudential

#260506

Postby kiloran » October 27th, 2019, 8:40 pm

monabri wrote:Ok, I'll admit I use HYPTUSS to scrape share price only....I didn't press the f'cast yield button.

Ah, that clarifies things, monabri.

Using HYPTUSS to only get prices from Yahoo is a very large sledgehammer to crack a small nut. Have you considered the Simple Yahoo Price Scrape at: http://lemonfoolfinancialsoftware.weebl ... crape.html

--kiloran

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: MNG - M&G demerged from Prudential

#260524

Postby monabri » October 27th, 2019, 11:16 pm

Another reason why I run HYPTUSS and a separate Excel file is that I can cross check changes made (eg shares bought/sold).
I calculate the portfolio value shown in Excel and subtract it from the HYPTUSS total ...if the product is not zero I know to recheck the changes.

Davidsb
2 Lemon pips
Posts: 197
Joined: November 17th, 2016, 5:51 pm
Has thanked: 318 times
Been thanked: 31 times

Re: MNG - M&G demerged from Prudential

#260536

Postby Davidsb » October 28th, 2019, 7:06 am

...it's a fascinating read, worthy of the Booker Prize...

Personally, I felt the Nobel Prize for Literature was more appropriate, but what do I know.....

Thank you both for your help - I guess I'll just have to wait for Sharecast to get their act together....

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: MNG - M&G demerged from Prudential

#271473

Postby kiloran » December 16th, 2019, 2:54 pm

kiloran wrote:
monabri wrote:
Davidsb wrote:Would anybody be able to point me towards how to modify my HYP top-up spreadsheet to include MNG in my portfolio?

Many thanks.


Hi David

Make the changes on the "Digital Look Data Sheet" in HYPTUSS - (see below) and then add MNG using the "Add" button in the usual way in the "High Yield Portfolio sheet".

You will need to scroll down the window when adding the new entrant to select MNG if you add it to the bottom of the list.

The text required - see the link below.

https://postimg.cc/YjkTzvgj

HTH
monabri

I was about to update the Company Data Sheet at http://lemonfoolfinancialsoftware.weebl ... op-up.html but I found that Sharecast appears to have no data for MNG so the URL Suffix /equity/MNG in column A of your link does not work (and the structure looks wrong.... it is more normally a variation of the company name rather than the stock symbol)

I'll keep my eye on it over the next week or so.

--kiloran

I badgered Sharecast a couple times by email but never got a reply or acknowledgement.
But.... at last! Sharecast finally added MNG to their website over the past few days https://www.sharecast.com/equity/MG-855633 though it does not show in their list for the FTSE100.
Forecast Yield shows n/a but I guess it will update at some point.

I've updated the file "company data sheet.txt" at http://lemonfoolfinancialsoftware.weebl ... op-up.html

--kiloran


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: GPhelan and 3 guests