[Kmymoney] RES: RES: Quotes download
Rhaufed
rhaufed at terra.com.br
Sun Oct 11 11:04:19 UTC 2015
Both
Sent from my iPhone 6+
> On Oct 11, 2015, at 12:59, aga <agander93 at gmail.com> wrote:
>
>
>
>> 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