Latest Security Price Report

DrgnMastr's Avatar


16 Apr, 2024 06:42 PM

Given the recent breakage of automatic quote loader, I have a suggestion for a report. I currently can't find any way of doing this cleanly and properly.

What I would like to have is a report that lists all of my active securities, alphabetically where each line contains:

Associated Symbol
Last Security Price and date
Value currency
with optional total number of units and value

Please note that the Last Security Price and date should reflect the most recent price and date as would be found by showing the security history.

I think such a report would be most useful when we suddenly find ourselves in the situation that Yahoo has broken their security price downloads and we have to change our pickup to another server..

  1. 1 Posted by derekkent23 on 17 Apr, 2024 08:12 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi DrgnMastr

    Stuarts extension EXTRA DATA – StockGlance Provides all the Data you asked for and more, except the Date of the displayed price.

    Have fun, Stay Safe.

  2. 2 Posted by DrgnMastr on 17 Apr, 2024 12:13 PM

    DrgnMastr's Avatar

    Thank you, Derek.

    For follow-on readers, the extension is "Extract Data: Show StockGlance 2020". If it had the last price update column with it, that would be marvellous, for sure.

    As is, though, it serves the purpose perfectly fine for getting a succinct list of my securities and funds to convert to a different quote source for automatic quote updates.

  3. 3 Posted by Stuart Beesley ... on 01 May, 2024 06:43 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    FYI - I have just updated my extract_data extension - option: Extract Account Balances... to extract some extra pricing data.. E.g. the hidden "price_date", last price dated date, flags to indicate if date(s) and price(s) differ (only when running using auto current date.. These fields are for diagnosing pricing issues....

    ... You need to grab from my site... Latest preview SIGNED builds section..:

  4. 4 Posted by Stuart Beesley ... on 01 May, 2024 06:44 AM

    Stuart Beesley (Mr Toolbox)'s Avatar


  5. 5 Posted by Stuart Beesley ... on 02 May, 2024 07:51 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I have also added a new report to toolbox to quickly validate pricing data.

  6. 6 Posted by DrgnMastr on 04 May, 2024 01:33 AM

    DrgnMastr's Avatar

    That validate pricing data is one marvellous consistency checker. I have been using it regularly. Thank you, Stuart!!

  7. 7 Posted by Stuart Beesley ... on 04 May, 2024 06:16 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    And now you can also just run a price report as well as the validation report, both in toolbox.

    Toolbox 🧰 +1 😃
    ED +1 😃

  8. 8 Posted by DrgnMastr on 04 May, 2024 10:53 AM

    DrgnMastr's Avatar

    Both Toolbox and Extract Data are powerful extensions. They both have proven to be invaluable for me. I had 25 years of data to bring inline and make consistent, including 10 years of data that came from the original quicken import. THANK YOU, Stuart!

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac