Home Page link  

quotes - 1/18/08 ?

  
Groups | Search | About
User Password
Register Now! Lost Password?

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
quotes - 1/18/08 ? P.Schuman 01-18-2008
Posted by Han on January 19, 2008, 8:16 pm
Please log in for more thread options
> John makes a very good point.
> A work around you can use is:
>
> Open the exported file "prices.txt" by double clicking on it. The file
> opens with notepad. Now go to EDIT, Replace, then in the find field
> type the date you want to change and in the replace field type the
> date you want to use.
>
> For example...I got and exported the prices today, 1/19/2008. The
> prices were actually for yesterday, 1/18/2008
>
> So in the "Find What" field i typed 1/19/2008 and in the Replace With
> field I typed 1/18/2008 then clicked OK and all the dates were changed
> to 1/18/2008.
>
> I then opened Quicken 2008, went to Investment Center and imported the
> prices.txt file and it had the correct date of 1/18/2008 for each
> stock.
>
> Good Luck
>
Yes I tried this also, but figured that I could replace /19/ with /18/
(nowhere but in the date would there be 2 forward slashes with the number
between for the date). It worked. But in my tries I forgot the replace
routine once, so now I have whole bunch of stock prices for Saturday the
19th. Is there a way to delete "en masse" a bunch of stock prices for a
single date?

--
Best regards
Han
email address is invalid

Posted by MedRxMan on January 19, 2008, 9:36 pm
Please log in for more thread options
 My advise is to suck it up and forget it. unless you want to delete the
1/19/2008 individually from each stock. I have the duplicate prices also for
the 19th but have 142 prices..too long a process. Even in Quicken if you
download on a Saturday, the program would use 1/19/2008 unless you
remembered to change the date where indicated. I would wager a STARBUCKS
that at some point n time you have duplicate prices as a result of
forgetting to change the date.

Have a nice weekend and let it RIP


>
>> John makes a very good point.
>> A work around you can use is:
>>
>> Open the exported file "prices.txt" by double clicking on it. The file
>> opens with notepad. Now go to EDIT, Replace, then in the find field
>> type the date you want to change and in the replace field type the
>> date you want to use.
>>
>> For example...I got and exported the prices today, 1/19/2008. The
>> prices were actually for yesterday, 1/18/2008
>>
>> So in the "Find What" field i typed 1/19/2008 and in the Replace With
>> field I typed 1/18/2008 then clicked OK and all the dates were changed
>> to 1/18/2008.
>>
>> I then opened Quicken 2008, went to Investment Center and imported the
>> prices.txt file and it had the correct date of 1/18/2008 for each
>> stock.
>>
>> Good Luck
>>
> Yes I tried this also, but figured that I could replace /19/ with /18/
> (nowhere but in the date would there be 2 forward slashes with the number
> between for the date). It worked. But in my tries I forgot the replace
> routine once, so now I have whole bunch of stock prices for Saturday the
> 19th. Is there a way to delete "en masse" a bunch of stock prices for a
> single date?
>
> --
> Best regards
> Han
> email address is invalid



Posted by Han on January 20, 2008, 9:09 am
Please log in for more thread options

> My advise is to suck it up and forget it. unless you want to delete
> the 1/19/2008 individually from each stock. I have the duplicate
> prices also for the 19th but have 142 prices..too long a process. Even
> in Quicken if you download on a Saturday, the program would use
> 1/19/2008 unless you remembered to change the date where indicated. I
> would wager a STARBUCKS that at some point n time you have duplicate
> prices as a result of forgetting to change the date.
>
> Have a nice weekend and let it RIP
>
I'm not laying awake because of that (I don't have that many stocks that I
am tracking), and I am having a nice weekend in spite of everything.
Thanks for the help.

Anyone know how to translate the netstock stock index symbols into Quicken
ones? For instance, netstock calls the S&P 500 ^GSPC, whilke in Quicken it
seems to be INX.

--
Best regards
Han
email address is invalid

Posted by John Pollard on January 19, 2008, 9:54 pm
Please log in for more thread options
MedRxMan wrote:

