|
#2
| |||
| |||
| "John Seyerle" <seyerle[at]hotmail.com> wrote in message news:elX0gA2gIHA.4376[at]TK2MSFTNGP05.phx.gbl... - quote - > Is there a way to manually bulk update investment prices?
There is no way in the application nor, as Dick replied, is there an API. If> Money Plus cannot find an investment I want to track so I was manually but > this becomes tidious. you have simple programming skills you might consider trying to record something like a macro in Excel that copies from a cell, navigates to a different open window (Money), and inserts the copied value into the price field. I did something like that years ago in an earlier version of both Excel and Money, but don't know if it could be done in current versions. Even if it could, there would probably be a risk of error. I would suggest not automating it walking through an entire spreadsheet of prices. Instead, assign a ctrl-key combo for one cycle of price addition, then do it repeatedly, manually. That way the damage would be limited, if a single data entry cycle caused an error. -- Chris Cowles Gainesville, FL |
|
#1
| |||
| |||
| Nobody has ever identified a way to manually bulk update investment prices short of an online quotes download. The .MBF file is a backup file. The .MNY file has the price history embedded in it. It is stored in an MSISAM file which is a relative of JET or Access .MDB database storage. There is no intended API or otherwise exposure to muck with it, though various hacks to get at the data from Access have been reported. Nobody has reported using paths like this to do what you want but it surely is possible with enough time and effort. "John Seyerle" <seyerle[at]hotmail.com> wrote in message news:elX0gA2gIHA.4376[at]TK2MSFTNGP05.phx.gbl... - quote - > Is there a way to manually bulk update investment prices? > Money Plus cannot find an investment I want to track so I was manually but > this becomes tidious. > I was hoping for a way to edit the historial prices manaully as I could > write a script to do this. > Are all the historical prices stored in the .mbf file? Anyone ever > manually manipulated this? If so how? |
| | |||
| |||
| John Seyerle wrote: - quote - > Is there a way to manually bulk update investment prices?
Can I somehow put my historical prices in the exported excel format and> Money Plus cannot find an investment I want to track so I was manually > but this becomes tidious. > I was hoping for a way to edit the historial prices manaully as I could > write a script to do this. > Are all the historical prices stored in the .mbf file? Anyone ever > manually manipulated this? If so how? I noticed from the price history chart I can export to excel. import again? I converted it to QIF but the import function does not allow you to import against individual investments. |
|
#-1
| |||
| |||
| Is there a way to manually bulk update investment prices? Money Plus cannot find an investment I want to track so I was manually but this becomes tidious. I was hoping for a way to edit the historial prices manaully as I could write a script to do this. Are all the historical prices stored in the .mbf file? Anyone ever manually manipulated this? If so how? |
| Tags |
| bulk, investment, manually, prices, update |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Update prices manually Portfolio problem Arko: Hi! Every day I have to register some data at "Update prices manually" in Portfolio reading at a web browser. It used to be very easy since the... | Microsoft Money | 5 | 03-18-2007 07:17 PM | |
| How to batch update prices manually STANLEY LAI: May I update investment prices inport from a text file or execl file... | Microsoft Money | 1 | 04-14-2006 03:07 AM | |
| What happened to the ability to manually update stock prices in 2005 : What happened to the ability to manually update stock prices in 2005 via right clicking on the stock. I have quite a few investments in my 401k that... | Microsoft Money | 11 | 10-03-2004 04:30 PM | |
| Thread Tools | |
| Display Modes | |
| |