Rod-Persky / investoscope-easy-update

Updates Investoscope 3 end of day quotes
GNU General Public License v3.0
6 stars 3 forks source link

Indices do not update #12

Open KhaineBOT opened 6 years ago

KhaineBOT commented 6 years ago

Steps undertaken

  1. Add an index to Investoscope (i.e. ^AXJO)
  2. Run Investoscope-easy-update
  3. Confirmed that index is not up to date

Expected behaviour Indicies in Investoscope are updated to reflect EOD price index

Steps to reproduce

  1. Add an index to Investoscope (i.e. ^AXJO)
  2. Run Investoscope-easy-update
  3. Review data and confirm that index information has not been updated
charlietomo commented 6 years ago

See this thread which isn't resolved but I understand is intended behaviour. I just delete the state.p file which then updates the instruments...I suspect that would also solve your issue, at the expense of downloading more data and hitting the server's more.

KhaineBOT commented 6 years ago

I don't think it is related to that as the index has no data. I can see that the csv file has up to date information, but it isn't being loaded into the index

untitled

KhaineBOT commented 6 years ago

This is what is in the csv file:

untitled

charlietomo commented 6 years ago

Oh apologies I hadn't clocked this was an index not an instrument. I don't rely on these so am not sure if they are meant to work.

Rod-Persky commented 6 years ago

There could be a bug in the process that results in the historic data not being downloaded here. I'll have a look at this when the opportunity arises.

KhaineBOT commented 6 years ago

I've confirmed that the data is downloaded, and that the AppleScript you use can update indices

tell first document of application "Investoscope 3"
    set anInstrument to first instrument whose symbol is "^GDAXI"
    anInstrument import historical quotes with CSV "Date,Open,High,Low,Close,Volume
21,12402.7197265625,12458.2998046875,12373.9501953125,12430.8798828125,400165400
2018-09-24,12383.419921875,12409.9599609375,12349.2998046875,12350.8203125,0
2018-09-25,12341.849609375,12416.8701171875,12322.1904296875,12374.66015625,83206800
2018-09-26,12395.2001953125,12395.919921875,12329.51953125,12385.8896484375,74964500
2018-09-27,12329.400390625,12456.6904296875,12272.650390625,12435.58984375,89854700
2018-09-28,12381.3603515625,12394.16015625,12190.5703125,12246.73046875,110639600
2018-10-01,12265.8896484375,12373.2900390625,12263.099609375,12339.0302734375,76918300
2018-10-02,12229.0703125,12310.759765625,12203.599609375,12287.580078125,82307700
2018-10-04,12275.0703125,12348.8603515625,12174.6904296875,12244.1396484375,101177000
2018-10-05,12236.2900390625,12245.41015625,12103.5498046875,12111.900390625,94036400" with replace

end tell

The next step is for me to validate that the csv file created is actually used to push the data into Investoscope as it is named idx_GDAXI_yv2.csv

KhaineBOT commented 6 years ago

Okay. The script doesn't pick up all indices, however for the ones it does, they are updated (kinda). This is the listing that it picks up

Updating: ^IXTR Nasdaq Transportation Updating: ^NYL NYSE World Leaders Updating: ^AXJO S&P/ASX 200 Updating: ^MID S&P 400 Midcap Index Updating: ^NDX Nasdaq-100 (Drm) Updating: ^IXUT Nasdaq Telecommunications Updating: ^GDAXI DAX Updating: ^IXIS Nasdaq Insurance Updating: ^NY NYSE US 100 Updating: ^OEX S&P 100 Index Updating: ^IXBK Nasdaq Bank Updating: ^IXIC Nasdaq Composite Updating: ^NYI NYSE International 100 Updating: ^NYA NYSE Composite Index Updating: ^IXK Nasdaq Computer Updating: ^DJI Dow Jones Industrial Average In Updating: ^IXF Nasdaq Financial 100 Updating: ^IXID Nasdaq Industrial Updating: ^NYY NYSE TMT Updating: ^IXFN Nasdaq Other Finance Updating: ^AORD S&P/ASX All Ordinaries Updating: ^NBI Nasdaq Biotechnology (Drm)

This is what I have listed as indices

screen shot 2018-10-06 at 1 35 00 pm

If I look at one that is in the listing like the S&P/ASX All Ordinaries, it does update the historical data, however the last price and latest trade are not updated

screen shot 2018-10-06 at 1 33 28 pm

This to me, indicates that the script would need to be enhanced to also update the extra fields of an index (i.e. latest trade, latest price). I also need to look into why not every index is pulled into the script.