[Kmymoney] RES: RES: RES: RES: Quotes download
timothy
timboyle at afrihost.co.za
Sun Oct 11 08:25:05 UTC 2015
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
> >
>
>
>
More information about the KMyMoney
mailing list