Quick method of retrieving YIELD information

Itsallaguess · #567374

‎
With the ongoing issues with the Sharecast Forecast Yield information sometimes hampering the HYPTUSS automatic yield-scrape process, users might be looking to carry out a manual update of their income-investment yields to keep up to date with their expected individual holding or overall portfolio income.

For anyone interested in carrying out this exercise, I've devised a simple method to get all three yield sections of the Dividend Data site (FTSE 100 / FTSE 250 / Investment Trusts) onto a single browser page, that can then be used to text-search on, using individual holding EPIC codes, to then quickly enable a manual yield-update of each HYPTUSS holding to take place -

1. Open a new blank file in NOTEPAD, or other similar text editor

2. Copy the following bold text into the text-editor window -

<!DOCTYPE html>
<HTML>
<FRAMESET cols="33%,33%,33%">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse100">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse250">
<FRAME src="https://www.dividenddata.co.uk/investment-trust-dividend-yields.py">
</FRAMESET>
</HTML>

3. SAVE the text file locally with a HTML file extension, for example as YIELDS.HTML

4. Double-click on the locally-saved HTML file, and the three separate Dividend Data yield-pages should then open up into three separate vertical frames within a single browser tab -

Source - https://www.dividenddata.co.uk/dividendyield.py?market=ftse100

5. This single-tab, multi-frame browser page that then opens, similar to the above screenshot, can be quickly searched using your individual income-investment EPIC codes or company-names, and the browser search function will treat all three frame areas as a single searchable page, thus enabling rapid manual-gathering of holding yield information to then enable entering into your HYPTUSS portfolio page, whilst we're waiting on Sharecast to fix their Forecast Yield data...

Cheers,

Itsallaguess

TurboukToo2 · #567379

Had a quick go at this on my Mac and when clicking the newly created HTML file I got a Safari "webpage" displaying .....

<!DOCTYPE html>
<HTML>
<FRAMESET cols="33%,33%,33%">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse100">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse250">
<FRAME src="https://www.dividenddata.co.uk/investment-trust-dividend-yields.py">
</FRAMESET>
</HTML>

Have I done something wrong?

Itsallaguess · #567383

TurboukToo2 wrote:
Had a quick go at this on my Mac and when clicking the newly created HTML file I got a Safari "webpage" displaying .....

<!DOCTYPE html>
<HTML>
<FRAMESET cols="33%,33%,33%">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse100">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse250">
<FRAME src="https://www.dividenddata.co.uk/investment-trust-dividend-yields.py">
</FRAMESET>
</HTML>

Have I done something wrong?

I'm not sure, is the honest answer.

I tested this process on the following three browsers in Windows, and all gave the same expected outcome as shown in the previous screenshot -

Firefox

Edge

Opera

Are you able to try a different browser on your Mac system?

Cheers,

Itsallaguess

TurboukToo2 · #567385

Same result in Chrome too. The file info (properties) says its a HTML text file if that helps?

Golam · #567387

Not familiar with HYPTUSS.

My method is to use a spreadsheet : Column : A Ticker, B SP, C Annual Divi , D Yield % ( calculated from columns B and C.

I update my spreadsheet as follows > SPs weekly and Annual Divis as per declarations or use the FT.

Itsallaguess · #567388

TurboukToo2 wrote:
Same result in Chrome too.

The file info (properties) says its a HTML text file if that helps?

I wonder if it is something to do with the file extension of your created HTML file.

We could perhaps investigate that by generating the HTML file using one of the free online HTML editors, and saving the HTML file from there -

https://codebeautify.org/real-time-html-editor

If you copy and paste the HTML text from the original post into the left-hand section of the above online HTML editor, you should then be able to preview the resulting multi-frame output in the right-hand section, and the above site also has a useful 'DOWNLOAD' button that can then be used to locally save the generated HTML file using that process, so I think it will be worth trying that as it might actually be a more robust method of people generating their local HTML files anyway...

Cheers,

Itsallaguess

TurboukToo2 · #567398

So, https://codebeautify.org/real-time-html-editor did the trick and I now have a HTML file that works!

Thanks for taking your time to help!

Out of curiosity I uploaded my own created file into https://codebeautify.org/real-time-html-editor and it displayed something quite different to what I had pasted into the text editor from your original post and gave me the erroneous result I was seeing...

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="Content-Style-Type" content="text/css">
<title></title>
<meta name="Generator" content="Cocoa HTML Writer">
<meta name="CocoaVersion" content="2299.3">
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}
</style>
</head>
<body>
<!DOCTYPE html>
<HTML>
<FRAMESET cols="33%,33%,33%">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse100">
<FRAME src="https://www.dividenddata.co.uk/dividendyield.py?market=ftse250">
<FRAME src="https://www.dividenddata.co.uk/investment-trust-dividend-yields.py">
</FRAMESET>
</HTML>
</body>
</html>

