[Kmymoney] RES: Quotes download
timothy
timboyle at afrihost.co.za
Sun Oct 11 09:02:32 UTC 2015
When editing the XML file in a text editor, you must delete from
<PRICEPAIR from="BRL" to="E000013">
<PRICE price="........
<PRICE price="...................
<PRICE price="...........
.......
......
</PRICEPAIR>. (note the frontslash)
On Sun, 2015-10-11 at 10:51 +0200, Email Terra Rhaufed wrote:
> Hi Thomas,
>
> Well.... It seem my Notepad has screwed file. I'll try again and let you know what happens
>
> -----Mensagem original-----
> De: Thomas Baumgart [mailto:thb at net-bembel.de]
> Enviada em: domingo, 11 de outubro de 2015 10:43
> Para: kmymoney at kde.org
> Cc: Email Terra Rhaufed <rhaufed at terra.com.br>
> Assunto: Re: [Kmymoney] Quotes download
>
> Rhaufed,
>
> On Sunday 11 October 2015 10:34:21 Email Terra Rhaufed wrote:
>
> > Hi,
> >
> > yes,
> >
> > that is what I did, but I get the error message when I open KMyMoney:
> >
> > File X:/Arquivos Privados/Rhaufed/KMyMoney/Fix.xml contains the old
> > binary format used by KMyMoney. Please use an older version of
> > KMyMoney (0.8.x) that still supports this format to convert it to the new XML based format.
> >
> > Do I have to uninstall my 4.7 version and install an older one, and
> > then install beack version 4.7 or am I getting something wrong here?
>
> No, there's no need to install old versions. Looks like your XML file has some problems to be detected as such.
>
> Can you start kmymoney from a DOS-Box (Windows-Shell) with the folowing
> command:
>
> kmymoney "X:/Arquivos Privados/Rhaufed/KMyMoney/Fix.xml"
>
> If that also fails, then it seems that your editor screwed up the file somwhow.
>
>
>
> > -----Mensagem original-----
> > De: timothy [mailto:timboyle at afrihost.co.za]
> > Enviada em: domingo, 11 de outubro de 2015 10:25
> > Para: Email Terra Rhaufed <rhaufed at terra.com.br>
> > Cc: 'KMyMoney Users' mailing list' <kmymoney at kde.org>
> > Assunto: Re: RES: [Kmymoney] RES: RES: RES: Quotes download
> >
> > Hi
> >
> > Once you have deleted the relevant section. Just open the "fixed" xml file
> > as a normal kmy file in kmymoney and then remember to save it as a kmy file
> > in kmymoney.
> >
> > Cheers
> >
> > On Sun, 2015-10-11 at 10:13 +0200, Email Terra Rhaufed wrote:
> > > Hi Timothy, I´m not sure I got the solution right. What I understand I
> > > should o is:
> > >
> > > 1)Save kmy file as a XML
> > > 2) Search for string
> > > 3) Delete it
> > >
> > > But then, what I'm I supposed to do with this XML "fixed" file, how do I
> > > import it back into KMyMoney, or, in other words, how do I convert it
> > > back to kmy file to be read by KMyMoney?
> > >
> > > Sorry for my lack of knowledge
> > >
> > >
> > > Regards, Rhaufed
> > > -----Mensagem original-----
> > > De: timothy [mailto:timboyle at afrihost.co.za] Enviada em: domingo, 11
> > > de outubro de 2015 10:07
> > > Para: KMyMoney Users' mailing list <kmymoney at kde.org>
> > > Cc: Rhaufed Santos <rhaufed at terra.com.br>
> > > Assunto: Re: [Kmymoney] RES: RES: RES: Quotes download
> > >
> > > I have just had a look at my kmy file. The correct text to find is:
> > > <PRICEPAIR from="BRL" to="E000013">. Delete all relevant price pairs upto
> > > and including </PRICEPAIR>.
> > >
> > > Do NOT delete the reverse direction:
> > > <PRICEPAIR from="E000013" to="BRL">
> > >
> > > Regards
> > > Timothy
> > >
> > > On Sun, 2015-10-11 at 09:36 +0200, timothy wrote:
> > > > Hi
> > > >
> > > > I had a similar problem a few months back with my local currency.
> > > >
> > > > Do as Allan said re looking in your kmy file as xml and look for
> > > > <PRICEPAIR> 'from BRl to= E000013'
> > > >
> > > > I deleted those sections one by one (I had several) and checked that
> > > > the Tools/Update stock and currency prices ran without errors. The
> > > > consistency check is also good.
> > > >
> > > > I cannot guarantee that it will work, but it did for me and no
> > > > hassles since.
> > > >
> > > > Regards
> > > > Timothy
> > > >
> > > > On Sun, 2015-10-11 at 00:03 +0100, aga wrote:
> > > > > On 10/10/15 20:33, Rhaufed Santos wrote:
> > > > > > Hi Allan,
> > > > > >
> > > > > > yes, I do have BRL symbol because it is my base currency
> > > > > > (Brazilian) an I have an account in USD and MZN. So, basically
> > > > > > the system has BRLUSD and BRLMZN exchange rates and I'm not sure
> > > > > > I can delete it
> > > > >
> > > > > No, that wouldn't be a good idea. What about the E000013? Did
> > > > > you find that anywhere? What you could try, having ensured proper
> > > > > backup, is to save you kmy file as XML and load it into a text
> > > > > editor, and look for it there. See what that comes up with. You
> > > > > should find it refers to its investment account, which perhaps is
> > > > > defunct.
> > > > >
> > > > > Allan
> > > > >
> > > > > > Sent from my iPad
> > > > > >
> > > > > >> On 9 de out de 2015, at 19:30, aga <agander93 at gmail.com> wrote:
> > > > > >>> On 09/10/15 16:01, Email Terra Rhaufed wrote:
> > > > > >>> Allan,
> > > > > >>>
> > > > > >>> THANK YOU SOOOO MUCH.
> > > > > >>>
> > > > > >>> Yes, it did work, ,my mistake before was that I updated the
> > > > > >>> configuration you provided, but I did not hit update on the
> > > > > >>> screen, I just hot ok and I thought it would accept the changes,
> > > > > >>> but not. If one does not hit update to set the Bloomberg
> > > > > >>> configuration the OK does not assume it has to update, it assumes
> > > > > >>> it has to make no changes.
> > > > > >>>
> > > > > >>> I tested it with many different symbols and it is working now!!!!
> > > > > >>
> > > > > >> Good.
> > > > > >>
> > > > > >>> One final question:
> > > > > >>>
> > > > > >>> When I go Tools\Update stock and currency prices I get all my
> > > > > >>> stocks updated but one: Fetching URL
> > > > > >>> http://finance.yahoo.com/d/quotes.csv?s=BRLE000013=X&f=sl1d1...
> > > > > >>> Symbol found: BRLE000013=X
> > > > > >>> Price found: N (0)
> > > > > >>> Unable to update price for BRL > E000013 (no price or no date)
> > > > > >>>
> > > > > >>> But I could not find this BRLE000013 symbol anywhere in my
> > > > > >>> portfolio (may be a mistake I made at some point and this was
> > > > > >>> kept somewhere). Can you help me on how to get rid of this symbol
> > > > > >>> so it does not try to update it everytime?
> > > > > >>>
> > > > > >>>
> > > > > >>> Thank you, Rhaufel
> > > > > >>
> > > > > >> That looks like a combination of a symbol BRL and an internal KMM
> > > > > >> ID number E000013.
> > > > > >>
> > > > > >> Firstly, make sure you have good working backup.
> > > > > >>
> > > > > >> Next, do you have a symbol BRL and/or E000013? Look also for
> > > > > >> either If so, and in Tools>Prices and in Investments view tab
> > > > > >> Securities. If you want to delete either/both, and you are sure
> > > > > >> it's OK to do so, try to delete them. If any transactions
> > > > > >> reference them, you may not be able to do so initially. If this
> > > > > >> is the case, let us know.
> > > > > >>
> > > > > >> Allan
> > > > > >>
> > > > > >>> -----Mensagem original-----
> > > > > >>> De: aga [mailto:agander93 at gmail.com] Enviada em: sexta-feira,
> > > > > >>> 9 de outubro de 2015 16:52
> > > > > >>> Para: Email Terra Rhaufed <rhaufed at terra.com.br>; 'KMyMoney
> > > > > >>> Users' mailing list' <kmymoney at kde.org>
> > > > > >>> Assunto: Re: RES: RES: [Kmymoney] Quotes download
> > > > > >>>
> > > > > >>>> On 09/10/15 15:44, Email Terra Rhaufed wrote:
> > > > > >>>> Hi Alan,
> > > > > >>>>
> > > > > >>>> Sorry for not copying the list. My fault.
> > > > > >>>>
> > > > > >>>> I´ll give it a try again. My system is using ddmmaa
> > > > > >>>> configuration for the data, may it be the source of problem?
> > > > > >>>> I´ll try and get back to you with results
> > > > > >>>
> > > > > >>> You do need to use use %y %m %d as it has to match the
> > > > > >>> downloaded file format. (not sure about the spaces between)
> > > > > >>>
> > > > > >>> Allan
> > > > > >>>
> > > > > >>>> -----Mensagem original-----
> > > > > >>>> De: aga [mailto:agander93 at gmail.com] Enviada em: sexta-feira,
> > > > > >>>> 9 de outubro de 2015 16:41
> > > > > >>>> Para: Email Terra Rhaufed <rhaufed at terra.com.br>; KMyMoney Users'
> > > > > >>>> mailing list <kmymoney at kde.org>
> > > > > >>>> Assunto: Re: RES: [Kmymoney] Quotes download
> > > > > >>>>
> > > > > >>>> Be sure to copy to the list, to ensure everyone gets updated.
> > > > > >>>>
> > > > > >>>>> On 09/10/15 15:17, Email Terra Rhaufed wrote:
> > > > > >>>>> Hi Alan,
> > > > > >>>>>
> > > > > >>>>> Thank you for your support.
> > > > > >>>>> Are you sure it did work for ITUBK34 symbol?
> > > > > >>>>>
> > > > > >>>>> When I try this I still get the same error:
> > > > > >>>>>
> > > > > >>>>> Fetching URL http://www.bloomberg.com/quote/ITUBK34:BZ...
> > > > > >>>>> Symbol found:
> > > > > >>>>> Unable to update price for ITUBK34:BZ- (no price or no date)
> > > > > >>>>>
> > > > > >>>>> With parameters you suggested:
> > > > > >>>>>
> > > > > >>>>> URL http://www.bloomberg.com/quote/%1
> > > > > >>>>> Symbol class="ticker">
> > > > > >>>>> Price class="price">(\d+\.\d+)
> > > > > >>>>> Date "lastUpdateDate":"
> > > > > >>>>> Date Format %y %m %d
> > > > > >>>>> Skip HTML stripping ticked
> > > > > >>>>
> > > > > >>>> Yes, I've just tried a couple more times and the price is
> > > > > >>>> definitely getting updated.
> > > > > >>>>
> > > > > >>>> Editing the stock, I'm using ITUBK34:BZ as the symbol.
> > > > > >>>>
> > > > > >>>> Allan
> > > > > >>>>
> > > > > >>>>> -----Mensagem original-----
> > > > > >>>>> De: aga [mailto:agander93 at gmail.com] Enviada em:
> > > > > >>>>> sexta-feira,
> > > > > >>>>> 9 de outubro de 2015 16:00
> > > > > >>>>> Para: KMyMoney Users' mailing list <kmymoney at kde.org>;
> > > > > >>>>> rhaufed at terra.com.br
> > > > > >>>>> Assunto: Re: [Kmymoney] Quotes download
> > > > > >>>>>
> > > > > >>>>>> On 08/10/15 08:15, Email Terra Rhaufed wrote:
> > > > > >>>>>> Hi all,
> > > > > >>>>>>
> > > > > >>>>>> I’ve been using KMyMoney for a few days now and for most of
> > > > > >>>>>> my investment transactions I download quote data from Yahoo
> > > > > >>>>>> .It works pretty well for stocks (even for Brazilian ones),
> > > > > >>>>>> but it does not support stock options quotes.
> > > > > >>>>>>
> > > > > >>>>>> I have another program where I use Bloomberg as the source
> > > > > >>>>>> of data for stock options for Brazilian market, and it does
> > > > > >>>>>> work. So, if I want the price for an option like ITUBK34 I
> > > > > >>>>>> use ITUBK34:BZ in symbol name and it downloads data. The
> > > > > >>>>>> problem is that this connection with Bloomberg is
> > > > > >>>>>> pre-configured into this software and I want to use it with
> > > > > >>>>>> KMyMoney, but do not know what to enter into those fields to
> > > > > >>>>>> create a new connection. Someone can help me?
> > > > > >>>>>>
> > > > > >>>>>> Regards, Rhaufed
> > > > > >>>>>
> > > > > >>>>> You could give this a try, if you haven't found anything better.
> > > > > >>>>> I'm not an expert, and it's definitely not guaranteed, but it
> > > > > >>>>> seems to work, at least for the symbol you give above.
> > > > > >>>>>
> > > > > >>>>> Using the symbol ITUBK34:BZ -
> > > > > >>>>>
> > > > > >>>>> URL http://www.bloomberg.com/quote/%1
> > > > > >>>>> Symbol class="ticker">
> > > > > >>>>> Price class="price">(\d+\.\d+)
> > > > > >>>>> Date "lastUpdateDate":"
> > > > > >>>>> Date Format %y %m %d
> > > > > >>>>> Skip HTML stripping ticked
> > > > > >>>>>
> > > > > >>>>> Allan
> > > > >
> > > > > _______________________________________________
> > > > > KMyMoney mailing list
> > > > > KMyMoney at kde.org
> > > > > https://mail.kde.org/mailman/listinfo/kmymoney
> >
> > _______________________________________________
> > KMyMoney mailing list
> > KMyMoney at kde.org
> > https://mail.kde.org/mailman/listinfo/kmymoney
More information about the KMyMoney
mailing list