[UPDATED link 1/20/2011 - the author (Hung Le) updated the Java app and the link now points to the updated version. This is an ideal alternative for those that only need to update quotes (no Account Statement updates) and don’t wish to install Python scripting]
The first comment I received on my new Blog site is from Hung Le and he offers a Java app (hleOfxQuotes) he wrote to obtain quotes from Yahoo! and output them into an OFX file for import into Money. If you already have Java installed, download the latest Release version of the app , save it on your PC, and just click on it.
The program is easy to use and works great! The first time you import the file, just link it to a Dummy Investment Account you can create on the spot (don’t link it to a real account, since the download shows you own zero (0) shares of each so as to not have any effect on your net worth). If you mess this up, see this Blog Page to fix the linked account.
NOTES:
- The other accounts that actually contain these stocks and funds will automatically update, but you will not see a daily change value as you do with online updates.
- The first download update of the day takes hold for that date, so run this after 6 or 7 pm EST if you’d like the quotes to be “closing bell” values, especially regarding mutual funds (stock values don’t have to be computed).
- If you’d like currency exchange rates (although they work a little differently than the MSN method) or Market indexes, the method I’ve discovered and blogged here works with this app too!
- [added 2/4/2011] Apparently the newer test version(s) also work for Options and foreign exchange investments (see comments below for more)
- If you’d like quotes from other non-USA exchanges and other countries, the method I’ve discovered and blogged here works with this app too!
- Keep in mind though that the Yahoo interface is a “work around” intended solely for tracking things that aren’t held in an OFX-enabled account. If your investments are held in accounts for which you have an OFX download option, that may be the prefered method.
Thank you Hung Le!
-ameridan
For those of you that are curious as what an OFX file looks like, I’m publishing the file generated with the hleOfxQuotes app requesting quotes for Ford stock and the Dow Jones Avg this evening:
<?xml version="1.0" encoding="UTF-8"?> <?OFX OFXHEADER="200" VERSION="200" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="3379335459138709546"?> <OFX> <SIGNONMSGSRSV1> <SONRS> <STATUS> <CODE>0</CODE> <SEVERITY>INFO</SEVERITY> <MESSAGE>Successful Sign On</MESSAGE> </STATUS> <DTSERVER>20100213033831</DTSERVER> <LANGUAGE>ENG</LANGUAGE> </SONRS> </SIGNONMSGSRSV1> <INVSTMTMSGSRSV1> <INVSTMTTRNRS> <TRNUID>3965303700877776334</TRNUID> <STATUS> <CODE>0</CODE> <SEVERITY>INFO</SEVERITY> </STATUS> <INVSTMTRS> <DTASOF>20100213033831</DTASOF> <CURDEF>USD</CURDEF> <INVACCTFROM> <BROKERID>le.com ofx quotes updater</BROKERID> <ACCTID>0000-0001</ACCTID> </INVACCTFROM> <INVPOSLIST> <POSSTOCK> <INVPOS> <SECID> <UNIQUEID>F</UNIQUEID> <UNIQUEIDTYPE>TICKER</UNIQUEIDTYPE> </SECID> <HELDINACCT>OTHER</HELDINACCT> <POSTYPE>LONG</POSTYPE> <UNITS>0</UNITS> <UNITPRICE>11.12</UNITPRICE> <MKTVAL>0.00</MKTVAL> <DTPRICEASOF>20100213033831</DTPRICEASOF> <MEMO>Price as of date based on closing price</MEMO> </INVPOS> <REINVDIV>Y</REINVDIV> </POSSTOCK> <POSSTOCK> <INVPOS> <SECID> <UNIQUEID>^DJI</UNIQUEID> <UNIQUEIDTYPE>TICKER</UNIQUEIDTYPE> </SECID> <HELDINACCT>OTHER</HELDINACCT> <POSTYPE>LONG</POSTYPE> <UNITS>0</UNITS> <UNITPRICE>10,099.14</UNITPRICE> <MKTVAL>0.00</MKTVAL> <DTPRICEASOF>20100213033831</DTPRICEASOF> <MEMO>Price as of date based on closing price</MEMO> </INVPOS> <REINVDIV>Y</REINVDIV> </POSSTOCK> </INVPOSLIST> </INVSTMTRS> </INVSTMTTRNRS> </INVSTMTMSGSRSV1> <SECLISTMSGSRSV1> <SECLIST> <STOCKINFO> <SECINFO> <SECID> <UNIQUEID>F</UNIQUEID> <UNIQUEIDTYPE>TICKER</UNIQUEIDTYPE> </SECID> <SECNAME>FORD MOTOR CO</SECNAME> <TICKER>F</TICKER> <UNITPRICE>11.12</UNITPRICE> <DTASOF>20100213033831</DTASOF> <MEMO>Price as of date based on closing price</MEMO> </SECINFO> </STOCKINFO> <STOCKINFO> <SECINFO> <SECID> <UNIQUEID>^DJI</UNIQUEID> <UNIQUEIDTYPE>TICKER</UNIQUEIDTYPE> </SECID> <SECNAME>Dow Jones Industr</SECNAME> <TICKER>^DJI</TICKER> <UNITPRICE>10,099.14</UNITPRICE> <DTASOF>20100213033831</DTASOF> <MEMO>Price as of date based on closing price</MEMO> </SECINFO> </STOCKINFO> </SECLIST> </SECLISTMSGSRSV1> </OFX>
[UPDATED 1/29/2011] There are also beta test versions posted on Hung Le’s site as well, for those wishing to experiment further, that support two additional quote sources: ft.com and Google Finance Portfolio. Hopefully, those will give our UK/Canada users additional sources for their quotes. He has also added a new mapper.csv function. Please read the Help files (Readme.txt) carefully.
In your current working dirctory, create a file named mapper.csv. It is a comma-separated-value, you can use Excel to create it but remember to save as CSV file.
mapper.csv MUST have the following header (case-sensitive, make sure spelling is correct)
MSMoneySymbol,QuotesSourceSymbol,IsMutualFundAdd row as needed
. First column: the symbol for a stock/fund in your MS Money
. Second column: the symbol that can be find in your quote source
. Third column: true if is a mutual fundLet’s say your ft.com’s results.csv has price info for BBT:NYQ. But in MS Money the same stock has symbol BBT and this is a
stock, you would add row
BBT,BBT:NYQ,FALSEYour results.csv use BBT:NYQ (QuotesSourceSymbol)
The generated *.ofx SHOULD have BBT (MSMoneySymbol)
added by ameridan from Hung Le’s comment 1/31 on Microsoft Money forum:
For currency issue: currently I do write out the OFX currency tag per security but I have no clue if MM will honor it[SECID]
[UNIQUEID]EZJ:LSE[/UNIQUEID]
[UNIQUEIDTYPE]TICKER[/UNIQUEIDTYPE]
[/SECID]
…
[CURRENCY]
[CURRATE]1.00[/CURRATE]
[CURSYM]GBP[/CURSYM]
[/CURRENCY]I set CURRATE to 1.00 right now but I have code to look up the exchange rate (using the pseudo-symbol USDGBP) but I have not put the code in yet because I did not want to muddle the water right now for the UK folks who are still having problem getting MM2005UK to update the price. Obviously, we can also convert from GBP -> USD before writing to *.ofx.
I want to give Google Porfolio a plug here regarding how it handles currency. For Google Portfolio, you can set the porfolio base currency and Google will report the position market value in BOTH: “native” currency and portfolio based currency. For example, let say I set my base currency to GBP and have a position of AAPL, Google will report market value in both USD and GBP. So that will take of currency conversion outside OFX generation tool. Currently hleOfxQuotes.jar can fetch data from Google Portfolio and will:
1. preserve shared count (instead of using 0 count) // this is mostly to see if it will help the UK folks
2. using “native” currency // since I don’t know how multi-currency actually works in MM
But it is fairly easy to add a couple check boxes to let user choose what he/she wants.
FYI, I am back to using MM on daily basis now (hence more active in updating hleOfxQuotes.jar). I gave Quicken a college try but things are not working out:
. I am used how the UI works and could not really overcome that
. In Quicken, if I hide the reconciled transaction, the balance is displayed certain way that is just too confusing.
I don’t mean to bash Quicken here but just a note to say that I am back to the “right” side
.
The comments below are only the most recent – if you wish to review older comments, there is a link near the bottom of the page to do so.
Hung Le said
Dave L,
I realized now that it should not be randomized. Otherwise, when current value is less than last value, no new “add transaction” is added.
In fact, in latest version, I have deprecated “Randomized” in favor of “Incrementally Increased”
http://code.google.com/p/hle-ofx-quotes/wiki/Build_20110226_001
The unit of increment is set at .001 (and will wrap around at .999). I can externalize those values to something that you can set.
Dave L said
Hi Hung Le and thanks for the reply.
Further question. Why does the unit need to increment at all? Why can it not remain at the same value. If my understanding is correct (no guarantee!), The statement is giving a position update. If the dummy account contains the same units as are given in the position update, wouldn’t MM just record the new price?
Hung Le said
For MM Sunset, MM behaves as you had expected: price is updated, MM update all matching security across all accounts.
BUT .. for MM2005UK, MM does not have that way. Base on obvervation made by others (my recollection: Veronica brought this up first): by forcing an “add” transaction, we get price update. Otherwise, price is NOT updated.
Hung Le said
I’ve added an new “issue” for “Incrementally Increased Share Count” unit.
http://code.google.com/p/hle-ofx-quotes/issues/detail?id=21
David K said
Nice software, thanks Hung Le.
Seems like Microsoft Money 11.0 has now stopped updating UK fund prices after 3 May 2011 though .L share prices are still being updated.
I tried the software but could not get it to get a fund price.
eg. Yahoo finance recognises IP Global Smaller Companies Inc as GB0033053264.L so it is there in principle.
Any idea if this is possible?
David K said
As of 16 Nov 2011…
I stand corrected. Microsoft servers are still updating both share prices and fund prices, share prices daily but fund prices less regularly. There is sometimes a few days lag in the fund prices but MM gets there eventually. So for ‘just watching’ assets MM is still working tolerably well.
Hung Le said
Hi David K,
Please see: http://code.google.com/p/hle-ofx-quotes/wiki/UKUsers
Hung Le said
Over at PocketSense, George posted some interesting code to auto-click the “Import Dialog”. It looks straight-forward so I think I can add it fairly quick. Kudos to George for doing the leg works.
Want to see of level of interest before I go ahead and spend the time (I am quite busy currently with work).
http://pocketsense.blogspot.com/2011/04/new-production-version-of-money-scripts.html?showComment=1305329004696#c6775971114926198565
ameridan said
Hi Hung,
Just got back from vacation in Japan to visit my daughter and caught George’s message too. Personally, I don’t think incorporating the code into your program would add as much value (as the quotes simply download into one Dummy account, so it would save only one click) as compared to incorporating the code into PocketSense, which would be GREAT as it would save me around 13 clicks!!!
I think you’d enjoy the programming challenge though
Hung Le said
Hi Dan,
I was half-way done with the Java codes so I went ahead and implement it in hleOfxQuotes. I released a new build with that feature: http://code.google.com/p/hle-ofx-quotes/wiki/Build_20110515_001
The good news is that the functionality is general so that PocketSense users can use hleOfxQuote as a generic Import-dialog auto-click.
. Start hleOfxQuotes (just need to start up. Don’t need to do anything else)
. Start PocketSense to update
. hleOfxQuotes will auto-click any Import dialog
. Quit PocketSense
. Quit hleOfxQuotes
I will look into the Python codes now.
Hung Le said
One more thing:
. the latest has support for downloading statements. I’ve been using it for a while to download from 6 FIs (bank, credit card company, brokage).
. It still need works on helping user to get started: creating new FI, account … but the back-end engine (network, OFX generation) is solid.
. I am putting it out there for in case others want to try and give feed back.
Best,
George said
Hung…
regarding the Auto-click. Some updates that I’ve been running with in my own tool since after my original posting over on PocketSense blog.
FindWindow(TEXT(“MSMoney Frame”), NULL) – Is Money actually running?
FindWindow(L”#32770″, “Microsoft Money”) – dialog that appears when Money is not running during import.
Respond with:
wParam = 7; // BN_CLICKED
lParam = 90552L; // IDNO
PostMessage(hwndMoneyDlg, WM_COMMAND, wParam, lParam)
I look for these if the test for Money running says it is not.
And…
FindWindow(L”#32770″, “Import a file”) – the original dialog for import.
Thanks for integrating this & helping people automate this. I’ve had pretty good luck automating PocketSense as a scheduled task everyday with autoclicking enabled (albeit, using my C++ version).
Hung Le said
Thanks George. Very helpful. If you don’t mind, can you “spy” into the following case:
. For first time user who does not have the “Dummy” account yet. An import dialog will be prompted to allow user to create (or choose) an account. Current code matches this dialog and will auto-click: not what we want.
Can you see if we can distiguish the two “Import a file” dialog:
. First time case: to choose to create Dummy account
. Normal case: OK to auto-click
Best,
ameridan said
Hung – that feature works great in conjunction with PocketSense. Thank you!!
ameridan said
Aaah, now I see why you added the auto-click code.
I see you have a Statement tips page and some examples…
but it isn’t clear how you do several institutions and create subdirectories.
Is this data typed into the Properties page? Are you prompted for acct #s, etc after the download buttton is clicked?
Guess we’ll need a screen dump example with 2 institutions shown.
Hung Le said
I’ve added a sample fi.zip file and additional notes at http://code.google.com/p/hle-ofx-quotes/wiki/Download_Statements_Tips. Look for section “Quick Start”
Can you give it another try. Appreciate your feedback.
Best,
ameridan said
Will do as soon as I can. Will review the notes too.
Hung Le said
I’ve added some notes on equivalent concept/settings between sites.dat and fi.properties on the “Download Statments” side of things:
http://code.google.com/p/hle-ofx-quotes/wiki/Sites_Dot_Dat_vs_fi_properties
ameridan said
There are enough details to setup Statement downloads now, and although got Discover Card working, the transactions need to be scrubbed as PocketSense does. I ended up deleting all of the newly downloaded transactions.
I also setup VALIC (investments) using my PocketSense data, but it errors out. I’ll try some other accounts soon as this all looks promising!
Nice touch being able to edit within the Properties screen and Save, but I had to use the keyboard shortcut (Ctrl-S), as I couldn’t find the Menu option to Save.
I see you have Money version 17 as the default requestor, rather than Quicken 18. Not sure whether some institutions are rejecting Money requests now or not.
Hung Le said
The “Save” menu Item is in the
Properties panel -> Popup menu
Hung Le said
. Re: appId/appVersion: I will add it to my todo list. Will expose them through fi.properties file.
Hung Le said
Re: Discover scrubber. Will add it to TODO list.
Hung Le said
Re: Discover’s scrubber.
I’ve read http://sites.google.com/site/pocketsense/home/msmoneyfixp1/Bad-Statements and I think I understand the issue as well the “fix”.
What I don’t understand is how this error does not show up in the “normal” download by Microsoft Money (when MM issued the download internally). I assume the same error would also have occurred for Quicken also. Strange!
Does DiscoverCard web-site provides a way to do manually downloading? If yes, can someone try to do a couple of different download throughout the day and see the “bad” FITID exists (different FITID for same transaction). If yes, we should log a bug with DiscoverCard. I know the chance that it will get fix is next to nothing now that MM is gone but DiscoverCard is clearly in the wrong here.
Hung Le said
I did some more reading and it appears that MoneyDance folks are having similar issue.
http://help.infinitekind.com/discussions/bugs/26-discover-card-downloaded-transactions-reappearing/
Quick summary: for Discover Card
. For recent transactions since last statement, FITID could change.
. For transactions that have been closed (statement), FITID is fixed.
I still don’t understand why this has not shown up previously when folks were downloading statement directly using MM.
ameridan said
Hung,
As I noted on Robert’s blog back in Feb 2010…
Money processed the online downloads a little differently – maybe they had their own little scrubber. They also weeded out the $0.00 transactions which I found annoying as that was how NOTES were delivered. By the way, when using PocketSense, the OFX servers think that Quicken is requesting the transactions, not Money. In the interest of not disturbing the ability to gather the OFX transactions, I think it would be better not to register a complaint with Discover
Hung Le said
I see. I will stop my blabbering and do an equivalent of scrubber.py.
ameridan said
Regarding the Save occuring in a popup menu, I never get a popup. I noticed an error log in the folder that might be related:
Regarding the app / app version, you could just change the default for now (assuming that works for your downloads as smoothly as “Money 17″)
Hung Le said
Hmm … I like to chase down the missing popup menu. It should look like this:
. http://www.le.com/~hle/out/hle/2011_05_19/2011-05-19_071827.png
The error above, are they in file named hs_error_pidXXX.log? If yes, they are error from the JVM. Can you log a bug at http://code.google.com/p/hle-ofx-quotes/issues/list and attach one of the latest hs_error_pidXXX.log.
Thanks,
lull said
I downloaded the hleOfxQuotes program with Java, then I put in some sample ticker symbols, they came up
When I asked it to import to MS Money, it wanted a file extension, I linked it to MS money 2006, now it says that ofx is not a valid win 32 application. What do I do now.
ameridan said
lull
Try right-clicking the ofx file and select Open with.. > Choose program > and select “Microsoft Money Import Handler” (not Money itself) and also check the box “Always use this program to open this type file”. This should fix the file association for you.
Hung Le said
BUG ALERT:
The latest feature to auto-click the import dialog has a side effect that will cause problem for first-time users. The tool will auto-click the dialog that prompts user to create the ‘Dummy’ account. Thus bypassing the creation of the ‘Dummy’ account.
Work-around: turn off the auto-click feature:
Tools -> Import dialog auto-click -> uncheck the check mark.
Then try importing again.
lull said
Ameridan
after I download OFX quotes with the java app I save the ofx file, then when I try to open it ask which program to open with. I do not have Microsoft Money Import handler as one of my choices. By the way, yes MS Money was running at the time.
What do I do now?
Hung Le said
My Import Handler is at:
C:\Program Files\Microsoft Money Plus\MNYCoreFiles\mnyimprt.exe
ameridan said
lull,
sounds like you may have tried Moneysense or another program (Quicken?) that changed the association. Think that was covered in the microsoft money forum, but first try to point to the path that Hung mentions.
John Hennessey said
For UK Users, so far as I can tell, online price updates are still working…I have online price updates from the last working day of last week.
ameridan said
Hung,
If I right-click in the properties screen I get the popup you mention, so I guess I’m good in that regard. I guess I thought you meant it should popup as soon as a change is detected.
I’m logging the errors on your site today for you as they only started with the latest build – unless that is because you just activated error logging in this build
Hung Le said
Thanks. I will look into the JVM error you logged.
lull said
Umm, guys. My MS Money was working just fine getting quotes. Two days ago, I start getting quotes, but the total value change for the mutual funds is blank. it does work for individual stocks. What gives.
Al said
On the question of quotes from non-USD based exchanges, I did a simple test and it appears to work. In the ofx file generated by the java script, there is a line
[edited by ameridan to author's intent, I hope]
By changing USD to, say, HKD, the quote retrieved from Yahoo HK is accepted by MM into the dummy account set up in HKD. The quote is reflected properly in the “real” account. I use MM 2007.
A wish list for Hung Le to think about:-
1) provide an input file to indicate what currency the quotes are in,
2) provide the ability to read in a file of symbols for people who need to retrieve quotes in more than 1 currency.
Hung Le said
Hi Al,
I just added a wiki page on current state of how currency is being handled
http://code.google.com/p/hle-ofx-quotes/wiki/Currency
Can you take a quick look and see if that fits your need.
Best,
Al said
Hi Hung,
Thanks for the quick reply.
I’ve gone over the wiki page and have no idea on how to create the profiles. You said:-
Add a new concept call Quote Profile to make it easier to switch
OFX account id
Currency
User can choose a Quote Profile from file menu
File -> Quote Profies -> USD Proffile
File -> Quote Profies -> CAN Proffile
Input to populate above menu come from *.properties file under directory profiles/. Property file will have key-value pair looking like this …….
I tried File -> Open Quote Profiles and nothing pop up. Where is the *.properties file? I am using the app just for downloading quotes, not statements.
BTW, I was using the 20110120 version when I posted the question. I am now on 20110515.
Hung Le said
Al,
. In the same directory as the *.jar file, create a directory called “profiles”.
. In directory profiles, create a file name “hkd.properties”, add content
name: HKD Profile
currency: HKD
. Start tool and you should see a new menu in
File -> Quotes Files -> HKD Profile
Al said
Thanks,
Will try it later.
lull said
Wont someone tell me if they are still receiving quotes for mutual funds, the percent change today? mine seem to have no percentage change, and therefore no change in total value. Stock prices still work thank you
Al said
Tried out the Quote Profile feature. I would suggest two improvements:-
1) Currently, the OFX A/C ID in the profile is not carried over to the app, i.e. if the A/C ID is USD b4 opening up the profile, and my profile specifies HKD, USD will remain. I have to go in manually and change the A/C ID. Have what is in the profile replace the one in the app.
2) It will be more useful if the I can put the symbols I want in the profile and when opened, they will be “read in” saving the extra step of pasting in the symbols from another file.
Lastly, a big thank you for providing this program. It allows me to go back to MM and junk Quicken. If anyone knows of a way to convert the investment transactions from Quicken 2010 to MM 2007, please give me a shout. I will be forever grateful.
ameridan said
Al,
Regarding getting your investment transactions into MM2007, aren’t you able to download your investment transactions directly from your brokerage? At Schwab you can go back 24 months and grab everything via OFX using Pocketsense (and probably with the java app too, but I haven’t tried that yet). Other brokerages allow you to download transactions right from their website – or were you manually entering everything?
Hung Le said
Al,
Two things:
1. A bug in my instruction, in the file.properties file ‘accountid’ should be ‘accountId’ (camel-case: Capitalized ‘I’)
2. In your #1, you mention A/C ID does that mean account ID, if yes. See above. The reason I ask is that you mention A/C and then USD/HKD.
. For currency, the keyword is ‘currency’.
. For clarity, I’ve upload a sample directory at
http://code.google.com/p/hle-ofx-quotes/downloads/detail?name=profiles.zip&can=2&q=
Can you give take a look at the sample files and see if it will clarify.
Best,
Hung Le said
One more thing, if you want your default currency to be HKD, you can just set it once via menu item
Edit -> Quotes -> Currency
The Profile features was more for someone who needs to quickly switch between multiple accountId/currency.
Al said
Hung,
The cap i did the trick. Thanks.
I have equities in USD and HKD. So, the ability to switch profile is helpful. Any likelihood of imbedding the stock symbols in the profile and “read in” when the profile is opened?.
ameridan,
I also have an account with Schwab. Unfortunately, mine is a corporate a/c and they do not have statement download for those a/c’s.
Hung Le said
Please log an issue at http://code.google.com/p/hle-ofx-quotes/issues/list so that we can track it.
For now, similar to the profiles directory, you can create a bookmarks directory in the current directory. In the bookmarks directory, create two files
USD.txt
HKD.txt
Start the tool, in the panel where you type in the symbols, click on right-mouse to bring up a popup-menu, there should be a new set of menu item called bookmarks->USD and bookmarks->HKD. Select one will populate the symbol list with content of that file.
Al said
Hung,
The Issues page is most useful and I see the Profile issue was already raised back in Mar.
Also tried the 6/26 version. The bookmark and the exchange rate features works great. Thanks.
Bryan Tollerene said
Hi Hung,
I am a stock broker and keep numerous Money files. Would it be possible to create an application that will allow Money to look for company names when you enter a symbol in the “Add Symbol” field at the bottom of the portfolio manager screen so users don’t have to type in the name of the company manually? Thats how it worked before MSFT discontinued service.
ameridan said
I think Hung’s Sunriise option will accomodate that for you once it has been refined (as well as most of the other related data), but i’m not sure that hleOFXquotes has that capability..
Hung Le said
Hi Bryan,
Are you asking for a stand-alone app (outside MSMoney) that can look up a symbol from a given “string”? Something similar to be able to enter “apple” to the textbox left of the “Get Quotes” button and see AAPL shows up in the list:
http://finance.yahoo.com/
Bryan Tollerene said
Hi Hung,
Once Money has launched I go to “Investing” then “Portfolio Manager”. Once in portfolio manager at the bottom right is an empty field to the right of “Add Symbol” where you can enter a stock symbol and a then a button to the right of that same field that says “Enter into Account”. It no longer functions since MSFT switched off the lights on Money – its really tedius to manually enter a stock which is what is required presently. TIA
Bryan
Hung Le said
Ah, I understand now. I have never use that text-box and button before so I was not aware that it is no longer working.
We can use sunriise to provide same functionality BUT the new tool will need exclusive access to the *.mny file (i.e: MS Money cannot open the same *.mny at the same time). Will that still work for your use case?
Bryan Tollerene said
Your talking to a non programmer – my knowledge of software code is close to zero. What are the ramifications of exclusive access to the *.mny file and only being able to open the same*.mny at the same time? I can tell you that I don’t use Money to try and conect to bank accounts – I only use it to keep track of investments – thats it. I have Money files for more many portfolios though. It would just simplify things for me greatly if I could enter a symbol there and the application would grab the company name for me and enter it into the portfolio. Is it possible to crack into the Money application or write an application that would crack into it and allow that “Add Symbol” field to grab data from some other source rather than MSFT?
Hung Le said
Hi Bryan, “Is it possible to crack”, I am afraid is the answer is “no”. From what you describe I think my idea of sunriise will not help either since it will just as inconvenient. You will have to
. stop MS Money (or open another *.mny file such as sample.mny)
. start the “new” tool, open you *.mny file. Enter new stock symbols.
. Start MS Money (or re-open your *.mn file)
Best,
Bryan Tollerene said
Hi Hung,
Apologies if this has already been asked. I want to update the values for an index specifically the Dow Jones (^DJI) the Nasdaq Composite (^IXIC) and the S&P 500 (^GSPC) but if I use the symbols utilized on Yahoo finance for those indexes your application appears not to be able to accomodate them. TIA
Hung Le said
Bryan,
^IXIC and ^GSPC and should work: you should see a the updated price in the bottom window. I just tried.
Yahoo does not appear to return data for ^DJI via the stock quote service (public API) that Yahoo is currently providing. Look like there is a way to get price for ^DJI but it will take a bit of work. Please log an issue at http://code.google.com/p/hle-ofx-quotes/issues/list so that we can track it.
Please note that MS Money already has existing symbols for those indexes: $INDU (Dow Jones), $COMPX (Nasdaq composite), $INX (s&p 500) so you will have “reconcile” this difference:
. either user a mapper.csv file to indicate that ^IXIC is really $COMP
. or when MS Money prompted you that first time you import a *.ofx with quote for ^IXIC that you chose that it is an existing security.
ameridan said
Bryan,
With Yahoo, simply use the symbol INDU for Dow Jones quotes now.
Regarding the “tedious manual entry”, are you referring to method Work with Investments > Set up a new investment while in Portfolio Manager? That doesn’t seem that bad – maybe you are using a different method?
You would only need to enter the investment name as Money keeps track of the symbol independent of the symbol shown in the Symbol column when you first match up the quotes.
Hung Le said
Thanks ameridan. I document the info here: http://code.google.com/p/hle-ofx-quotes/wiki/Index_Symbols
Hung Le said
A new build. Added feature to download historical quotes from Yahoo. See: http://code.google.com/p/hle-ofx-quotes/wiki/Build_20111104_41
Mr. Money said
Just tried the quotes download. Work fine with Money Sunset.
Tried it with Money 2004 – I’m able to import the statement and view the prices, but nothing is updated. Tried with a quantity of 0 and 1 via the add transaction, but still nothing. Wondering if anyone has discovered a way to have the quote import work properly with the version.
Mr. Money said
Results of additional testing on Money 2004
1) If I edit the OFX file and change a quantity from 0 to 1 and then import – I get a message that the statement and file quantites are in error – do I want to adjust. If I say no – then the prices are not updated. If I say yes – then the investment quantity is added and the price is updated. I can delete the line entry that was added, and the price update is retained.
2) If I add a quantity of 1 share to the file and then import a non-modified ofx file – I get a notice that the statement and file quantities do not match. Do I want to adjust. If I say no, – then the prices are not updated. If I say yes – then an adjustment line is added bringing the quantity to zero and the price is updated. If I delete the adjustment and return the quantity to 1, the price is updated and the file is ready for the next days import.
3) If I modify the ofx and change the qty to 1 and add 1 share to the investment in the file – then the statement and file are in balance – I get no warning message – and the price is not updated.
Thus, it appears that the import works only when the ofx statement and file quantities are different and an adjustment is authorized. If the quantities are equal then no price update is made. If no adjustment is authorized and the descrepency allowed to stand – then no price update is made.
I much prefer the intreface of 2004 over the sunset and would like to keep my current version…
Hung Le said
From hleofxquotes:
I don’t have v2004, so I will not be able to test. But what you described matched that of v2005UK. We don’t know of any work-around for that (having to force a transaction). This wiki has some notes on that: http://code.google.com/p/hle-ofx-quotes/wiki/UKUsers.
Mr. Money said
Thanks for the reply. I thought about trying to manipulate quantities to achieve a price update – but your incremental update accomplished step #1 of the process.
After I imported the incremental file into a blank account and established a beginning position of .001 shares – I noticed that the update was listed as a buy, not an update. I was concerned about seeing it as a buy in the pricing table. Also concerned if I deleted the entry or changed the date that the update table would change to the changed date or delete itself all together.
Instead, I tried another tack with seems to be an acceptable work around.
1) I changed the dates from the original incremental file input to 1/1/1950 (still 0.001 shares).
2) I then deleted the 1950 entry from the pricing table.
3) I then generated a new ofx import pricing file using the original program (no incremental update).
4) When the statement was updated – .001 share from each investment was removed with the date 11/16/2011 and the price table had an entry labeled as update (instead of buy).
5) I then deleted the removal entries for each stock – leaving only the .001 entry from 1950 in place.
6) Checking the pricing table, I now have an entry with todays date that is listed as update and is not affected by the loss of the adjustment entry.
7) When I update the next batch – I will do the same and assume that the results will be similar.
8) The only “negative” as previously noted is that my portfolio is overstated by all the .001 shares. A small price to pay for being able to update automatically. Perhaps I can omit the account from my reports. Of is necessary, I can delete the entries, run reports and then import the static 1950 account balances prior to the next update.
(now if you could have the incremental update listed as an update instead of a buy and not have it affected by date changes or deletions, I could omit my additional steps)
Thanks for your program.
Ya-hoo!
Johnson said
I’ve been using Build_20110212_001 with the sunset version of Money for some time now with no problems. I updated prices successfully on
12/30/2011. But this evening, when I tried to update with 1/03/2012 prices, Money is ignoring the update. I get the normal indication that the dummy file has been updated, but nothing has been updated. The ofx output shows the correct information has been downloaded from Yahoo.
I haven’t followed all developments such as later builds since my present version has worked perfectly until now. I’d appreciate advice on correcting the problem.
Duane Johnson
ameridan said
Hopefully you’ll get this resolved. Hung usually replies very quickly.
I can’t confirm your issue since I only use PocketSense now, but I will note that quotes behave fine in 2012 using PocketSense.
Johnson said
My problem disappeared this morning! The 1/03/2012 update was accepted on 1/04. I suspect my problem was related to the one-a-day update characteristic of Money. Although I hadn’t knowingly tried to to update previously on the third, somehow Money thought I had.
Sorry for the false alarm!