[Kmymoney] RES: RES: Quotes download
Email Terra Rhaufed
rhaufed at terra.com.br
Sun Oct 11 09:17:53 UTC 2015
Hi Thomas,
After trial and error I figured out what to do.
DO NOT edit file with notepad. It is a text editor, but do not preserve LF in the file, and that was the source of error.
EDIT the file with WORDPAD, for instance. It will preserve CR/LF in file.
Fixed, thank you and Timothy for support
Regards, Rhaufed
-----Mensagem original-----
De: KMyMoney [mailto:kmymoney-bounces at kde.org] Em nome de Email Terra Rhaufed
Enviada em: domingo, 11 de outubro de 2015 10:52
Para: 'Thomas Baumgart' <thb at net-bembel.de>; kmymoney at kde.org
Assunto: [Kmymoney] RES: Quotes download
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
--
Regards
Thomas Baumgart
GPG-FP: E55E D592 F45F 116B 8429 4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
I'm running on very little sleep and I need to get to bed before my keyboard becomes my pillow. -- Jeff Green
-------------------------------------------------------------
_______________________________________________
KMyMoney mailing list
KMyMoney at kde.org
https://mail.kde.org/mailman/listinfo/kmymoney
More information about the KMyMoney
mailing list