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