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
-
- 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
Would anybody be able to point me towards how to modify my HYP top-up spreadsheet to include MNG in my portfolio?
Many thanks.
Many thanks.
-
- 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
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
-
- 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
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
-
- 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
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
-
- Lemon Half
- Posts: 8396
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1539 times
- Been thanked: 3428 times
-
- 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
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
-
- 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
Ok, I'll admit I use HYPTUSS to scrape share price only....I didn't press the f'cast yield button.
-
- 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
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
-
- 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
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.
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.
-
- 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
...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....
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....
-
- 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
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