[Kmymoney] RES: Quotes download
allan
agander93 at gmail.com
Sun Oct 11 09:23:17 UTC 2015
Don't use Notepad, as Windows uses different line endings.
Also, remember that your mystery ID had prefix, so you need to look
for that too.
Allan
Sent from my Samsung Galaxy smartphone.
-------- Original message --------
From: Email Terra Rhaufed <rhaufed at terra.com.br>
Date:11/10/2015 09:51 (GMT+00:00)
To: 'Thomas Baumgart' <thb at net-bembel.de>, kmymoney at kde.org
Cc:
Subject: [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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20151011/57b84053/attachment-0001.html>
More information about the KMyMoney
mailing list