> Open the exported file "prices.txt" by double clicking on it.
> The
> file opens with notepad. Now go to EDIT, Replace, then in the
> find
> field type the date you want to change and in the replace
> field type
> the date you want to use.
> For example...I got and exported the prices today, 1/19/2008.
> The
> prices were actually for yesterday, 1/18/2008
>
> So in the "Find What" field i typed 1/19/2008 and in the
> Replace With
> field I typed 1/18/2008 then clicked OK and all the dates were
> changed to 1/18/2008.
>
> I then opened Quicken 2008, went to Investment Center and
> imported the
> prices.txt file and it had the correct date of 1/18/2008 for
> each
> stock.

I have no complaint with the workaround, but I suggest a much
better long term solution.

Ask the Netstock developer to provide the option to use the
known date of the prices in the "Quicken" price file export.

I believe the change would be trivial - the program already uses
the "known" date for its other - non Quicken - price file
export.

When I suggested this to the developer, he replied that it was
necessary to use "today's date" because he thought it was
possible that some prices his program acquired could have dates
that were "invalid" dates. This is not a legitmate reason for
the treatment given ... though his other reason - that the
product was "free" could be close to such a reason.

My guess is that the change would be trivial ... but I do not
have enough information to be sure that this is so.

I think that if the developer knew that many Quicken users
wanted the "known" date of the prices exported ... he might
relent.

[In fact, it should also be a trivial matter to determine if a
date is a "valid" date ... in which case the application could
then substitute today's date, or - better yet - refrain from
exporting any price record for that invalid date.]

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



Posted by wbertram on January 19, 2008, 11:11 pm
Please log in for more thread options
You can use Yahoo Finance to download a .csv file of stock and fund
quotes. The file has price, date, and other data for stocks. The .csv
file is directly imported into Quicken and other programs, i.e., Excel
and Fund Manager, for example. I have been using this for several
years with no problems. An ICON on the desktop takes one directly to
the Yahoo download page. All stock and fund prices are available by 7PM
EST.

John Pollard wrote:
> MedRxMan wrote:
>
>> Open the exported file "prices.txt" by double clicking on it.
>> The
>> file opens with notepad. Now go to EDIT, Replace, then in the
>> find
>> field type the date you want to change and in the replace
>> field type
>> the date you want to use.
>> For example...I got and exported the prices today, 1/19/2008.
>> The
>> prices were actually for yesterday, 1/18/2008
>>
>> So in the "Find What" field i typed 1/19/2008 and in the
>> Replace With
>> field I typed 1/18/2008 then clicked OK and all the dates were
>> changed to 1/18/2008.
>>
>> I then opened Quicken 2008, went to Investment Center and
>> imported the
>> prices.txt file and it had the correct date of 1/18/2008 for
>> each
>> stock.
>
> I have no complaint with the workaround, but I suggest a much
> better long term solution.
>
> Ask the Netstock developer to provide the option to use the
> known date of the prices in the "Quicken" price file export.
>
> I believe the change would be trivial - the program already uses
> the "known" date for its other - non Quicken - price file
> export.
>
> When I suggested this to the developer, he replied that it was
> necessary to use "today's date" because he thought it was
> possible that some prices his program acquired could have dates
> that were "invalid" dates. This is not a legitmate reason for
> the treatment given ... though his other reason - that the
> product was "free" could be close to such a reason.
>
> My guess is that the change would be trivial ... but I do not
> have enough information to be sure that this is so.
>
> I think that if the developer knew that many Quicken users
> wanted the "known" date of the prices exported ... he might
> relent.
>
> [In fact, it should also be a trivial matter to determine if a
> date is a "valid" date ... in which case the application could
> then substitute today's date, or - better yet - refrain from
> exporting any price record for that invalid date.]
>

Similar ThreadsPosted
Quotes November 18, 2006, 7:44 pm
Quotes not available? January 19, 2007, 9:56 am
Re:Quotes for Sat jan 20 January 20, 2007, 12:11 pm
no quotes again July 9, 2007, 10:09 pm
Jan 22 quotes January 22, 2008, 9:01 pm
Re: Quotes Updates? September 26, 2006, 10:04 am
Re: Quotes Updates December 4, 2006, 5:15 pm
Quicken Quotes Don't December 4, 2006, 10:34 pm
Quotes screwed up again January 3, 2007, 5:53 pm
quotes missing - 1/26 vs 1/24 January 26, 2007, 5:02 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