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

Showing page 2 out of 2. View the first page

  1. 31 Posted by Stuart Beesley ... on 17 Jun, 2022 05:41 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK.... Run this updated script... It will dump ALL the security/currency records.. Post the output back here.. Run this on your live dataset....

  2. 32 Posted by James Durling on 17 Jun, 2022 06:54 PM

    James Durling's Avatar

    Beginning file C:\Users\james\Downloads\check_prices (1).py at Fri Jun 17
    14:27:27 EDT 2022

    --------------------------------------------------------------------
    Found: Telus International
    -----
    _txnfile: tiksync/trunk
    asof_dt: 20220328
    currid:
    dec: 4
    hide_in_ui: y
    id: cbf2806e-ad3d-4a67-8f05-557025aa318c
    name: Telus International
    obj_type: curr
    old_id: 5283100
    pref:
    price_date: 1655524740000
    rate: 0.033715441672285906
    relative_to_currid: CAD
    rrate: 0.033715441672285906
    suff:
    ticker: TIXT
    ts: 1655487476277
    type: s

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

    Oldest snap: _txnfile: tiksync/trunk
    curr: cbf2806e-ad3d-4a67-8f05-557025aa318c
    dt: 20211109
    hi: 0.022371364653243846
    id: 29cd947e-1bfe-43e0-9477-b10b2902c77b
    lo: 0.022846698652044778
    obj_type: csnap
    rehi: 0.022371364653243846
    relo: 0.022846698652044778
    relrt: 0.022527596305474205
    rhi: 0.022371364653243846
    rlo: 0.022846698652044778
    ts: 1649080312390
    urt: 0.022527596305474205
    vol: 108500

    User Rate: 44.39 0.0225275963055
    Rate: 44.39 0.0225275963055

    Newest snap: _txnfile: tiksync/trunk
    curr: cbf2806e-ad3d-4a67-8f05-557025aa318c
    dt: 20220617
    hi: 0.033715441672285906
    id: cbb49af2-a02e-4c7f-81a5-cd3b505b7293
    lo: 0.03465003344940979
    obj_type: csnap
    rehi: 0.033715441672285906
    relo: 0.03465003344940979
    relrt: 0.033715441672285906
    rhi: 0.033715441672285906
    rlo: 0.03465003344940979
    ts: 1655487476276
    urt: 0.033715441672285906
    vol: 56844

    User Rate: 29.66 0.0337154416723
    Rate: 29.66 0.0337154416723

    --------------------------------------------------------------------
    Found: Danish Krone
    -----
    _txnfile: tiksync/trunk
    currid: DKK
    dec: 2
    hide_in_ui: y
    id: 942f50d8-01ef-4e69-b6e8-71abec1d4511
    name: Danish Krone
    obj_type: curr
    old_id: 6597862
    pref:
    price_date: 1655501768000
    rate: 5.439512619669277
    rrate: 5.439512619669277
    suff: kr.
    ts: 1655487439194

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 0.18384 5.43951261967
    Rate (to base): 0.18384 5.43951261967
    StockGlance Price(1): 0.18384
    StockGlance Price(2): 0.18384
    Number of price history records: 27

    Oldest snap: _txnfile: tiksync/trunk
    curr: 942f50d8-01ef-4e69-b6e8-71abec1d4511
    dt: 20220129
    hi: 0.0
    id: 54bc8172-9d0a-4ddc-abe0-da04cfaa915b
    lo: 0.0
    obj_type: csnap
    relrt: 5.231219920485457
    rhi: 0.0
    rlo: 0.0
    ts: 1643489270057
    urt: 5.231219920485457
    vol: 0

    User Rate: 0.19116 5.23121992049
    Rate: 0.19116 5.23121992049

    Newest snap: curr: 942f50d8-01ef-4e69-b6e8-71abec1d4511
    dt: 20220617
    hi: 0.0
    id: 5488990f-29d3-4df1-886f-c89dd6532615
    lo: 0.0
    obj_type: csnap
    relrt: 5.439512619669277
    rhi: 0.0
    rlo: 0.0
    ts: 1655487439198
    urt: 5.439512619669277
    vol: 0

    User Rate: 0.18384 5.43951261967
    Rate: 0.18384 5.43951261967

    --------------------------------------------------------------------
    Found: Apple
    -----
    _txnfile: tiksync/trunk
    asof_dt: 20220328
    currid:
    dec: 4
    hide_in_ui: n
    id: 3759ab68-50b6-496c-950b-3aff85f122ef
    name: Apple
    obj_type: curr
    old_id: 7802851
    pref:
    price_date: 1655524740000
    rate: 0.005810485243506054
    rel_curr_id: 2736dd84-7b62-4c39-beda-af27dfdec985
    relative_to_currid: USD
    rrate: 0.007552584929214039
    suff:
    ticker: AAPL
    ts: 1655487476285
    type: s

    -----
    Relative Currency: US Dollar
    Relative Rate (current price): 132.404999 0.00755258492921
    Rate (to base): 172.1026658 0.00581048524351
    StockGlance Price(1): 132.404999
    StockGlance Price(2): 132.404999
    Number of price history records: 153

    Oldest snap: _txnfile: tiksync/trunk
    curr: 3759ab68-50b6-496c-950b-3aff85f122ef
    dt: 20211109
    hi: 0.005175390677821331
    id: f0af5e75-2ec9-4038-9bad-389e9611f8dd
    lo: 0.005222567888206982
    obj_type: csnap
    rehi: 0.006603798504900019
    relo: 0.006663996625352109
    relrt: 0.006630860022544924
    rhi: 0.006603798504900019
    rlo: 0.006663996625352109
    ts: 1649080312591
    urt: 0.006630860022544924
    vol: 56573449

    User Rate: 192.43356 0.00519659876375
    Rate: 192.43356 0.00519659876375

    Newest snap: _txnfile: tiksync/trunk
    curr: 3759ab68-50b6-496c-950b-3aff85f122ef
    dt: 20220617
    hi: 0.005781057279970697
    id: 2d04ac57-9ffc-450f-beff-eec66a500ad3
    lo: 0.00592664128117415
    obj_type: csnap
    rehi: 0.007514333873651511
    relo: 0.007703566870095784
    relrt: 0.007552584929214038
    rhi: 0.007514333873651511
    rlo: 0.007703566870095784
    ts: 1655487476280
    urt: 0.007552584929214038
    vol: 68091652

    User Rate: 172.1026658 0.00581048524351
    Rate: 172.1026658 0.00581048524351

    --------------------------------------------------------------------
    Found: Swedish Krona
    -----
    _txnfile: tiksync/trunk
    currid: SEK
    dec: 2
    hide_in_ui: y
    id: 0df8704d-4be8-44e3-be4a-a32ebb134b32
    name: Swedish Krona
    obj_type: curr
    old_id: 854933
    pref: kr.
    price_date: 1655501766000
    rate: 7.867820613690008
    rrate: 7.867820613690008
    suff:
    ts: 1655487439193

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 0.1271 7.86782061369
    Rate (to base): 0.1271 7.86782061369
    StockGlance Price(1): 0.1271
    StockGlance Price(2): 0.1271
    Number of price history records: 21

    Oldest snap: _txnfile: tiksync/trunk
    curr: 0df8704d-4be8-44e3-be4a-a32ebb134b32
    dt: 20220129
    hi: 0.0
    id: 8b7dc196-e99c-406e-b969-2349d81352cc
    lo: 0.0
    obj_type: csnap
    relrt: 7.4460163812360385
    rhi: 0.0
    rlo: 0.0
    ts: 1643488357915
    urt: 7.4460163812360385
    vol: 0

    User Rate: 0.1343 7.44601638124
    Rate: 0.1343 7.44601638124

    Newest snap: _txnfile: tiksync/trunk
    curr: 0df8704d-4be8-44e3-be4a-a32ebb134b32
    dt: 20220617
    hi: 0.0
    id: db1b4493-467a-4c3c-baa5-737378a2b73b
    lo: 0.0
    obj_type: csnap
    relrt: 7.867820613690008
    rhi: 0.0
    rlo: 0.0
    ts: 1655487439194
    urt: 7.867820613690008
    vol: 0

    User Rate: 0.1271 7.86782061369
    Rate: 0.1271 7.86782061369

    --------------------------------------------------------------------
    Found: Brookfield Renewable Partners LP
    -----
    _txnfile: tiksync/trunk
    asof_dt: 20220328
    currid:
    dec: 4
    hide_in_ui: n
    id: 81c0499a-71e9-48ca-89d2-eb445b7011e8
    name: Brookfield Renewable Partners LP
    obj_type: curr
    old_id: 9646214
    pref:
    price_date: 1655524740000
    rate: 0.023073373327180433
    relative_to_currid: CAD
    rrate: 0.023073373327180433
    suff:
    ticker: BEP-UN
    ts: 1655487476298
    type: s

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 43.34 0.0230733733272
    Rate (to base): 43.34 0.0230733733272
    StockGlance Price(1): 43.34
    StockGlance Price(2): 43.34
    Number of price history records: 58

    Oldest snap: _txnfile: tiksync/trunk
    curr: 81c0499a-71e9-48ca-89d2-eb445b7011e8
    dt: 20220328
    hi: 0.01970055239166873
    id: 218b0f89-ca72-46b0-82c5-7f1b6c03c61d
    lo: 0.020104542818474354
    obj_type: csnap
    rehi: 0.01970055239166873
    relo: 0.020104542818474354
    relrt: 0.019936204146730464
    rhi: 0.01970055239166873
    rlo: 0.020104542818474354
    ts: 1649082970048
    urt: 0.019936204146730464
    vol: 188400

    User Rate: 50.16 0.0199362041467
    Rate: 50.16 0.0199362041467

    Newest snap: _txnfile: tiksync/trunk
    curr: 81c0499a-71e9-48ca-89d2-eb445b7011e8
    dt: 20220617
    hi: 0.02261931740826323
    id: e45e97f7-9bab-4792-9ca9-264fb3e5bdc6
    lo: 0.023320894978523906
    obj_type: csnap
    rehi: 0.02261931740826323
    relo: 0.023320894978523906
    relrt: 0.023073373327180433
    rhi: 0.02261931740826323
    rlo: 0.023320894978523906
    ts: 1655487476293
    urt: 0.023073373327180433
    vol: 122570

    User Rate: 43.34 0.0230733733272
    Rate: 43.34 0.0230733733272

    --------------------------------------------------------------------
    Found: iShares Core MSCI AC World ex Canada Idx ETF
    -----
    _txnfile: tiksync/trunk
    asof_dt: 20220328
    currid:
    dec: 4
    hide_in_ui: n
    id: f9328d78-91c8-4910-9a63-5cdeeb3d1bee
    name: iShares Core MSCI AC World ex Canada Idx ETF
    obj_type: curr
    old_id: 7048714
    pref:
    price_date: 1655524740000
    rate: 0.034387895460797804
    relative_to_currid: CAD
    rrate: 0.034387895460797804
    suff:
    ticker: XAW
    ts: 1655487476300
    type: s

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

    Oldest snap: _txnfile: tiksync/trunk
    curr: f9328d78-91c8-4910-9a63-5cdeeb3d1bee
    dt: 20211109
    hi: 0.027972027972027972
    id: 77e7dae3-5b23-4336-9378-2892f021dc8e
    lo: 0.028137310073157007
    obj_type: csnap
    rehi: 0.027972027972027972
    relo: 0.028137310073157007
    relrt: 0.028050490883590466
    rhi: 0.027972027972027972
    rlo: 0.028137310073157007
    ts: 1649080312712
    urt: 0.028050490883590466
    vol: 30841

    User Rate: 35.65 0.0280504908836
    Rate: 35.65 0.0280504908836

    Newest snap: _txnfile: tiksync/trunk
    curr: f9328d78-91c8-4910-9a63-5cdeeb3d1bee
    dt: 20220617
    hi: 0.034317091088438265
    id: 8b84b9e9-7761-4cfc-9459-d0f325135512
    lo: 0.03469812630117974
    obj_type: csnap
    rehi: 0.034317091088438265
    relo: 0.03469812630117974
    relrt: 0.034387895460797804
    rhi: 0.034317091088438265
    rlo: 0.03469812630117974
    ts: 1655487476300
    urt: 0.034387895460797804
    vol: 63527

    User Rate: 29.08 0.0343878954608
    Rate: 29.08 0.0343878954608

    --------------------------------------------------------------------
    Found: Hydro One
    -----
    _txnfile: tiksync/trunk
    asof_dt: 20220129
    currid:
    dec: 4
    hide_in_ui: n
    id: e08417d6-f0e7-46bb-85b9-0395bd50e753
    name: Hydro One
    obj_type: curr
    old_id: 6478293
    pref:
    price_date: 1655524740000
    rate: 0.030534351145038167
    relative_to_currid: CAD
    rrate: 0.030534351145038167
    suff:
    ticker: H
    ts: 1655487476316
    type: s

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 32.75 0.030534351145
    Rate (to base): 32.75 0.030534351145
    StockGlance Price(1): 32.75
    StockGlance Price(2): 32.75
    Number of price history records: 155

    Oldest snap: _txnfile: tiksync/trunk
    curr: e08417d6-f0e7-46bb-85b9-0395bd50e753
    dt: 20211109
    hi: 0.03274394237066143
    id: ca57977b-c532-4aa2-bfc6-6da7b1a4a6b8
    lo: 0.033003300330033
    obj_type: csnap
    rehi: 0.03274394237066143
    relo: 0.033003300330033
    relrt: 0.03286230693394676
    rhi: 0.03274394237066143
    rlo: 0.033003300330033
    ts: 1649080312825
    urt: 0.03286230693394676
    vol: 1139500

    User Rate: 30.43 0.0328623069339
    Rate: 30.43 0.0328623069339

    Newest snap: _txnfile: tiksync/trunk
    curr: e08417d6-f0e7-46bb-85b9-0395bd50e753
    dt: 20220617
    hi: 0.030039049863651253
    id: dad458a8-2dc4-402a-966a-7a58ebed5776
    lo: 0.030826141517451958
    obj_type: csnap
    rehi: 0.030039049863651253
    relo: 0.030826141517451958
    relrt: 0.030534351145038167
    rhi: 0.030039049863651253
    rlo: 0.030826141517451958
    ts: 1655487476300
    urt: 0.030534351145038167
    vol: 1497582

    User Rate: 32.75 0.030534351145
    Rate: 32.75 0.030534351145

    --------------------------------------------------------------------
    Found: Constellation Software Inc.
    -----
    _txnfile: tiksync/trunk
    asof_dt: 20220328
    currid:
    dec: 4
    hide_in_ui: n
    id: 3205cb61-5a55-413e-ab01-aca14c7708f7
    name: Constellation Software Inc.
    obj_type: curr
    old_id: 8489717
    pref:
    price_date: 1655524740000
    rate: 5.369185230114527E-4
    relative_to_currid: CAD
    rrate: 5.369185230114527E-4
    suff:
    ticker: CSU
    ts: 1655487476332
    type: s

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

    Oldest snap: _txnfile: tiksync/trunk
    curr: 3205cb61-5a55-413e-ab01-aca14c7708f7
    dt: 20211109
    hi: 4.5175686210767793E-4
    id: e5e0690d-f360-4649-bfda-ef743fb1aed7
    lo: 4.5893243137812826E-4
    obj_type: csnap
    rehi: 4.5175

  3. 33 Posted by Stuart Beesley ... on 17 Jun, 2022 07:05 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    You haven’t posted the whole output/contents/file?

  4. 34 Posted by James Durling on 17 Jun, 2022 07:24 PM

    James Durling's Avatar

    must have been cut-off....i added to the attached document

  5. 35 Posted by Stuart Beesley ... on 17 Jun, 2022 07:45 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok. You have TWO bank of Nova Scotia securities using ticker BNS. Edit the names so you can see the differences. Add ONE to (good) one and then TWO to the (?) other in the name field. NOTE the ‘other’ one has ‘bad’ data.

    Now use toolbox. Can I delete security on both and see which ones are used where.
    Then go to the investment registers and change the txns that use TWO to ONE.
    Now check toolbox can I delete security again.
    If Ok, delete TWO.
    Now check the prices of ONE and then try stock glance again?

  6. 36 Posted by James Durling on 17 Jun, 2022 07:47 PM

    James Durling's Avatar

    Sorry I sent you the cloned in error....refer to this one

  7. 37 Posted by Stuart Beesley ... on 17 Jun, 2022 07:59 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok, I really can’t do any more this way. If you want further help, as I said, email me:
    … Let me know either way?

  8. 38 Posted by Stuart Beesley ... on 17 Jun, 2022 08:35 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    While I remember, one last thing... I grabbed the latest stock glance from the author's site and compiled it. The pricing tests are different. If you want to try, it's here: …

    Would be interesting to see if the same problem arises....

  9. 39 Posted by Stuart Beesley ... on 18 Jun, 2022 07:49 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK, last shot, can you run this new script (new name).. I have incorporated both the new and old stock glance price methods... Send back output....

  10. 40 Posted by Stuart Beesley ... on 18 Jun, 2022 09:35 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    UPDATE... Very latest, version 3, use this script instead of the prior ones...

  11. 41 Posted by Stuart Beesley ... on 20 Jun, 2022 10:38 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Hi James, did you try script 3?

  12. 42 Posted by James Durling on 20 Jun, 2022 12:30 PM

    James Durling's Avatar

    Hi Stuart,

    Sorry for the late reply. Below is the output for the 3rd script

    Beginning file C:\Users\james\Downloads\check_prices_3.py at Mon Jun 20
    08:28:36 EDT 2022
    displayUnknownPrices: False
    displayZeroShares: False
    priceWindowSize: 7
    asOfDate/Today: 20220620 interval: 7 today:
    java.util.GregorianCalendar[time=1655728116795,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="America/Toronto",offset=-18000000,dstSavings=3600000,useDaylight=true,transitions=231,lastRule=java.util.SimpleTimeZone[id=America/Toronto,offset=-18000000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2022,MONTH=5,WEEK_OF_YEAR=26,WEEK_OF_MONTH=4,DAY_OF_MONTH=20,DAY_OF_YEAR=171,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=3,AM_PM=0,HOUR=8,HOUR_OF_DAY=8,MINUTE=28,SECOND=36,MILLISECOND=795,ZONE_OFFSET=-18000000,DST_OFFSET=3600000]

    --------------------------------------------------------------------
    Found: Bank of Nova Scotia
    -----
    _txnfile: tiksync/trunk
    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.012611930727557941
    relative_to_currid: CAD
    rrate: 0.012611930727557941
    suff:
    ticker: BNS
    ts: 1655497502828
    type: s

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 79.290001 0.0126119307276
    Rate (to base): 79.290001 0.0126119307276
    ts: 2022-06-17 16:25:02(.828) -0400 EDT Eastern Daylight Time 1655497502828
    hidden price_date: 2022-06-17 23:59:00(.000) -0400 EDT Eastern Daylight
    Time 1655524740000
    Old StockGlance price method returns: 79.290001
    ('**', u'Bank of Nova Scotia (Canadian Dollar): ', 0.012611930727557941, ',
    ', 0.012611930727557941)
    NEW StockGlance price method returns: 79.290001
    New StockGlance Price(1): 79.290001
    New StockGlance Price(2): 79.290001
    Number of price history records: 153

    Oldest snap: _txnfile: tiksync/trunk
    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: _txnfile: tiksync/trunk
    curr: 186086fa-79bd-4a0e-8569-f2d285891424
    dt: 20220617
    hi: 0.012426991270945802
    id: f48f1429-6def-456d-9bec-97787e795731
    lo: 0.012685525493199913
    obj_type: csnap
    rehi: 0.012426991270945802
    relo: 0.012685525493199913
    relrt: 0.012611930727557941
    rhi: 0.012426991270945802
    rlo: 0.012685525493199913
    ts: 1655497502812
    urt: 0.012611930727557941
    vol: 8452966

    User Rate: 79.290001 0.0126119307276
    Rate: 79.290001 0.0126119307276

    --------------------------------------------------------------------
    Found: Bell Canada
    -----
    _txnfile: tiksync/trunk
    asof_dt: 20220129
    currid:
    dec: 4
    hide_in_ui: n
    id: 3f983a70-161d-418c-8903-9eddb9040a32
    name: Bell Canada
    obj_type: curr
    old_id: 4625714
    pref:
    price_date: 1655524740000
    rate: 0.016147263038914905
    relative_to_currid: CAD
    rrate: 0.016147263038914905
    suff:
    ticker: BCE
    ts: 1655497502920
    type: s

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 61.93 0.0161472630389
    Rate (to base): 61.93 0.0161472630389
    ts: 2022-06-17 16:25:02(.920) -0400 EDT Eastern Daylight Time 1655497502920
    hidden price_date: 2022-06-17 23:59:00(.000) -0400 EDT Eastern Daylight
    Time 1655524740000
    Old StockGlance price method returns: 61.93
    ('**', u'Bell Canada (Canadian Dollar): ', 0.016147263038914905, ', ',
    0.016147263038914905)
    NEW StockGlance price method returns: 61.93
    New StockGlance Price(1): 61.93
    New StockGlance Price(2): 61.93
    Number of price history records: 154

    Oldest snap: _txnfile: tiksync/trunk
    curr: 3f983a70-161d-418c-8903-9eddb9040a32
    dt: 20211108
    hi: 0.015730690577316343
    id: a8a75d77-8311-463a-85e6-be07dab544ef
    lo: 0.01586042823156225
    obj_type: csnap
    rehi: 0.015730690577316343
    relo: 0.01586042823156225
    relrt: 0.015743073047858942
    rhi: 0.015730690577316343
    rlo: 0.01586042823156225
    ts: 1649011397988
    urt: 0.015743073047858942
    vol: 2031617

    User Rate: 63.52 0.0157430730479
    Rate: 63.52 0.0157430730479

    Newest snap: _txnfile: tiksync/trunk
    curr: 3f983a70-161d-418c-8903-9eddb9040a32
    dt: 20220617
    hi: 0.016033349623750998
    id: 5a449053-33d6-4f7d-98e9-a2e9f19bc1c6
    lo: 0.016207455166815963
    obj_type: csnap
    rehi: 0.016033349623750998
    relo: 0.016207455166815963
    relrt: 0.016147263038914905
    rhi: 0.016033349623750998
    rlo: 0.016207455166815963
    ts: 1655497502911
    urt: 0.016147263038914905
    vol: 7938611

    User Rate: 61.93 0.0161472630389
    Rate: 61.93 0.0161472630389

    --------------------------------------------------------------------
    Finished running normally at Mon Jun 20 08:28:36 EDT 2022

  13. 43 Posted by Stuart Beesley ... on 20 Jun, 2022 12:51 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    And can you resend the screenshots of SG and extract data SG as of now too please?

  14. 44 Posted by James Durling on 20 Jun, 2022 12:55 PM

    James Durling's Avatar


    On Mon, Jun 20, 2022 at 8:51 AM Stuart Beesley (Mr Toolbox) <[email blocked]> wrote:

    // Please reply above this line
    ==================================================

    From: Stuart Beesley (Mr Toolbox)

    And can you resend the screenshots of SG and extract data SG as of now too please?

    On Mon, Jun 20 at 05:30 AM PDT, James Durling wrote:

    Hi Stuart,

    Sorry for the late reply. Below is the output for the 3rd script

    Beginning file C:\Users\james\Downloads\check_prices_3.py at Mon Jun 20
    08:28:36 EDT 2022
    displayUnknownPrices: False
    displayZeroShares: False
    priceWindowSize: 7
    asOfDate/Today: 20220620 interval: 7 today:
    java.util.GregorianCalendar[time=1655728116795,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="America/Toronto",offset=-18000000,dstSavings=3600000,useDaylight=true,transitions=231,lastRule=java.util.SimpleTimeZone[id=America/Toronto,offset=-18000000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2022,MONTH=5,WEEK_OF_YEAR=26,WEEK_OF_MONTH=4,DAY_OF_MONTH=20,DAY_OF_YEAR=171,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=3,AM_PM=0,HOUR=8,HOUR_OF_DAY=8,MINUTE=28,SECOND=36,MILLISECOND=795,ZONE_OFFSET=-18000000,DST_OFFSET=3600000]

    --------------------------------------------------------------------
    Found: Bank of Nova Scotia
    -----
    _txnfile: tiksync/trunk
    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.012611930727557941
    relative_to_currid: CAD
    rrate: 0.012611930727557941
    suff:
    ticker: BNS
    ts: 1655497502828
    type: s

    -----
    Relative Currency: Canadian Dollar
    Relative Rate (current price): 79.290001 0.0126119307276
    Rate (to base): 79.290001 0.0126119307276
    ts: 2022-06-17 16:25:02(.828) -0400 EDT Eastern Daylight Time 1655497502828
    hidden price_date: 2022-06-17 23:59:00(.000) -0400 EDT Eastern Daylight
    Time 1655524740000
    Old StockGlance price method returns: 79.290001
    ('**', u'Bank of Nova Scotia (Canadian Dollar): ', 0.012611930727557941, ',
    ', 0.012611930727557941)
    NEW StockGlance price method returns: 79.290001
    New StockGlance Price(1): 79.290001
    New StockGlance Price(2): 79.290001
    Number of price history records: 153

    Oldest snap: _txnfile: tiksync/trunk
    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: _txnfile: tiksync/trunk
    curr: 186086fa-79bd-4a0e-8569-f2d285891424
    dt: 20220617
    hi: 0.012426991270945802
    id: f48f1429-6def-456d-9bec-97787e795731
    lo: 0.012685525493199913
    obj_type: csnap
    rehi: 0.012426991270945802
    relo: 0.012685525493199913
    relrt: 0.012611930727557941
    rhi: 0.012426991270945802
    rlo: 0.012685525493199913
    ts: 1655497502812
    urt: 0.012611930727557941
    vol: 8452966

    User Rate: 79.290001 0.0126119307276
    Rate: 79.290001 0.0126119307276

    --------------------------------------------------------------------
    Found: Bell

  15. 45 Posted by Stuart Beesley ... on 20 Jun, 2022 01:25 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK, even my old/new SG calculations are correct....!

  16. 46 Posted by James Durling on 20 Jun, 2022 01:50 PM

    James Durling's Avatar

    The updated SG Extension resolved everything!!! Thank you so much Stuart!

  17. Maddy closed this discussion on 21 Jun, 2022 04:46 PM.

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