Can anyone explain why quotes are handled differently between QUOTES.py and OFX.py?


I’ve just verified that all of my quotes downloaded from my broker today (statement is dated yesterday) only updated the quote for yesterday’s closing price, and nothing for today (as it should).

On the other hand, the quotes from quotes.py all have an entry for today (Saturday) even though the ticker date is yesterday at closing.

This is NOT!! a complaint, but I agree with Sal’s suggestion that quotes.py should be reworked to act like the broker’s downloads in this regard. It was probably written by TFB to just use the current date?

If a user would like the script screen to also list the current quote price, that might be an option in Interactive Mode – but not to be downloaded into Money. That would also end the complaints that the quote price can’t be updated with newer OFX downloads that day.

This is from a brokerage statement on Saturday, 3/20/2010:

  {INVPOSLIST}
                    {POSMF}
                        {INVPOS}
                            {SECID}
                                {UNIQUEID}808509830
                                {UNIQUEIDTYPE}CUSIP
                            {/SECID}
                            {HELDINACCT}OTHER
                            {POSTYPE}LONG
                            {UNITS}1
                            {UNITPRICE}16.5500
                            {MKTVAL}16.5500
                            {DTPRICEASOF}20100319210000
                            {MEMO}SCHWAB INTL INDEX FUND
                        {/INVPOS}
                    {/POSMF}

and this from quotes.py statement on Saturday, 3/20/2010:
  {INVPOSLIST}
                    {POSSTOCK}
                        {INVPOS}
                            {SECID}
                                {UNIQUEID}F
                                {UNIQUEIDTYPE}TICKER
                            {/SECID}
                            {HELDINACCT}CASH
                            {POSTYPE}LONG
                            {UNITS}0
                            {UNITPRICE}13.29
                            {MKTVAL}13.29
                            {DTPRICEASOF}20100319160100.000[-5:EST]
                        {/INVPOS}
                    {/POSSTOCK}

notice that DTPRICEASOF is the same for both 3/19/2010 @ 4:01 P.M. EST
= 160100 which is the same as 210100 GMT.

So, I am at a loss as to why they are processed differently???

—————————————————————–

unless it’s because it uses the INFO section with just today’s date instead:

            {STOCKINFO}
                {SECINFO}
                    {SECID}
                        {UNIQUEID}F
                        {UNIQUEIDTYPE}TICKER
                    {/SECID}
                    {SECNAME}Ford Motor Compan
                    {TICKER}F
                    {UNITPRICE}13.29
                {/SECINFO}
            {/STOCKINFO}

here is a respective INFO section of my broker statement:

            {MFINFO}
                {SECINFO}
                    {SECID}
                        {UNIQUEID}808509830
                        {UNIQUEIDTYPE}CUSIP
                    {/SECID}
                    {SECNAME}SCHWAB INTL INDEX FUND
                    {TICKER}SWISX
                {/SECINFO}
                {MFTYPE}OPENEND
                {YIELD}2.8000
            {/MFINFO}

Advertisements

3 Comments »

  1. ray said

    If your quotes from the broker are like mine, They are “a day late, a dollar short.” What happens is that money only updates quotes once per day (the first one wins, later ones are ignored). To fix the problem, make sure quotes go into money first, then broker accounts. That is why bobby added the option for quotes first.

    Ray

  2. ameridan said

    Ray,

    Thanks for your reply. Now I understand why you wanted that option. Normally, I wouldn’t download quotes for investments already quoted on brokerage statements, but you’re doing that to get a more recent value (probably not a closing price though) into Money for ALL of your investments.

    I guess I’m addressing the wishes that others are expressing (like Sal) that the quote values be more representative of the Online quotes Money gathers from MSN, which are closing prices for days the market is open – so no values for holidays and weekends. Since Online updates aren’t “first-in” value only, you always got the current price and the closing price just replaced those values eventually.

    Anyways, Bobby is exploring this more. 🙂

  3. ray said

    It’s the way Money works. The “Quotes.PY” is a fake band-aid. It will give you the value of the investment at the time of download, but Money is written to only accept this value once for the current date, not the date in the OFX file.
    On-Line quotes are a different route and Money handles it as: current will replace what it has for that date. If we could mimic that path, then all would work correctly. Right now, the program gets current quotes via the OFX file, but it does not used the info to calculate gain/loss, nor does it give you a change value for the investment. All that shows in portfolio is “unch” and gain/loss is always $0.00.
    By-the -way, the value of funds on Sat, Sun, & Holidays is the same as the previous days close. These are suppose to be reported to the listing agencies before 6:00 PM each day. I usually wait until 6:30 PM because many times they are a few minutes late. To you and me it does not do any good other than a value. You cannot buy or sell at that value. Your buy and sell order must be done before close of market (4:00 PM) and the value of that buy and sell is calculated by 6:00 PM when the funds are priced for that day. If you sell a fund at 4:01 PM on Friday, it gets a value based on Monday’s close.
    Bottom line — we need On-Line quotes ala Money. Other than that, the rest of the Python scripts work as expected as long as that financial institutions keep supporting OFX downloads.

    Ray

RSS feed for comments on this post

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: