ACZoom  ·  Archive-2016

Brilliant script for my ailing version of Quicken - Thank You ;-)

I work in GBP and use UK format dates so I had to do some tweaks;

URLHistForDate:
// items[4] is in pence and my import is in pounds
// so need to divide by 100 (rounded to decimals)
items[4]=Math.round(parseFloat(items[4])*100)/10000;
// date format required dd/mm/yyyy
ret += symb + "," + items[4] + "," + ymd[2] + "/" + ymd[1] + "/" + ymd[0];

urlCurrent:
items[1]=Math.round(parseFloat(items[1])*100)/10000;
// the date format returned is "M/dd/yyyy" with quotes so here's an extra process
// which allows me to easily switch month and day

// remove quotes
var new_line = line.replace(/\"/g,"");
ret = items[0] + "," + items[1] + "," + ymd[1] + "/" + ymd[0] + "/" + ymd[2];

Also, I don't use auto run in quicken but like to import the prices so after the script opens the output file I did;
// Quicken format = 1st line contains specific value
outFile.Writeline("!Type:Prices");

And before closing I did;
// Quicken format = specific value at end of file
outFile.Writeline("^");

Ok - Sorry for the delay ... I'll check the new version out and report back soon.

Thanks again for the script, all that's missing is a "PAYPAL" please donate button ;-)

Now, I no longer use Quicken Home Inventory but it is interesting to note that you can apply some settings to display the QHI option, or not .... why is this useful at acplace for the QImportP script ? Well wouldn't it be nice if you could run the script with "/automate" directly from a quicken menu ...
Put your QimportP .bat and .wsf in a directory such as C:/QImportP.
Locate the QUICKEN.INI file (Take a backup copy just in case) and add the following;
1. Where it says "AddApps" , ensure it includes the value ";QHI" (eg. AddApps;QHI).
2. Just before the [CONFIGURATION] section add the following lines;
[QHI]
ExeName=C:\QImportP\Qimportp.bat
MenuString=Doesnt seem to make any difference
IsGlobal=FALSE
InformExec=FALSE
ClassName=QHIConnCls
IntuitID=1007
When you start quicken, you should see the QHI menu, select it and hey presto, ot runs the QImportP load ;-)
[ Note.. I haven't found a way to change the menu name or location ... yet]

Hmm... I thought I running a .bat file from the ExeName worked fine, but when I tried it today, it failed, Quicken reported error about program not installed correctly. The bat script works fine from DOS prompt.

So then I used Bat-To-Exe-Converter to convert my customized QImportP.bat to QImportP.exe, put that in ExeName, and now it works fine. Using the Customize tip, have the Icon named QImportP too.
But somewhat strange that the .bat script stopped working at this time...

“InformExec=False” might be needed to run the .bat file

No luck, tried, FALSE, TRUE, and no line at all, for InformExec. But .bat file always fails, Quicken reporting "unable to run program, program not installed correctly".
Just changing the extension of the same script to .cmd makes it work. InformExec=TRUE works best, seems it prevents the flash of the DOS window that executes the script.

Thanks AC and Adrian for your work on this script which seems ideal to overcome the download problems with share prices in the UK. Incidentally, I have noticed that the currency rate download has also now been stopped.

I am using Vista 64, and QImportP downloads share prices correctly into the temporary folder, however it will not import them into Quicken. It complains that it cannot find Quicken, and asks whether the path is correct.

Quicken is at C:\Program Files (x86)\Quicken\qw.exe so I have changed the line setting the path in QImportP.wsf from:

var QEXE_DEFAULT = '"c:\\Program Files\\Quicken\\qw.exe"';

to

var QEXE_DEFAULT = '"c:\\Program Files (x86)\\Quicken\\qw.exe"';

but get exactly the same message about not being able to find Quicken. Can some please advise where I am going wrong? Thanks.

Thanks Anonymous for your reply. Unfortunately, I already had Quicken running before executing the script.

The script outputs a message: "Start Quicken and import prices into Quicken"

and then Windows reports: " Windows cannot find 'Quicken'. Make sure you typed the name correctly and try again."

It hangs at this point until "OK" is hit. The prices are downloaded correctly but not written into Quicken.

I get neither of the messages that you list.

I suspect the problem is caused by this line in the script:

var key = "HKLM\\SOFTWARE\\Intuit\\Quicken\\ExePath";

because there is no such entry in the registry when Quicken is installed in Vista 64, however, I cannot decide which is the correct registry entry out of the many related to Quicken.

Comparing Quicken in Vista 64 to Quicken in Vista 32 shows the Quicken registry entries to be very different. Any ideas which is the relevant registry entry?

Thanks very much Anonymous for your suggestions. I have now had some success - of sorts.

Following your suggestion, I converted the following lines in the doAutomation function to comments:-

// var qexe = '"' + getQEXERegVal(QEXE_DEFAULT) +'"';
// // Run will start application, or do nothing if app is already running
// try {
// WSH.Run(qexe, 1, false); // true to wait here, false to continue in this script
// } catch (e) {
// message("Error: Could not run Quicken at " + qexe + ", " + e.description, ERROR_LEVEL);
// return false;
// }

I still get the same error messages as before, but after clicking OK the script continues and successfully imports the prices into quicken. Disabling the auto-open of Quicken is not a problem for me because I use a password for Quicken anyway.

I am not sure whether this helps in any way, but In an attempt to eliminate the error and the need to "OK" the message, I tried changing

var QEXE_DEFAULT = '"c:\\Program Files (x86)\\Quicken\\qw.exe"';

back to

var QEXE_DEFAULT = '"c:\\Program Files\\Quicken\\qw.exe"';

but still got the same error - however it still imported the prices.

It appears to be a problem related to a 64 bit OS because I believe the error message - ” Windows cannot find ‘Quicken’. Make sure you typed the name correctly and try again.” - is output by Windows and not by the script. What I cannot find is which script command is now causing Windows to access Quicken.

Any further ideas? I very much appreciate your help on this.

Anonymous, thanks gain for your help.

I have discovered that the error message - ” Windows cannot find ‘Quicken’. Make sure you typed the name correctly and try again.” - occurs in Vista 64 and in Vista 32. After some more searching I have found the cause - the line:-

Start Quicken and import prices into Quicken

In the Windows batch file, QImportP.bat, should be a comment line, and was corrected to:-

@REM Start Quicken and import prices into Quicken

For users of Quicken under Vista 64 the other changes are to the QImportP.wsf script file and are as follows:-

var QEXE_DEFAULT = '"c:\\Program Files\\Quicken\\qw.exe"';
Changed to:
var QEXE_DEFAULT = '"c:\\Program Files (x86)\\Quicken\\qw.exe"';

And:-

var qexe = '"' + getQEXERegVal(QEXE_DEFAULT) +'"';
// Run will start application, or do nothing if app is already running
try {
WSH.Run(qexe, 1, false); // true to wait here, false to continue in this script
} catch (e) {
message("Error: Could not run Quicken at " + qexe + ", " + e.description, ERROR_LEVEL);
return false;
}

Changed to:-

// var qexe = '"' + getQEXERegVal(QEXE_DEFAULT) +'"';
// // Run will start application, or do nothing if app is already running
// try {
// WSH.Run(qexe, 1, false); // true to wait here, false to continue in this script
// } catch (e) {
// message("Error: Could not run Quicken at " + qexe + ", " + e.description, ERROR_LEVEL);
// return false;
// }

These changes remove the automatic launching of Quicken, which as a consequence, must be open before the script is run. Unfortunately I was unable to find the reason for this script not working in Vista 64.

Now to find a way of downloading UK Funds and updating Quicken......

Thanks AC for the reply. I have run your "test" script in a DOS window (under Vista64) and get:

-----------------------------------------------------------------------------------------------------------
Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:\Users\John>D:

D:\>cd temp

D:\Temp>cscript test.wsf
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

D:\Temp\test.wsf(2, 33) Windows Script Host: The value for the attribute is not
valid

D:\Temp>
----------------------------------------------------------------------------------------------------------

Will next try running from a Quicken toolbar.

It is obviously a problem with different chacter sets being used for HTML and a text file - the text I pasted in the last reply was changed again.

In the script I changed the double quotation marks to the standard quotation mark, and the single quotaion mark to an apostrophe.

AC

After more testing I have been able to get the original batch and script files to work in Vista 64 and 32, with only one change to the original script.

For Vista 32 the line:
var QEXE_DEFAULT = '"c:\\Program Files\\Quicken\\qw.exe"';
must be changed to:
var QEXE_DEFAULT = "c:\\Program Files\\Quicken\\qw.exe";
and for Vista 64 to:
var QEXE_DEFAULT = "c:\\Program Files (x86)\\Quicken\\qw.exe";

Having the path enclosed in quotes and apostrophes produces a path in double quotes which is the root of the problems described in my previous posts.

The coding to get the Quicken path from the registry can be left as the original. However, the script cannot find Quicken from the registry and therefore uses the default path - as above (the Vista registry structure for Quicken must be different from that in XP - assuming that this works in XP).

Suggestions:
Remove the section of script for obtaining the path to Quicken from the registry, and rely on the current default method - it works well. Pass an argument from the batch file to instruct the script to select the 64bit or the 32bit path.

Is there a way of sending a password to Quicken?

To complete the catalogue of changes: -
In the Windows batch file "QImportP.bat", one of the lines should be a comment line, and was corrected to:
@REM Start Quicken and import prices into Quicken

I have not tried to modify Quicken.ini so that the prices can be downloaded and imported from the Quicken menu. Instead I have put a shortcut to QImportP.bat, called "Quicken Share Price Import" into the Windows Start menu, and with Quicken open, (because I use a password) go to Start > All Programs > Quicken Share price Import. Simple, works well, and avoids modifying Quicken.

AC

Thanks very much for the information and your help.

1. The ‘” … “‘ issue. It is indeed strange why Vista is different. Having 2-pairs of quotes is only a problem for the registry lookup of the Quicken path. 2-Pairs of quotes work OK with the default path.

2. Searching the net does suggest there are ways of identifying the OS - unfortunately my knowledge of JScript is too limited for me to apply it.

3. Searching the Vista 64 registry for "qw.exe" brought up dozens of matches as below:

HKEY_CLASSES_ROOT\Local Settings\Software\Microsoft\Windows\Shell\MuiCache
HKEY_CLASSES_ROOT\QDBFile\shell\open\command
HKEY_CLASSES_ROOT\QDFFile\shell\open\command
HKEY_CLASSES_ROOT\QDTFile\shell\open\command
HKEY_CLASSES_ROOT\qfxfile\shell\open\command
HKEY_CLASSES_ROOT\qw\shell\open\command
HKEY_CLASSES_ROOT\QWMODFile\shell\open\command
HKEY_CLASSES_ROOT\Wow6432Node\Local Settings\Software\Microsoft\Windows\Shell\MuiCache
HKEY_CLASSES_ROOT\Wow6432Node\QDBFile\shell\open\command
HKEY_CLASSES_ROOT\Wow6432Node\QDFFile\shell\open\command
HKEY_CLASSES_ROOT\Wow6432Node\QDTFile\shell\open\command
HKEY_CLASSES_ROOT\Wow6432Node\qfxfile\shell\open\command
HKEY_CLASSES_ROOT\Wow6432Node\qw\shell\open\command
HKEY_CLASSES_ROOT\Wow6432Node\QWMODFile\shell\open\command
HKEY_CURRENT_USER\Software\Classes\Local Settings\Software\Microsoft\Windows\Shell\MuiCache
HKEY_CURRENT_USER\Software\Classes\Wow6432Node\Local Settings\Software\Microsoft\Windows\Shell\MuiCache
HKEY_CURRENT_USER\Software\Microsoft\IntelliPoint\AppSpecific\qw.exe
HKEY_CURRENT_USER\Software\Microsoft\IntelliPoint\AppSpecific\qw.exe
HKEY_CURRENT_USER\Software\Microsoft\IntelliType Pro\AppSpecific\qw.exe
HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\LowRegistry\Audio\PolicyConfig\PropertyStore\30495de9_0
HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\LowRegistry\Audio\PolicyConfig\PropertyStore\edf7434a_0
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.QDF\OpenWithList
HKEY_CURRENT_USER\Software\Netscape\Netscape Navigator\User Trusted External Applications
HKEY_CURRENT_USER\Software\Netscape\Netscape Navigator\Viewers
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\QDBFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\QDFFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\QDTFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\qfxfile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\qw\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\QWMODFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\QDBFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\QDFFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\QDTFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\qfxfile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\qw\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\QWMODFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\QDBFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\QDFFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\QDTFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\qfxfile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\qw\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\QWMODFile\shell\open\command
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\App Paths\qw.exe
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Classes\Local Settings\Software\Microsoft\Windows\Shell\MuiCache
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Classes\Wow6432Node\Local Settings\Software\Microsoft\Windows\Shell\MuiCache
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Microsoft\IntelliPoint\AppSpecific\qw.exe
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Microsoft\IntelliType Pro\AppSpecific\qw.exe
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Microsoft\Internet Explorer\LowRegistry\Audio\PolicyConfig\PropertyStore\30495de9_0
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Microsoft\Internet Explorer\LowRegistry\Audio\PolicyConfig\PropertyStore\edf7434a_0
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.QDF\OpenWithList
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Netscape\Netscape Navigator\User Trusted External Applications
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000\Software\Netscape\Netscape Navigator\Viewers
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000_Classes\Local Settings\Software\Microsoft\Windows\Shell\MuiCache
HKEY_USERS\S-1-5-21-1709783314-3825605714-3583000038-1000_Classes\Wow6432Node\Local Settings\Software\Microsoft\Windows\Shell\MuiCache

From the above list the following is the most likely:-

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\App Paths\qw.exe
and the equivalent Vista 32-bit version:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\qw.exe

Using the key in the script, as below, does appear to correctly return the path for qw.exe :-

var key = "HKLM\\SOFTWARE\\Wow6432Node\\Microsoft\\Windows\\CurrentVersion\\App Paths\\qw.exe\\path";

There are no error messages from the script. However, it is not reliable and always opens Windows Explorer showing the Quicken program directory, which has then to be closed manually. The default path is 100% reliable and does not open Windows Explorer. Is there a more likely registry key to try?

4. You are absolutely correct about the security issues of automatically opening Quicken when it is password protected. There is not any point in having password protection if another application can open the file withou a password. I tried your code but, as you say, it did not work anyway!

Leo

See post 14 for the 2 changes required. One change to the script, and one correction to the batch file.

Works fine for me on Vista 64 and should work with Win7

Version 0.5 now available, should support both Vista and Windows 7 though not tested. Thanks to comment above for the tips on fixing it.

AC
For UK Quicken users your QImportP script is extremely important and useful.

The last release of Quicken in the UK was Quicken 2004, since then there have been no program updates or support from Intuit. The Share price download facility continued to work in the UK until December 2008, and the currency conversion download worked for several months longer.

Since the end of 2008 those wanting to update portfolio share prices have had to do it manually, a very tedious process. Your script is therefore very valuable in the UK, especially since there is no alternative personal finance application with all the features of Quicken.

Although your script will download & import all UK share prices (provided the share symbols include the .L suffix - for example GSK.L - in Quicken and in the .CMD file) it will not download UK Fund prices. The UK fund prices do not appear to be in the Yahoo database:

http://download.finance.yahoo.com/d/quotes.csv?s=GSK.L&f=sl1d1

After some searching I found the UK Fund prices at the following address:

http://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0005141709GBP&f=sl1t1c1&e

and have added a few lines to the script which look up the last prices and write them onto the end of the .CSV file. For those wishing to modify the script and download UK fund prices I added the following lines between the two rows of Asterisks :-

// get current prices for all symbols, and write to output file
    var urlcurr = new UrlCurrForSymbols( symbols );
    message("URL=" + urlcurr, INFO_LEVEL);
    WinHttpReq.Open("GET", urlcurr.toUrl(), false);
    WinHttpReq.Send();
    if (WinHttpReq.Status == HTTP_STATUS_OK) { // 200
        message(WinHttpReq.ResponseText, DEBUG_LEVEL);
        var lines = WinHttpReq.ResponseText.split("\r\n");
        for(var i in lines) {
            var out = urlcurr.toQuicken(lines[i]);
            if (out) {
                outFile.WriteLine(out);
            }
        }
    } else {
        error = true;
        message("Error: could not retreive latest prices for symbols="+symbols, ERROR_LEVEL);
        message("  Code " + WinHttpReq.Status + " retrieving " + urlcurr.toUrl(), ERROR_LEVEL);
    }
//*******************************************************************************
// ***** Get L&G Fund price - JEF lines added down to and including outFile.WriteLine(jefcol) *****
	WinHttpReq.Open("GET", "http://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0005141709GBP&f=sl1t1c1&e=.csv", false);
	WinHttpReq.Send();
	    var jefline = WinHttpReq.ResponseText;
	    var jefitem = jefline.split(",",5);
	    jefitem[0] = jefitem[0];
            jefitem[1] = Math.round(parseFloat(jefitem[1])*100)/10000;
            ymd = jefitem[3].split("/", 3);
            jefitem[2] = ymd[1] + "/" + ymd[0] + "/" + ymd[2];
	    jefcol = "" + jefitem[0] + ", " + jefitem[1] + ", " + jefitem[2];
            outFile.WriteLine(jefcol);
//********************************************************************************
    // done with file and http
    outFile.Writeline("^"); 
    outFile.Close();
    // WinHttpReq.Close(); // wrong call..?
    return !error;
} // getPrices()

