[This page is the old archived posting. The current page is here: /tech/import-prices-script-for-quicken/.]
Get the best deals on Quicken Windows CD Computer Software when you shop the largest online selection at eBay.com. Free shipping on many items. QUICKEN DELUXE 2020 FOR WINDOWS & MAC, CD IN BOX, 1 YR SUBSCRIPTION, NEW IN BOX. Quicken WillMaker Premium Home & Family 2017. Top Rated Plus. Free shipping. Platform: Mac. Or Best Offer. A free download of Nolo’s bestselling book Nolo’s Encyclopedia of Everyday Law, a $34.99 value, when you register your software Plus, prepare cash flow, sales revenue and profit and loss forecasts, and use dozens of sample letters and policies, including collection and loan request letters.
Quicken is a package that works pretty well, but the manufacturer has a tendency to periodically block functionality.
For example, Quicken 2006 has been unable to download updated stock prices since April 2009. Quicken 2006 itself installs on even the latest Windows 10 (2016) just fine. [As an aside, it is just amazing that Windows 10 has kept compatibility alive for old software - Quicken 2006, as well as the SendKeys method used by the script below! Kudos to Microsoft!]
There is certainly no technical decision to disable automatic stock price updates - it is just a marketing push, so make people upgrade even if they do not desire to move to a new version.
Quicken does have a manual 'Import Prices' command seen when viewing the Portfolio. Therefore, it is not too hard to write a script that will download current prices, and import them into Quicken.
It is a .WSF file, a Windows Shell Scripting program. It has been tested to work on Windows XP, Windows Vista as well as Windows 10 (2016), and is available in source code form.
The script looks up historical and current prices for a list of symbols, and stores the prices in the format Quicken needs. Optionally, it can automate the import of the prices in Quicken by using Windows automation SendKeys method.
Archive with script and readme: QImportP-0.6.0.zip [2015-04-09]
Previous release: QImportP-0.5.0.zip [2009]
And here are links to look at the key files: QImportP.wsf, the README, and the ChangeLog file.
Prices are looked up using the Yahoo Finance web site. Quicken manual import prices only accepts date and price for a symbol, it cannot import volume and other data.
The script does try to automate loading of the price data into Quicken, but the mechanism of using SendKeys is very fragile, it may not always work - keys may get to the wrong window, or at the wrong time.
Version 0.3 of this package added support for non-US users, based on the code given in a comment (#5535), the /dmy and /div100 options provide that support. From what has been reported elsewhere on the web, shares and mutual fund price downloads in UK are priced differently - shares in pence, funds in pounds (or vice-versa?). So QImportP provides the /div100 option which can be used when needed.
The QImportP package is placed into Public Domain.
Product Description
You don’t need an attorney to start and run a business — most of the legal work involved simply requires reliable information and the right legal forms. With Quicken Legal Business Pro, you’ll get everything you need to get the job done.
Completely updated to reflect the latest laws and regulations of your state, Quicken Legal Business Pro provides:
Plus, prepare cash flow, sales revenue and profit and loss forecasts, and use dozens of sample letters and policies, including collection and loan request letters. Quicken Legal Business Pro brings these six Nolo bestsellers together in one easy-to-use software package:
With over 100 legal forms, you’ll have access to the documents you need, when you need them. You can also take notes, create bookmarks, and read real-world examples of situations you’re likely to face.
Need more details? Here’s a deeper look at what you can do with Quicken Legal Business Pro:
Plan for Success
Select the best structure for your business, obtain licenses and permits, buy or sell a franchise, file required documents, and minimize the chances of legal disputes. Figure out if your business idea will make money and present a comprehensive plan to potential investors.
Manage Taxes
Identify deductions allowed by the IRS, write off long-term business assets, maximize retirement funds, and minimize the chance of an audit.
Create a Business Plan
Figure out if your business idea will make money, find potential sources of financing, prepare cash flow and profit & loss forecasts, determine your assets, liabilities, and net worth, create a marketing and personnel plan, and present a comprehensive plan to potential investors.
Build Your Team
Hire workers, develop sensible personnel policies, supervise independent contractors, communicate effectively with employees, minimize the chance of employee lawsuits, and legally terminate workers when necessary.
Get Financing
Identify the best prospects for loans from a bank or loved ones, understand the legal and tax issues of borrowing money from family and friends, determine the best structure for each loan, draft a loan request letter, receive guidance on the best way to pitch your loan requests, protect your lenders, and deal with necessary documents, such as promissory notes.
List of forms:
Buying or Selling a Business
Contracts for Goods and Services
Corporate Minutes and Consents
Forming a Business
Hiring Workers
Leasing Space
LLC Minutes and Consents
Managing Finances
Buying and Selling Real Estate
System Requirements Pentium 400 MHz • Microsoft® Windows® 10, Windows 8, Windows 7, or Vista • 510 RAM or higher • 75 MB (plus 500 MB to 1.5 GB for Microsoft .NET 4.0 if not already installed) • 800 x 600 (1024 x 768 recommended; with 16-bit color) • CD-ROM Drive: 2x speed • Internet Connection: 56 Kbps modem required to access online features • Printer: Any printer supported by Windows 10, Windows 8, Windows 7, or Vista • Software: Microsoft Internet Explorer 7.0 or higher; Adobe Reader; Spreadsheet Program Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |