Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Indices do not update #12

Open
KhaineBOT opened this issue Aug 30, 2018 · 7 comments
Open

Indices do not update #12

KhaineBOT opened this issue Aug 30, 2018 · 7 comments

Comments

@KhaineBOT
Copy link
Contributor

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
Copy link

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
Copy link
Contributor Author

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
Copy link
Contributor Author

This is what is in the csv file:

untitled

@charlietomo
Copy link

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
Copy link
Owner

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
Copy link
Contributor Author

KhaineBOT commented Oct 6, 2018

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
Copy link
Contributor Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants