Version 3 of my PocketSense webpage addon that incorporates Cal’s auto-OK script

November 19, 2011 at 11:07 AM · Filed under Microsoft Money

Version 3 is now available! No batch file needed.

Version 3 of ameridan's OFFLINE webpage addon to Money

Although I developed this webpage (click image to enlarge it) to invoke from within Microsoft Money, I find it most convenient to click on a shortcut to the webpage from my desktop instead.   I know I haven’t posted anything on this blog for a while, but that is primarily because PocketSense is working so well for me in supplying OFX updates to my Sunset edition of Microsoft Money.   The main reason I am posting an updated version of my webpage is to accomodate Cal’s python script Popdown2.py (originally submitted by George -  thank you George!) that automatically OKs the import and error messages that appear while the OFX files are processed by Money. You will not need to locate and download this python script file, as it is included in the download package for the webpage addon. NOTE: If Cal updates this file (he mentioned working on Popdown3.py), save it as Popdown2.py to keep the links working. Also, you do not need to use or modify any batch files with this webpage (nor can batch files be invoked from a webpage).

If you would like to be able to run your Offline update scripts (PocketSense) from within your Microsoft Money program while also viewing the new quotes.htm file that is produced everytime you update your quotes, I’m sharing the new page (along with easy installation instructions) that I’ve developed for just this purpose. Since the Money GUI is really just a customized browser, this is probably the only way modules can be added to the program without hacking into the source code. I would also like to point out that everytime the quotes are updated throughout the day, the quotes.htm page is updated, even though the newer values are ignored within the Money program. And this page will also show Last Closing Price as well as Percent change in price since the last closing price! Thanks Robert!

To greatly simplify installation (it was confusing if your PC setup didn’t happen to be setup just so), I’ve created 4 different versions of the webpage for you (2 for WinXP and 2 for WinVista and Win7) and you’ll simply use the one that works properly.

To install…

1. Go to the folder on your hard drive that you’ve installed PocketSense into
2. Download my webage add-in and extract the Images folder, popdown2.py and the 4 htm files into this same folder as your scripts
3. Right click on getdata.py and select Create Shortcut
4. Right click on setup.py and select Create Shortcut
5. Right click on popdown2.py and select Create Shortcut
6. Click on one of the 4 webpages (and don’t rename them): GetOfxDataXP(1).htm, GetOfxDataXP(2).htm, GetOfxData7(1).htm or GetOfxData7(2).htm which will open it in your browser. Although all four versions look the same, only one will have links to getdata and setup that actually work. If you want a detailed explanation of the differences, see the 3/19/2010 notes in the Version 1 Blog: http://microsoftmoneyoffline.wordpress.com/2010/02/25/webpage-add-in-run-pocketsense-from-within-the-money-program/
7. If the link(s) to GetData.py and Setup.py work, then Copy the address from the Address Bar (Highlight it and right-click and select Copy). B1inUK offers this tip for WinVista and Win7 users: You may have to Right-click the htm file, select Properties and click Unblock at the bottom to allow the links to work.
8. Paste into your Desktop if you’d like to access the webpage from there
9. Open Money and Paste that address (or type the full path to the htm file) into Money’s address bar ( as an example, my path is: C:\Documents and Settings\Dan’s\My Documents\Microsoft Money\Python Scripts\GetOfxDataXP(1).htm ) and hit Enter (or click on the GoTo button).

10. Select Favorites, Add to Favorites, and type in a name for your Favorite page (like GetOfxData), then click OK



11. You’re done; whenever you wish to access the scripts from within Money – either click on Favorites, Favorite Web Sites, and then GetOfxData OR select the file in the address bar and hit Enter (or the GoTo button)
12. ENJOY Microsoft Money OFFLINE!!
[ADDED 3/26/2011] I prefer the font size in the quotes window to be somewhat smaller and this is how that is accomplished: In quotes.htm the font size within the quotes table is controlled in line 64 of rlib.py (change 16px to perhaps 14px). I also prefer the font-size for the comments at 10, rather than 13, which you can change on line 57. The next time you run PocketSense, the generated quotes.htm will reflect the changes you’ve made and and be sure to make a backup copy of rlib.py after you’ve tweaked it, so that you’ll be able to apply your changes after downloading updates in the future.

-ameridan

Permalink