[moneydance] XML Tags
Gordon Alley
gordon at gordonalley.com
Sun Jan 6 12:20:59 EST 2008
It would be handy if MD provided a "Rename Security" feature.
-Gordon
On Jan 6, 2008 9:57 AM, Ash Ponders <ashponders at gmail.com> wrote:
> Hey Randy!
>
> would you mind adding that guide to the Moneydance Wiki?
> I'm sure it'd be pretty helpful to others in your situation.
>
> ~Ash
>
> On Jan 6, 2008, at 8:49 AM, rpiercemd wrote:
>
> >
> > I had not received any replies how to merge two securities, so with
> > trial and
> > error I did find a solution. This situation arose when my financial
> > firm
> > suddenly changed the name of 5 of my securities, which left me with 10
> > securities in MD instead of five...not life-threatening unless you are
> > compulsive.
> >
> > You need an XML editor- I used XML Marker 1.1 (free), which works
> > well.
> > Print out report with all accounts, balances and share quantities for
> > verification later.
> > MAKE A BACKUP!!!!!
> > Export Moneydance file in xml format, and open in XML Marker
> > In the left upper pane you will see your xml file broken down into an
> > hierarchal format. Select "CURRENCYLIST", and in the right lower
> > screen you
> > can order however you wish to find the two securities in question.
> > Note
> > their "CURRIDs".
> > Edit-->Replace, enter name of security which you want to change, and
> > search.
> > Your first search should bring you to the <CURRENCY>:</CURRENCY>
> > section,
> > and I had two CURRIDs, one with right name, one with wrong. I
> > deleted the
> > wrong one, deleting from <CURRENCY> to next </CURRENCY> tag. The
> > other one
> > was the correct one, so leave alone.
> > I also copied the <CURRSNAP>..</CURRSNAP> for the deleted CURRENCY,
> > and
> > placed it in chronological order in the section <CURRHIST> of the
> > correct
> > CURRENCY, which I believe keeps all the historical pricing intact.
> > (NOTE: if
> > you make a syntax error XML marker will notify you of a problem.)
> > "Find next", and you will come to <ACCOUNTS>:</ACCOUNTS> section---
> > there
> > should be two again. Please note the ACCTIDs for these two securities.
> > Delete the wrong-named account, from <ACCOUNT> to next </ACCOUNT> tag.
> > Subsequently, all "Find" actions pulled up transactions (<STXN>);
> > here you
> > need to make sure the ACCTID is correct for all transactions
> > (delete the
> > ACCTID for the wrong-named security, replace with ACCTID for correct
> > security).
> > Finally, re-search with "incorrect" security name, and verify that all
> > instances are correct with respect to name, CURRID and ACCTID.
> > Open file in MD, and verify accounts and shares are correct.
> >
> > I would appreciate it if someone else could verify this in a different
> > situation than mine for accuracy-sake. Obviously make a backup!
> >
> > Randy
> > Carrollton, GA
> > rpiercemd wrote:
> >>
> >> I have had a security name change, so now have two securities which
> >> are
> >> the same thing. I am editing the XML file to get everything under the
> >> security's newest name. There is a "TAGS" subheading under "CURRENCY"
> >> which contains a "KEY" = "price_date" with a "VALUE" =
> >> 1161078500000. It
> >> is not clear what this number represents. Does anyone have some
> >> insight? I
> >> would like to basically merge the xml data for these securities,
> >> but these
> >> "price_date values are clearly different.
> >>
> >
> > --
> > View this message in context:
> http://www.nabble.com/XML-Tags-tp5452069p14649894.html
> > Sent from the MoneyDance - General mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > moneydance-info mailing list
> > moneydance-info at moneydance.com
> > http://moneydance.com/mailman/listinfo/moneydance-info
>
> _______________________________________________
> moneydance-info mailing list
> moneydance-info at moneydance.com
> http://moneydance.com/mailman/listinfo/moneydance-info
>
--
Gordon B. Alley
http://www.gordonalley.com
More information about the moneydance-info
mailing list