Home Page link  

Download bond price

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Download bond price YuriW 04-14-2008
Posted by John Pollard on April 25, 2008, 9:34 pm
Please log in for more thread options
TomYoung wrote:
> wrote:
>> TomYoung wrote:
>>> I emailed Etrade to ask why I didn't get prices for 4/21 -
>>> 4/22 when I
>>> did get prices for 4/14 - 4/18, and today (4/23), as it
>>> turns
>>> out.
>>
>>> An Etrade tech person called me and said that prices *don't*
>>> come from
>>> Etrade, but from Intuit. He believes that Intuit sets up a
>>> customer
>>> profile when it queries a FI and records CUSIP identifiers
>>> that it
>>> uses to pass prices down to Quicken. Ergo, the problem with
>>> the lack
>>> of price downloads was not with Etrade, not with something
>>> on
>>> my end,
>>> but with Intuit.
>>
>> Based solely on the info you've provided, I tend to think
>> you're
>> jumping to a conclusion. It certainly is possible that
>> Intuit
>> is getting it wrong, but if so, they're doing it in an
>> uncommon
>> and unlikely way.
>>
>> As far as I know, the OFX specs (that control the way in
>> which
>> downloads are done and their content) has always allowed for
>> downloads from investment financial institutions to contain
>> "holdings" in addition to transactions. And I think the OFX
>> spec actually recommends that holdings be provided.
>>
>> It is the downloaded holdings that contain prices for the
>> securities held at that institution, and every time I've ever
>> checked, my downloads do include those holdings (including
>> the
>> prices).
>>
>> The holdings also include an "as of" date, and that date is
>> not
>> always the date of the download. I downloaded from Smith
>> Barney
>> on April 23rd at about 7:30pm CDT. But my downloaded
>> holdings
>> were dated April 22, so the bonds I hold at Smith Barney did
>> not
>> get prices for the 23rd. [I did not set the download up as a
>> test, so I did not check to see if my prices for the 22nd
>> were
>> changed as a result of the download.]
>>
>> I certainly don't attribute that lack of bond prices on the
>> 23rd
>> to Intuit; if Smith Barney did not provide holdings for the
>> date
>> I downloaded, Intuit could hardly have compensated for that.
>
> I may have the *wrong* conclusion but if so it's because what
> the tech
> told me was wrong, not because I'm jumping to it.

My reply said: "Based solely on the info you've provided"....

> He was very clear - but maybe incorrect - that prices came
> from
> Intuit,

I suggest you check with your fi again.

If Quicken/Intuit has access to (and has agreed to provide) bond
prices from a source other than the holdings provided by your
financial institution, it is news to me ... I anxiously await
proof of this assertion.

> I've never looked looked at the OFX specs so I'm not in a
> position to
> answer your response with any specifics, but the information
> from the
> FI clearly goes through the Intuit servers so there's at least
> the
> possibility the Intuit can insert a price.

The fact that the data passes through Intut's servers doesn't
provide any evidence that Intuit has separate access to bond
prices. Indeed, I think if you do some research, you'll find
that bond prices are jealously guarded by financial institution
... and no one can download them via Quicken's price download.
Getting bond prices independently from your broker costs money.

I do not believe that Intuit intends to provide independent
access (access not provided by your financial institution) to
bond prices. I welcome legitmate evidence to the contrary.

> Maybe we should establish a database of prices of widely-held
> bonds
> from different FI's and see if we can crack the code.

I have no objection to this, or any other, means of finding the
source of a problem. If someone wants to start the ball
rolling, I will contribute whatever I can ... as long as it
doesn't require me to stay up later than I like. :)

But for starters, I suggest that those who are concerned about
not getting bond prices from their fi, can start the ball
rolling. They can stay awake longer than some of us are willing
to, and download from their financial institutions late at
night. It those users download late at night, and do not get
bond prices; let them check their OFXlog to see what the date of
their "holdings" is. It any user finds their downloaded
holdings dated on the date they downloaded, but their bond
prices do not get updated for that same date ... please post
here.

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by John Pollard on April 26, 2008, 10:10 am
Please log in for more thread options
John Pollard wrote:

> But for starters, I suggest that those who are concerned about
> not getting bond prices from their fi, can start the ball
> rolling. They can stay awake longer than some of us are
> willing
> to, and download from their financial institutions late at
> night. It those users download late at night, and do not get
> bond prices; let them check their OFXlog to see what the date
> of
> their "holdings" is. It any user finds their downloaded
> holdings dated on the date they downloaded, but their bond
> prices do not get updated for that same date ... please post
> here.

FWIW: here is some additional info.

On Friday April 25th at 8:15 pm CDT, I did a One Step Update
which included a download from Smith Barney. No April 25th bond
prices. Checked the OFXlog; the downloaded Smith Barney
holdings prices were dated April 24.

Today, Saturday April 26th at 8:50 am CDT, I did a direct
download from Smith Barney, and got bond prices for April 25th,
which is the same as the "as of" date for the prices in the
Smith Barney downloaded holdings.