Itsallaguess · #567406

TurboukToo2 wrote:
So,
[url]
https://codebeautify.org/real-time-html-editor [/url]

did the trick and I now have a HTML file that works!

Thanks for taking your time to help!

Out of curiosity I uploaded my own created file into https://codebeautify.org/real-time-html-editor and it displayed something quite different to what I had pasted into the text editor from your original post and gave me the erroneous result I was seeing...

Great news that you've managed to get going, and it's good that we've been able to tease out an improved HTML-file generation process using the above online editor during the solving of your issue, where people can now save their local HTML file from that online editor's DOWNLOAD button, which will remove any of the risk that I suspect you've been seeing on your system, where some text editors sometimes try to get a little too clever, and start inserting their own formatting text into the original HTML text, and using the above online editor to generate that HTML file will then remove that risk.

Cheers,

Itsallaguess

Itsallaguess · #575538

A quick update on this useful multi-frame process, which can also be used to quickly view FTSE 100 and FTSE 200 risers and fallers on a single web-page using the following instructions -

1. Open the online HTML editor in a new browser tab - https://codebeautify.org/real-time-html-editor

2. Copy and paste the following BOLD TEXT into the left-hand panel on the above editor -

<!DOCTYPE html>
<HTML>
<FRAMESET cols="25%,25%,25%,25%">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=1&timeInterval=1&priceOption=0&index=UKX">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=2&timeInterval=1&priceOption=0&index=UKX">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=1&timeInterval=1&priceOption=0&index=MCX">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=2&timeInterval=1&priceOption=0&index=MCX">
</FRAMESET>
</HTML>

3. On the HTML editor page, click the 'DOWNLOAD' button in the central area - the generated HTML file should download to your usual 'Downloads' area

4. Rename the downloaded HTML file to something memorable, such as 'FTSE Risers and Fallers', and move the HTML file to your desktop

5. Double-click on the HTML file, and it should open a multi-frame window in the following left-to-right frame configuration - FTSE 100 Risers / FTSE 100 Fallers / FTSE 250 Risers / FTSE 250 Fallers

Screen-shot link showing the generated web-page output of the above process, with individual scroll-bars for each frame section - https://i.imgur.com/3eBDYjh.png

6. If a different frame-order would be preferred, then altering the four HTTPS links in step 2 will allow different orders of information frames to be configured.

Do note that additional URL options are available using the 'This is Money' page (https://tinyurl.com/2fvz7y4m), including date-ranges, alternative index options, and also price ranges, so the above HTML generation process can be used to configure any particular URL that can be created by any of the drop-down options on the 'This is Money' page, and the subsequent 'Filter' button...

Also note that if these user-generated HTML files are kept in a local folder, then they can be set as 'Favourite' browser pages in the same way as any normal web-page, and then simply accessed using your normal browser processes, without needing to click on the underlying HTML files themselves...

Cheers,

Itsallaguess

stacker512 · #575578

This file works for me, on Linux / Firefox.

However, I'm not certain that this file is valid HTML.
Isn't it missing the <body> and </body> elements?

servodude · #576011

Itsallaguess wrote:Copy and paste the following BOLD TEXT into the left-hand panel on the above editor

Nice opportunity for the code tags in the phpBB markup

Code: Select all

<!DOCTYPE html>
<HTML>
<FRAMESET cols="25%,25%,25%,25%">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=1&timeInterval=1&priceOption=0&index=UKX">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=2&timeInterval=1&priceOption=0&index=UKX">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=1&timeInterval=1&priceOption=0&index=MCX">
<FRAME src="https://investing.thisismoney.co.uk/market-data/risers-fallers?type=2&timeInterval=1&priceOption=0&index=MCX">
</FRAMESET>
</HTML>

-sd

GPhelan · #576017

Both examples just work as described, when pasting the original HTML into a Notepad file saved as xxx.html and then opened using Vivaldi 5.4 running on Windows 8.1. It is amazing that such a few lines of code can be so powerful.
Vivaldi is a browser based on Chrome. V5.4 is a little out of date, dating from Aug 2022. The current version is 5.7, but no longer supports Windows 8.1

clunk · #590358

Itsallaguess wrote:‎
For anyone interested ..

I was already a fairly regular user of the dividenddata website, but this is excellent!

Worked perfectly first time for me (Chrome) - Thank you!

kiloran · #599255

A damp and windy day here so I'm catching up on some bits and pieces today.

I think this is an excellent technique suggested by Itsallaguess so I've added it to our Weebly Financial Software web page for easy future reference:
https://lemonfoolfinancialsoftware.weeb ... -page.html

It's in the Miscellaneous menu

--kiloran

MickR · #599266

Thanks.

The Lemon Fool

Donate to Remove ads

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

Quick method of retrieving YIELD information

Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Re: Quick method of retrieving YIELD information

Who is online