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 TomYoung on May 27, 2008, 4:20 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

Well, it's good to know that; looking more closely at the OFXLOG I
*do* find a DTPRICEASOF field and that looks to be the source of the
problem.

For example I see the following for one of the bonds:

<UNITPRICE>86.694
<MKTVAL>
<DTPRICEASOF>20080524053800.000
<MEMO>FORD MOTOR CREDIT CO GLOBAL NOTE 7.00% 1


<SECNAME>FORD MOTOR CREDIT CO GLOBAL NOTE 7.00% 10/01/2013
<TICKER>345397TZ6
<UNITPRICE>86.694000
<DTASOF>20080523170000.000

I have no idea where the differing date/time information is coming
from but it looks like Quicken is using the DTPRICEASOF to fill its
Price History list.

Tom Young

Posted by John Pollard on May 28, 2008, 12:58 pm
Please log in for more thread options
TomYoung wrote:
> On May 27, 10:44 am, "John Pollard" wrote:
>> 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.]

> Well, it's good to know that; looking more closely at the
> OFXLOG I
> *do* find a DTPRICEASOF field and that looks to be the source
> of the
> problem.
>
> For example I see the following for one of the bonds:
>
> <UNITPRICE>86.694
> <MKTVAL>
> <DTPRICEASOF>20080524053800.000
> <MEMO>FORD MOTOR CREDIT CO GLOBAL NOTE 7.00% 1
>
>
> <SECNAME>FORD MOTOR CREDIT CO GLOBAL NOTE 7.00% 10/01/2013
> <TICKER>345397TZ6
> <UNITPRICE>86.694000
> <DTASOF>20080523170000.000
>
> I have no idea where the differing date/time information is
> coming
> from but it looks like Quicken is using the DTPRICEASOF to
> fill its
> Price History list.

http://tinyurl.com/44rdeq

--

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



Posted by YuriW on April 15, 2008, 11:43 pm
Please log in for more thread options
>
> > YuriW wrote:
> > > I have purchased California GObondand wondering if there is
> > > a way in
> > > Quickendownloadit's currentprice.
>
> > If you hold thebondat a brokerage from which you candownload,
> > they may (should, I think)downloadyourbondprices ... but
> > possibly only when there are also actual transactions to
> >download.
>
> I gave it a try with one of my accounts (Etrade) andbondprices
> *were* updated even though there were no transactions.
>
> Tom Young

Thank you all.

But *don't* have symbols defined in Quicken, so how does it know the
prices?

YuriW

Posted by John Pollard on April 16, 2008, 9:00 am
Please log in for more thread options
YuriW wrote:
>> wrote:
>>
>>> YuriW wrote:
>>>> I have purchased California GObondand wondering if there is
>>>> a way in
>>>> Quickendownloadit's currentprice.
>>
>>> If you hold thebondat a brokerage from which you
>>> candownload,
>>> they may (should, I think)downloadyourbondprices ... but
>>> possibly only when there are also actual transactions to
>>> download.

>> I gave it a try with one of my accounts (Etrade)
>> andbondprices
>> *were* updated even though there were no transactions.
>>
>> Tom Young

> Thank you all.
>
> But *don't* have symbols defined in Quicken, so how does it
> know the
> prices?

Downloads from financial institutions link to Quicken securities
by CUSIP number; once you have told Quicken that your Quicken
security, ABC, is the same as the downloaded security, American
Broadcasting Company, Quicken knows the CUSIP number of the
Quicken security and uses that CUSIP number to know which future
downloaded transactions, and holdings, pertain to which Quicken
security.

Each download from your investment financial institution should
include your holdings at that fi; and the holdings should
include the price/share of each security, as of the date of the
holdings.

--

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



Posted by Oilcan on April 16, 2008, 9:49 am
Please log in for more thread options
John,

So if I understand you correctly. If I own a bond and it is held in a
brokerage account, I could possibly get a price update - at least on the
days where there was activity - if Quicken asks me to match the security
between the download and Quicken. Otherwise if it does not, I would
have to manually input the price. Also there is now way to get a price
of a bond held outside of a broker. I base this on the fact that I
can't enter a CUSIP number (even though I could find one) into Quicken.

Oilcan

-----Original Message-----
From: John Pollard [mailto:invalid@invalid.com]
Posted At: Wednesday, April 16, 2008 6:00 AM
Posted To: alt.comp.software.financial.quicken
Conversation: Download bond price
Subject: Re: Download bond price

YuriW wrote:
>> wrote:
>>
>>> YuriW wrote:
>>>> I have purchased California GObondand wondering if there is
>>>> a way in
>>>> Quickendownloadit's currentprice.
>>
>>> If you hold thebondat a brokerage from which you
>>> candownload,
>>> they may (should, I think)downloadyourbondprices ... but
>>> possibly only when there are also actual transactions to
>>> download.

>> I gave it a try with one of my accounts (Etrade)
>> andbondprices
>> *were* updated even though there were no transactions.
>>
>> Tom Young

> Thank you all.
>
> But *don't* have symbols defined in Quicken, so how does it
> know the
> prices?

Downloads from financial institutions link to Quicken securities
by CUSIP number; once you have told Quicken that your Quicken
security, ABC, is the same as the downloaded security, American
Broadcasting Company, Quicken knows the CUSIP number of the
Quicken security and uses that CUSIP number to know which future
downloaded transactions, and holdings, pertain to which Quicken
security.

Each download from your investment financial institution should
include your holdings at that fi; and the holdings should
include the price/share of each security, as of the date of the
holdings.

--

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