[Kmymoney] RES: RES: Quotes download
aga
agander93 at gmail.com
Sun Oct 11 10:59:09 UTC 2015
On 11/10/15 10:17, Email Terra Rhaufed wrote:
> 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
By fixed, do you mean that you can now load the file, or that your
original problem is fixed as well?
Allan
> -----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
More information about the KMyMoney
mailing list