This script addition is only for a single fund, "Legal & General UK Index", but could be easily changed to a different fund and more funds added.

This "UK Fund URL" downloads Legal & General fund (L&G UK Index Trust (R) Inc - GB0005141709GBP) last price with date.

The .CSV file has the Symbol in Col 1, Last Price in Col 2 (in pence), Time in Col 3, the date in Col 4 (in MM/DD/YYYY format), and the price change (in pence) in Col 5. Before importing, Quicken requires the data to be processed as follows:

Conversion of the price to £'s
Conversion of date to DD/MM/YYYY
CSV file reorganised to show: symbol in Col 1, Price in Col 2, and date in Col 3

Someone with more programming skills than I have, would be able to modify the Script so that the UK funds could be specified in the .CMD file.

Thank you. Really nice.

I had one (self caused) problem - I had the script in a folder called Quicken Price Script, that was open in Windows explorer. Since the script is looking for any window that starts with QUICKEN, it was randomly failing by latching on to the explorer window. Renaming the folder fixed the problem.

Hi,
I tried your method to download share prices to Quicken 2004. prices come up in pence in Netstock which Quicken takes to be £'s and suddenly I'm very rich. Have you a way round this other than editing the quicken or "prices" values?

Thanks for your interest. I have done as you say and it works OK. I have also divided the number of shares by 100 so that the value as reported by Netstock is correct. Well thats all my millions gone in a day.
Regards

Sorry I am having trouble with this. Probably just me as not quite sure what needs changing. I have W7 Pro 64 bit.

Have downloaded files and put 'QImportP.wsf' and 'QImportP.cmd' into a new folder on my desktop called 'Shares for Quicken'

From reading the readme and .cmd file it looks as if all I needed to do was edit the .cmd file to have the list of my symbols in the section: set SYMBOLS and it starts set SYMBOLS="AOR.L,AU.L,

Instructions, to me, unclear but looks as if all should now work with just running the .cmd file though not sure as also mentions that must run under cscript. Not sure how to do that.

When run .cmd file then a cmd windows pops up and something happens but much too fast to see what though certainly a few lines of text.

Nothing else seems to happen and certainly no import into Quicken.

Not yet tried with funds or link in Quicken. Just great if can get to work from Start menu.

Thanks for all the work on this already and sorry if answer is obvious but not sure what else, if anything, I should do.

There is no .cmd, there is a .cmd.txt which should be edited, and then renamed - you may have already done that.
There is one more line to edit - WSFPATH. As the QImportP.cmd comment says, you will likely need to change all three lines to set SYMBOLS, ARGUMENTS, and WSFPATH. Add /div100 to ARGUMENTS if you find UK prices off by a factor of 100.

Then, to test, start a console (cmd.exe), go to the folder you created and run
QImportP.cmd
it will then show all its output, and error messages.

If no error, check output file - QImportP.csv.
Search for it, or look in %TMP% folder.
If that looks ok (has quotes you need), then it is all working.
Just start Quicken, create a shortcut to .cmd file, and run it to get quotes and import the .csv data.

I liked this script but after updated to Quicken 2011 H&B Release 4, I got the following Error 2: Unable to activate Quicken Application - not sending keys.

I'm running W7 x64.

PS: I truly agree with comment 34: this link deserves a link to Paypal.

I was guy who got this working in post 34. Have Q2004 deluxe in UK on W7 Pro 64bit. Works great. Even opens Quicken to import data (though that not really a bonus).

Still get that odd error with some symbols though date? moving forward and now 29th Oct; even though I am only looking to go back 7 days

Hello - thanks for your reply.

I got your advise and changed the script (well, at least I tried) and for now works again!
This script helps me to get quotes for Brazilian Stocks Exchange (Bovespa) via Yahoo. Unfortunately Intuit hasn't a tool able to perform this action and this great script deserves a way for donation!

There a lot of symbols still in the previous comment - isn't only GPOR.L the problem? And the only error is this URL:
http://ichart.finance.yahoo.com/table.csv?&s=GPOR.L&a=11&b=06&c=2010&g=d

I see the same error, but the .csv file looks fine - you mentioned an error and wrong date - can you print the exact error message?

Even though historical (past week) rates for GPOR.L are not available using the Yahoo API call, it does get the latest rate.

As for Google API - that is for personal portfolio management, it does not seem to offer the lookup capabilities that Yahoo does - so, can't use Google API.

Those URLs just explain Google API - which is a portfolio based API, not a general stock lookup. Most comments in first URL actually mention Yahoo APiIand don't answer the google question! Additionally, the Google API requires developer keys etc, so may not be very easy to use by individual downloaders of this tools.
As for
> a=10&b=26&c=2010
URL lookup - the a= part is MONTH-1, i.e., 10 is not October, but actually November. That is how Yahoo API is defined, month is from 0 to 11. A search showed this link with some descriptions: http://code.google.com/p/yahoo-finance-managed/wiki/csvHistQuotesDownload

I had the same error and when I opened up regedit and searched for the related key, it wasn't there. In fact, there wasn't even the Intuit folder listed in HKLM>Software node. I right-clicked on the HKLM>Software node and added the Key "Intuit". Next, I right-clicked on the Intuit key that I just created and added the key "Quicken". Once that was done, I right-clicked the Quicken key and added a String value called ExePath. The value of the ExePath should be the path to your Quicken executable (qw.exe); mine was "C:\Program Files (x86)\Quicken\qw.exe". I added that as the value (in quotes because of the spaces), closed the BillMinder gadget and then re-added the BillMinder gadget by right-clicking anywhere on the desktop, selecting Gadgets, right-clicking the BillMinder one, and selecting Add.

