|
Posted by wbertram on January 22, 2008, 1:48 pm
Please log in for more thread options Try using the Yahoo/Finance downloadable .csv file. Works fine with
Quicken.
docdec1@juno.com wrote:
>>
>>
>>
>>
>>
>>
>>>> Stevey wrote:
>>>>>> Oilcan wrote:
>>>>>>> Watch out on weekends about dates.
>>>>>> Watch out also for prices provided before the current day's
>>>>>> mutual fund prices are available.
>>>>> The screen will tell you the actual day that the quotes were
>>>>> based on.
>>>> But the .csv file will always have today's date, regardless of
>>>> the date shown in the display.
>>>> I'd suggest only creating the .csv file on non-holiday weekdays
>>>> after mutual fund prices are available for the day.
>>>> --
>>>> John Pollard
>>>> First initial underscore Last name at mchsi dot com
>>>> Please reply to newsgroup
>>> Downloaded NetStock version 1.74.001. It worked well, but a couple of
>>> areas I had to tweak.
>>> As several have mentioned, the date, is the date of the NetStock
>>> export. As I was doing it over the weekend, I simply went in and did
>>> an "Edit" / "Replace" to change the date on the prices.txt file to
>>> reflect, Friday - 1/18/2008.
>>> A second area was one security had a post date of July 11, 2008. I
>>> found the same issue when using the other process. It was quickly
>>> resolved by going into NetStock, Settings, Data Preferences, and
>>> changing Number Formats from 2 to 4.
>>> There has been excellent dialogue in the posts. Either process will
>>> work to alleviate the quote issues we've all suffered with. The one
>>> item I'm still looking at is whether, after using the process, IF the
>>> quote server is working, will the quotes be updated to show, high,
>>> low, and volume for last Friday.
>> Sorry I'm a bit late joining the discussion, but hopefully the information
>> below will be of use to some Quicken users who prepare their own files of
>> stock prices for import into Quicken, and who want High, Low, and Volume as
>> well as Last price.
>>
>> The link provided leads to an old newsgroup posting with details of the .csv
>> file structure to enable importing not only Closing (Last) Price for a
>> security, but also High, Low, and Volume.
>>
>> I have tried it and it works well, but for some as yet undiscovered reason
>> Volumes greater than 20 million aren't imported.
>>
>> Note also that if your date format is dd/mm/yyyy (rather than mm/dd/yyyy as
>> in the post), the format in the post can be changed accordingly.
>>
>> It's fairly easy to set up an Excel macro to output a .csv file in the
>> required format, using either Yahoo or NetStock data as input.
>>
>> http://groups.google.com/group/alt.comp.software.financial.quicken/br...
>>
>> Regards,
>>
>> John- Hide quoted text -
>>
>> - Show quoted text -
>
> Thank you John!
>
> I'm not an 'awk' s/w person - really a hardware geek. But anyway, I
> used NetStock, the Mega file export, and did some editing in Excel. I
> was able to load price, high, and low as you mentioned. Yes, the
> volume, I haven't been able to resolve yet. But this is a WORKAROUND
> for a falling golden goose. It is truly sad!
>
> My other thought was whether a 'good' Quicken 'download' would take
> care of the above. Since it (Quicken download) hasn't worked since
> Thursday, I don't have a clue - YET.
>
> What I really think is we need to get together a group of unsatisfied
> Quicken users and develope a product that will solve issues for both
> Intuit and Money users.
>
> Whatcha think?
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap