Stock Glance Entension

James Durling's Avatar

James Durling

16 Jun, 2022 05:27 PM

HI,

The price that appears in Stocks at Glance on my summary page, differs from the actual stock price. I ahve tried downloing the quotes several times but no change.

Please compare the securite prices for Bank of Nova Scotia - Stock at Glance $60.53 - Security $78.50

  1. 1 Posted by Stuart Beesley ... on 16 Jun, 2022 05:36 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Are you referring to the stock glance extension or the normal price view on the summary / home page?

    What is the latest dated price on that stock (not the ‘current price’)? If different, what happens if you make them the same?

  2. 2 Posted by James Durling on 16 Jun, 2022 05:57 PM

    James Durling's Avatar

    Hi Stuart,

    The view that Stock Glance that appears on the summary page.

    The latest dated price is Today

    James

  3. 3 Posted by Stuart Beesley ... on 16 Jun, 2022 06:02 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    And do both the latest dated price and the ‘current price’ agree? Can u send screenshot of that?

  4. 4 Posted by James Durling on 16 Jun, 2022 06:38 PM

    James Durling's Avatar

    Attached is the screen shot. No, there are different

  5. 5 Posted by Stuart Beesley ... on 16 Jun, 2022 07:12 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Sorry, what does ‘No, there are different’ mean?

    Your screenshot does not show the price history. Double click the security to show the history and current price.

  6. 6 Posted by James Durling on 16 Jun, 2022 07:34 PM

    James Durling's Avatar

    [image: image.png]

  7. 7 Posted by Stuart Beesley ... on 16 Jun, 2022 08:13 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Can you see 60.56 anywhere in the system?

  8. 8 Posted by Stuart Beesley ... on 16 Jun, 2022 08:18 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    What’s the base currency? CAD?

  9. 9 Posted by Stuart Beesley ... on 16 Jun, 2022 08:28 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    One other thing to try. Install/run extract data extension. Select stock glance2020. Just click the button to view. At the display what price is shown for this there?

  10. 10 Posted by James Durling on 16 Jun, 2022 09:38 PM

    James Durling's Avatar

    78.5 - please see the attached

  11. 11 Posted by Stuart Beesley ... on 17 Jun, 2022 04:45 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok. So I expect that SG is converting CAD to USD which I’m hiding is your base currency. Possible?

  12. 12 Posted by James Durling on 17 Jun, 2022 10:25 AM

    James Durling's Avatar

    Base currency is CAD and this stock listed on the Toronto Stock Exchange.
    So it should not be any conversion. Previously, it was fine. So not sure if
    maybe something changed with the recent software release?

  13. 13 Posted by Stuart Beesley ... on 17 Jun, 2022 11:35 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok. I’m officially intrigued. Very odd. My own SG2020 is correct…. I have a couple of ideas.

    1. You could check for orphan price history records. Backup FIRST. Run toolbox extension. Update mode. Currency/security tools. Option ‘ Thin/Purge Price History’. Untick simulation. Select purge orphans only mode. Select all securities. Select purge orphans. (You can do the same in simulate first if you like). Restart after use.

    2. After 1. If problem still exists. Post help/console.

    3. I could easily find the issue if I could look into your dataset, but I’m guessing that’s not an option you want to pursue… ;->

    4. Do you have any future dated txns?

  14. 14 Posted by James Durling on 17 Jun, 2022 12:41 PM

    James Durling's Avatar

    Trying to do Step 1 - for some reason though I am not able to select the
    3rd option "Only Delete Orphans Mode"? its listed but not selectable as
    mouse and error keys are not able to choose the option?

  15. 15 Posted by Stuart Beesley ... on 17 Jun, 2022 12:42 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I think this means you have no orphans.

    Onto next step

  16. 16 Posted by James Durling on 17 Jun, 2022 12:47 PM

    James Durling's Avatar

    Ok here is the Help Console

    Starting Moneydance 2022.4 (4087) at Fri Jun 17 08:45:31 EDT 2022
    Settings Folder: C:\Users\james\.moneydance
    OS: Windows 10 10.0 amd64
    Architecture: intel64
    Java: 17.0.3 (Eclipse Adoptium)
    Is in sandbox: false; restricted file access: false
    Library path: c:\program files\moneydance\jre\bin;C:\Program Files
    (x86)\Common
    Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program
    Files (x86)\HP\Common\HPDestPlgIn\;C:\Program Files
    (x86)\HP\IdrsOCR_15.4.1132.0\;C:\Users\james\AppData\Local\Microsoft\WindowsApps;C:\Program
    Files (x86)\HP\Common\HPDestPlgIn\
    initialized extension moneyforesight in 0.349 seconds
    python.path: C:\Users\james\.moneydance\python
    python.cachedir: C:\Users\james\.moneydance\python\cache
    python.cachedir.skip: false

    #####################################################################
    extract_data: extract_data_init.py initializer script running - doing
    nothing - will exit....
    #####################################################################

    initialized extension extract_data in 0.208 seconds
    initialized extension stockglance in 0.008 seconds

    #####################################################################
    toolbox: toolbox_init.py initializer script running - doing nothing - will
    exit....
    #####################################################################

    initialized extension toolbox in 0.002 seconds
    Font initialisation attempted from non-UI thread. Hopping over to dispatch
    thread...
    Initializing fonts:
      default: [[Dialog]]
      printing: [[Dialog]]
      monospaced: [[Calibri, Monospaced]]
      coding: [[Hack, Monospaced]]
    fonts resolved:
     default: Dialog:12.0:style0
     mono: Calibri:12.0:style0
     coding: Hack:12.0:style0
     print: Dialog:12.0:style0
     header: Dialog:14.0:style0
     register: Dialog:11.0:style0
     reportTitle: Dialog:32.0:style0
     calendarTitle: Dialog:11.0:style0
     reportHeader: Dialog:10.0:style0
     detailTitle: Dialog:14.0:style0
    Setting look and feel class to
    com.sun.java.swing.plaf.windows.WindowsLookAndFeel
    Font initialisation attempted from non-UI thread. Hopping over to dispatch
    thread...
    initialized extension yahooqt in 0.763 seconds
    opening last file: Personal Finances
    loading dataset: C:\Users\james\.moneydance\Documents\Personal
    Finances.moneydance
    loading with 128 bit encryption key
    reading trunk data tiksync/trunk
    trunk data loaded (0.326 seconds), checking for incremental updates
    loading un-synced txn files...
    loading synced txn files...
    replacing root: null () with new root: Personal Finances
    (c833db84-0357-4303-815e-8e1e8d0bcba1
    set antialiasing to HRGB
    extension moneyforesight took a while (1.196 seconds) to respond to event
    md:file:opened
    ConnectionTask for Update_If_Needed done, result true
    Update info received with successful signature verification
    Version info retrieved; we are up to date!
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:03 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:05 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:07 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:09 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:11 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:13 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:15 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:17 EDT 2022) forcedRefresh=true
    Ran 0 of 2 MDP tasks @ Fri Jun 17 08:46:19 EDT 2022) forcedRefresh=true

  17. 17 Posted by Stuart Beesley ... on 17 Jun, 2022 01:25 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK, no issues in console..

    Download this (readonly and harmless script)
    Please go to Window/Show Moneybot Console.
    OPEN (this file)
    RUN
    copy / paste the output back here.....

  18. 18 Posted by James Durling on 17 Jun, 2022 01:39 PM

    James Durling's Avatar

    What should I use to open the file?

  19. 19 Posted by Stuart Beesley ... on 17 Jun, 2022 01:42 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    You save the file to disk and in MD Window/moneybot console, click OPEN

  20. 20 Posted by James Durling on 17 Jun, 2022 01:44 PM

    James Durling's Avatar

    Beginning snippet at Fri Jun 17 09:42:45 EDT 2022
    Finished running snippet normally at Fri Jun 17 09:42:45 EDT 2022

    looks like nothing was found?

  21. 21 Posted by Stuart Beesley ... on 17 Jun, 2022 01:55 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    You have to click RUN, not Run Snippet….

  22. 22 Posted by James Durling on 17 Jun, 2022 02:02 PM

    James Durling's Avatar

    Found: Bank of Nova Scotia
    -----
    asof_dt: 20220324
    currid: Bank of Nova Scotia
    dec: 4
    hide_in_ui: n
    id: 186086fa-79bd-4a0e-8569-f2d285891424
    name: Bank of Nova Scotia
    obj_type: curr
    old_id: 2363160
    pref:
    price_date: 1655524740000
    rate: 0.012434718041151902
    relative_to_currid: CAD
    rrate: 0.012434718041151902
    suff:
    ticker: BNS
    ts: 1655474221692
    type: s

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 80.419998 0.0124347180412
    Rate (to base): 80.419998 0.0124347180412
    StockGlance Price(1): 80.419998
    StockGlance Price(2): 80.419998
    Number of price history records: 153

    Oldest snap: curr: 186086fa-79bd-4a0e-8569-f2d285891424
    dt: 20211109
    hi: 0.012062726176115802
    id: a9fb544c-d4ff-4036-901a-2c8a38a7c77a
    lo: 0.012184720360667724
    obj_type: csnap
    rehi: 0.012062726176115802
    relo: 0.012184720360667724
    relrt: 0.012071463061323031
    rhi: 0.012062726176115802
    rlo: 0.012184720360667724
    ts: 1649011247781
    urt: 0.012071463061323031
    vol: 1399722

    User Rate: 82.84 0.0120714630613
    Rate: 82.84 0.0120714630613

    Newest snap: curr: 186086fa-79bd-4a0e-8569-f2d285891424
    dt: 20220617
    hi: 0.012426991270945802
    id: f48f1429-6def-456d-9bec-97787e795731
    lo: 0.012589701624071508
    obj_type: csnap
    rehi: 0.012426991270945802
    relo: 0.012589701624071508
    relrt: 0.012434718041151902
    rhi: 0.012426991270945802
    rlo: 0.012589701624071508
    ts: 1655474221692
    urt: 0.012434718041151902
    vol: 2790282

    User Rate: 80.419998 0.0124347180412
    Rate: 80.419998 0.0124347180412

  23. 23 Posted by Stuart Beesley ... on 17 Jun, 2022 02:26 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I’m stumped. Can you do this.
    Backup first.
    Toolbox. Enable update and advanced modes.
    - run. Fix non hierarchical txns. (Might be in security or transaction tools) - run. Diagnose hidden price date. - run. Diagnose currencies.

    If no errors. Run advanced, clone dataset. Tick to purge txns. But KEEP security and currency history.
    Open cloned dataset. Go to investment account. Add the security. Create a fake buy for 1 qty. what does SG say now?

  24. 24 Posted by James Durling on 17 Jun, 2022 02:51 PM

    James Durling's Avatar

    Still not reporting the correct price....here is a screenshot from the
    portfolio view in the account and the updated SG

  25. 25 Posted by Stuart Beesley ... on 17 Jun, 2022 02:59 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok, so this is in the cloned dataset that’s purged of all transactions?

    There’s nothing more I can diagnose like this. If you want me to help further/deeper, email me at:

    If not, no worries, over to someone else….

    (Not support, just a fellow user)

  26. 26 Posted by James Durling on 17 Jun, 2022 03:04 PM

    James Durling's Avatar

    Correct this is the cloned dataset....

  27. 27 Posted by Stuart Beesley ... on 17 Jun, 2022 03:19 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    .

  28. 28 Posted by Stuart Beesley ... on 17 Jun, 2022 04:32 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Hang on… I’ve just noticed that Bank of Nova Scotia is shown twice in the last screen shot. Why is that? Do you have it listed twice in Securities or something?

    Did my script find more entries?

  29. 29 Posted by James Durling on 17 Jun, 2022 05:05 PM

    James Durling's Avatar

    In the clone I had to add the security again and now its listed
    two....which is odd

    [image: image.png]

  30. 30 Posted by Stuart Beesley ... on 17 Jun, 2022 05:34 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    And what’s in the price history on the second one?

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? 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