Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Yahoo Quote Data
I have now loaded 3 year historical data and starting to explore outputs in Powerslicer reports. My current dilemma is erros in the Capital Gains. On investigation this is an issue with the integrity of data from Yahoo Finance. As an example this is an extract of data for IHOO.AX
The data for 22/03/2018 is correct [close 112.23] but the prior days incorrect [e.g. close 20/03/2018 346.91]
I have had a look at the data through alphavantage and it has the same price errors.
I know that the quality of Yahoo quotes can be inconsistent, but in this case it is totally garbage.
To make my Powerslicer project worthwhile I need to have sound data.
I can source a csv or txt file with daily data that is correct, such as attached file ASXEQUITIESStockEasy-20180322 [I can have a number of differing formats]..
An extract of data is..
IHCB,20180322,104.56,104.64,104.5,104.5,8922
IHD,20180322,13.65,13.7,13.65,13.7,28656
IHEB,20180322,105.99,105.99,105.99,105.99,530
IHHY,20180322,106.14,106.3,106.14,106.3,694
IHL,20180322,.028,.03,.028,.03,642474
IHLOB,20180322,.01,.01,.01,.01,100000
IHOO,20180322,111.65,112.23,111.65,112.23,337
IHR,20180322,.3,.3,.3,.3,66674
IHVV,20180322,346.32,346.97,346.1,346.48,1232
IHWL,20180322,32.87,32.87,32.73,32.74,375
IJH,20180322,247.93,250.69,247.93,249,744
IJP,20180322,77.53,79.17,77.3,78.06,21490
Is there someway I can use this data with the UpdatePSData.bat process.
At this point just looking for an effective way of having better quality data.
The data for 22/03/2018 is correct [close 112.23] but the prior days incorrect [e.g. close 20/03/2018 346.91]
I have had a look at the data through alphavantage and it has the same price errors.
I know that the quality of Yahoo quotes can be inconsistent, but in this case it is totally garbage.
To make my Powerslicer project worthwhile I need to have sound data.
I can source a csv or txt file with daily data that is correct, such as attached file ASXEQUITIESStockEasy-20180322 [I can have a number of differing formats]..
An extract of data is..
IHCB,20180322,104.56,104.64,104.5,104.5,8922
IHD,20180322,13.65,13.7,13.65,13.7,28656
IHEB,20180322,105.99,105.99,105.99,105.99,530
IHHY,20180322,106.14,106.3,106.14,106.3,694
IHL,20180322,.028,.03,.028,.03,642474
IHLOB,20180322,.01,.01,.01,.01,100000
IHOO,20180322,111.65,112.23,111.65,112.23,337
IHR,20180322,.3,.3,.3,.3,66674
IHVV,20180322,346.32,346.97,346.1,346.48,1232
IHWL,20180322,32.87,32.87,32.73,32.74,375
IJH,20180322,247.93,250.69,247.93,249,744
IJP,20180322,77.53,79.17,77.3,78.06,21490
Is there someway I can use this data with the UpdatePSData.bat process.
At this point just looking for an effective way of having better quality data.
Comments
Also this are the various formats I can use:
Example of Data Formats Available
The following are examples of the different End of Day Price Data formats. All formats are of the form Code, Date, Open, High, Low, Close, Volume.
Format
Example
Metastock
(Price in dollars;2 digit year)
XXX, 071107, 6.421, 6.421, 6.343, 6.384, 0
AAC, 071107, 3.14, 3.19, 3.14, 3.13, 188396
AAE, 071107, .115, .12, .11,.125, 1696393
EZYChart
(Price in cents; 2 digit year)
XXX, 071107, 642.1, 642.1, 634.3, 638.4, 0
YYY, 071107, 314, 319, 314, 313, 188396
ZZZ, 071107, 11.5, 12, 11, 12.5, 1696393
Insight Trader
(Price in cents; 2 digit year,volume/100)
AA1 07/11/07 642.1 642.1 634.3 638.4 0
AAC 07/11/07 314 319 314 313 1883
AAE 07/11/07 11.5 12 11 12.5 16963
Stock Easy
(Price in dollars;4 digit year)
XXX, 20071107, 6.421, 6.421, 6.343, 6.384, 0
YYY, 20071107, 3.14, 3.19, 3.14, 3.13, 188396
ZZZ, 20071107, .115, .12, .11, .125, 1696393
Metastock Vol(100)
(Price in dollars; 2 digit year,volume/100)
XXX, 071107, 6.421, 6.421, 6.343, 6.384, 0
YYY, 071107, 3.14, 3.19, 3.14, 3.13, 1883
ZZZ, 071107, .115, .12, .11, .125, 16963
CSV
(Price in dollars;date format dd-mmm-yyyy)
XXX, 01 Aug 2008, 6.421, 6.421, 6.343, 6.384, 0
YYY, 01 Aug 2008, 3.14, 3.19, 3.14, 3.13, 188396
ZZZ, 01 Aug 2008, .115, .12, .11, .125, 1696393
TO use PortfolioSlicer for each symbol you need at least one quote per month. One user provided scripts that let you get automated quotes from Yahoo, AlphaVantage, etc. If for your symbols quotes are not available in that source, then your other option is to update quotes manualy, but I do realize that is not an ideal option.
In your specific case, it is possible that this error is just temporary and Yahoo will eventually fix this issue. In such case for that symbol you will have to manually remove lines from the quotes file in your Quotes folder and re-run extract.
The formats you provided from other sources are not supprted by PortfolioSlicer.
A by product of this, other than having quality eod pricing is that I do not need to extract from Yahoo as much data so that when I run UpdatePSData.bat it runs in a fraction of the time.
All the best
(I'll ask). Would you consider passing a copy of your worksheet on to Vidas for his review (and possible use??) of your data import method?
Regards,
buddyb
Thanks. Vidas will know about this by reading this post. It is totally up to him if he uses your worksheet, or decides to use scripts to reference a local "multiple quote data" file. (I suspect he's busy with his current PS rollout).
buddy