I am having trouble getting this to work with Quicken 2009. Can you help walk me through this?

I can't get it to import data just the regular way. Must be something peculiar to Q2009. Thanks

I am not sure I understand - the QImport.wsf script, run as described in the README, always creates a .CSV file in %TEMP%.
So no change should be required to that. It downloads, and then tries to automatically load that file in Quicken. Which step is not working? The first one creates the .csv file. The second one may fail for various reasons - too complex to debug remotely, I'm afraid. Windows + Quicken interaction.

Yes, QImportP.cmd is the right file to edit.
But if there are multiple copies, maybe it is running a wrong one.

Edit your QImportP.cmd and add a /v:3 arguments - as shown in the comments in there, to
the "set ARGUMENTS=... " line

Then start a "Command Prompt" and run "QImportP.cmd" - may or may not need full path.
It will show some details of what it is running and you check it is running with all the symbols you need. And then look at the .csv file it created - if the symbols were correct above and it could download the quotes, they should be in the .csv file.

Thank you for your program. It has been working as described. However, when I try to download option data I do not get any information. For instance, I put AMZN140118P00220000 (this is the symbol for a specific AMZN option and it retrieves a quote if entered in yahoo finance) in my list of symbols I do not get any data in the temp QImportP.csv. Do you know is this a limit of your program, such as limit on ticker characters or something with yahoo finance. Thanks for any insight.

I guess they do not support it. With my limited computer knowledge I was just thinking that if you could get an option quote at the same place as a stock quote that it should be able to pull it into a csv file.
Thanks