It appears to me that sometime between 04-25-08 at 8:15 pm and
04-26-08 at 8:50 am, Smith Barney updated the holdings that they
make available to Quicken to contain data for April 25.

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by TomYoung on May 22, 2008, 6:06 pm
Please log in for more thread options
> John Pollard wrote:
> > But for starters, I suggest that those who are concerned about
> > not getting bond prices from their fi, can start the ball
> > rolling. They can stay awake longer than some of us are
> > willing
> > to, and download from their financial institutions late at
> > night. It those users download late at night, and do not get
> > bond prices; let them check their OFXlog to see what the date
> > of
> > their "holdings" is. It any user finds their downloaded
> > holdings dated on the date they downloaded, but their bond
> > prices do not get updated for that same date ... please post
> > here.
>
> FWIW: here is some additional info.
>
> On Friday April 25th at 8:15 pm CDT, I did a One Step Update
> which included a download from Smith Barney. No April 25th bond
> prices. Checked the OFXlog; the downloaded Smith Barney
> holdings prices were dated April 24.
>
> Today, Saturday April 26th at 8:50 am CDT, I did a direct
> download from Smith Barney, and got bond prices for April 25th,
> which is the same as the "as of" date for the prices in the
> Smith Barney downloaded holdings.
>
> It appears to me that sometime between 04-25-08 at 8:15 pm and
> 04-26-08 at 8:50 am, Smith Barney updated the holdings that they
> make available to Quicken to contain data for April 25.
>

In a follow-up to my ongoing problem with Quicken's OFXLOG showing the
correct price and date for the 3 bonds in question but Quicken
slotting the price into "tomorrow's" price line in the Price History
(a different thread in this newsgroup and Quicken's forums) I spoke to
Etrade again... different guy from last time. He said this problem is
a known issue and that Etrade is dealing with Quicken about the
issue. He, too, insisted that prices *come from Quicken* and that the
issue in on Quicken's end, not Etrade's. He was adamant that Quicken
prices *everything* - bonds, stocks, etc. - which could explain why
I've noticed small stock price discrepancies between the FI and
Quicken in the past.

Tom Young



Posted by TomYoung on May 23, 2008, 5:27 pm
Please log in for more thread options
> John Pollard wrote:
> > But for starters, I suggest that those who are concerned about
> > not getting bond prices from their fi, can start the ball
> > rolling. They can stay awake longer than some of us are
> > willing
> > to, and download from their financial institutions late at
> > night. It those users download late at night, and do not get
> > bond prices; let them check their OFXlog to see what the date
> > of
> > their "holdings" is. It any user finds their downloaded
> > holdings dated on the date they downloaded, but their bond
> > prices do not get updated for that same date ... please post
> > here.
>
> FWIW: here is some additional info.
>
> On Friday April 25th at 8:15 pm CDT, I did a One Step Update
> which included a download from Smith Barney. No April 25th bond
> prices. Checked the OFXlog; the downloaded Smith Barney
> holdings prices were dated April 24.
>
> Today, Saturday April 26th at 8:50 am CDT, I did a direct
> download from Smith Barney, and got bond prices for April 25th,
> which is the same as the "as of" date for the prices in the
> Smith Barney downloaded holdings.
>
> It appears to me that sometime between 04-25-08 at 8:15 pm and
> 04-26-08 at 8:50 am, Smith Barney updated the holdings that they
> make available to Quicken to contain data for April 25.
>


OK, finally, FINALLY!, Quicken came clean and admitted that there is a
problem with Etrade price updates and that the problem IS on Quicken's
end. The Quicken tech I spoke to also confirmed that SECURITY PRICES
COME FROM QUICKEN, NOT FROM ETRADE. (Based solely on what I just
stated there, I hope I didn't jump to any conclusions.)

Tom Young

Posted by John Pollard on May 27, 2008, 1:44 pm
Please log in for more thread options
TomYoung wrote:

> OK, finally, FINALLY!, Quicken came clean and admitted that
> there is a
> problem with Etrade price updates and that the problem IS on
> Quicken's
> end. The Quicken tech I spoke to also confirmed that SECURITY
> PRICES
> COME FROM QUICKEN, NOT FROM ETRADE. (Based solely on what I
> just
> stated there, I hope I didn't jump to any conclusions.)

I am working on gathering more information on this subject; when
enough information becomes available to make it usable, I'll
post it here; then I'll leave it to you, and others, to decide
whether you may have been too anxious to believe certain things.

Here's a good place to start because my wording in previous
posts may have contributed to a mis-understanding on your part.

In a diferent thread here you posted that you found a date in
your OFXlog for your ETrade account that was one day earlier
than the prices you found in your Quicken price history (that
is: the today's prices were being entered into Quicken with
tomorrow's date).

The OFXlog date you reported was identified by the tag "DTASOF",
but that's not the correct tag/date for the prices that are
downloaded in the holdings from your financial institution. The
correct tag is "DTPRICEASOF, and there should be one of those
tags (and one price) for each security you hold. The
DTPRICEASOF date should be the date that Quicken uses for any
price it puts in your Quicken price history. [I should have
noted this when you first posted it, but sometimes we just
overlook the obvious.]

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Similar ThreadsPosted
What's causing problems with Bond Price downloads from Etrade? May 6, 2008, 6:42 pm
Mutual Fund Price Download February 22, 2008, 5:55 pm
Download stock price in Quicken 2004 August 28, 2006, 11:31 am
Stock quote/Price history - can't download or manually update November 14, 2006, 11:59 am
401k and US savings bond accounts January 18, 2008, 12:52 pm
Entering Bond Allocation into Portfolio rebalancer July 3, 2006, 3:58 pm
Q2007 Price August 14, 2006, 1:25 pm
Price of QD07? December 5, 2006, 4:31 pm
Price History Too Big December 5, 2006, 4:42 pm
Quicken Best Price November 16, 2007, 12:24 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap