Further testing & History options - update tab issues September 21, 2013 06:54AM | Registered: 10 years ago Posts: 10 |
Re: Further testing & History options - update tab issues September 21, 2013 02:35PM | Admin Registered: 11 years ago Posts: 28 |
Quote
... this works well for both stocks (I can confirm that the method is to append all Australian stock tickers with .AX) and for quoting the All Ordinaries Index on the Australian Stock Exchange (as ^AORD).
Quote
From my testing, it seems that Yahoo accepts Australian stock tickers labelled XXX.AX and that the log file reports them as XXX-AX. ... This is no big deal I think - it works, and the .AX nomenclature is from Stocks App on the iPhone / iPad, which sources from Yahoo. I may give this a bit more thought next weekend, but this version works for me.
Quote
However, and more importantly, I have been using the "History" tickbox option under the "Update" radio button in PalOMoney. The options here do not work as I expected ... and the options selected revert to defaults after each update. The main issue I see is that:
Quote
*** No matter what date is set in the "From Date" area of the History options, Running "Update" with "History" ticked and options set - only reports daily quotes for the past 20-23 trading days ***
Quote
This appears independent of how or what the "From Date" is set in the option (I have tried 60 days default, 90 days and manual sets to 01/01/2013 etc), ... PalOMoney is only returning 20-23 trading days ... not sure if this is a Yahoo limit or a PalOMoney feature ... but I can not use it to bridge the gap to 01 July anymore (more like 90 days now) or get any existing ticker prices older than mid August. ... and adding new tickers leaves me a bit short on only 20 days history. ... I've attached today's log and the csv files for BHP shares and the All Ords Industry ... from the History request of 90 days for your analysis.
Quote
Otherwise it is good product, needing a little interface tweaking before release to MS-Money-Hungry users (that's be the install MS Money user base :-)
Re: Further testing & History options - update tab issues September 21, 2013 10:45PM | Registered: 10 years ago Posts: 10 |
Quote
Good. Are these all the Australian cases? Are
> there other conventions we should know about?
Quote
It breaks your real time quotes. The real time
> quote internal source substitutes '-' for '.', and
> there is no switch to turn it off. It was there
> because Money used the '.' to separate a symbol
> from its class, e.g. brk.a and brk.b. The
> substitution allowed the original symbol to be
> used transparently. But this seems less and less
> necessary, since it is easy to change the symbol
> in Money. We are working on a switch to disable
> this feature, but it might be better to just
> permanently disable this substitution and require
> uses who have '.' to change them to '-' manually.
> Very few stocks are involved.
>
> But this change would enable you to use the real
> time quotes, which are a lot of fun, as you see
> how much money you made or lost during the day!
Quote
The Frequency sticks but the Starting date
> doesn't, however, the "Number of days previous"
> sticks, and "Last Day of the period" does as well.
> The basic idea is the once quotes have been
> obtained starting at a particular date, they don't
> need to be obtained again. Hit the Days Previous
> button to quickly apply a certain number of
> previous days to the start date.
Quote
This seems to be a PalOMoney/MoneyPal bug. The
> MoneyPal_(date-time) log file contains the URL
> being used, for example
>
> http://ichart.yahoo.com/table.csv?s=AAPL&a=7&b=22&
> c=2013&g=d&ignore=.csv
>
> This was the result of asking for 60 days previous
> data. However, the Yahoo Finance API specifies the
> month beginning at zero, not 1, so the request
> should have been ..&a=6... instead of 7. If this
> is a verified bug, it will trigger an immediate
> fix and update.
>
> In the meantime, specify the starting date one
> month previous.
Quote
This URL gets data back to 6/24/2013:
> http://ichart.yahoo.com/table.csv?s=AAPL&a=5&b=22&
> c=2013&g=d&ignore=.csv
>
> Also, daily quotes may bloat your Money file, and
> bog down charts, etc. The basic recommendation is
> for weekly quotes. Let us know how well your
> graphs, etc work. How large is your Money file?