[Kmymoney] RES: RES: RES: Quotes download

[aga]

On 10/10/15 20:12, Email Terra Rhaufed wrote:
> Hi Allan,
>
> I've been trying to understand the configurations you used to extract the price from bloomberg.
> Inspecting page elements I can find Symbol and price code from where you extracted data. But I could not figure out from where on the page you got the date (why you used "lastUpdateDate" as the parameter fr Date?).
> Sorry for bothering whit this, but maybe I can understand it a little bit better and next time I can do it myself.

Hi Rhaufed

I was afraid you might ask that!  Looking through the downloaded page, 
there were plenty of 'Date's mentioned, but all with time included. 
There was only that one "lastUpdateDate", which sounded promising so I 
used that.  However, the actual date quoted does not figure in the 
imported details, which seems just to use the current date.  You can 
actually remove that parameter, and the same price etc. gets imported. 
In fact, I couldn't see any historic details so it looks like you can 
get only the current date anyway.

I tried using - previousClosingPriceOneTradingDayAgo": - but the same 
current date was loaded and that price was ignored as well.

Like I said, though, I'm not an expert, and you may with your interest 
in regex be able to get better results, with some practice.

Allan


>
> -----Mensagem original-----
> De: Email Terra Rhaufed [mailto:rhaufed at terra.com.br]
> Enviada em: sexta-feira, 9 de outubro de 2015 17:02
> Para: 'aga' <agander93 at gmail.com>; 'KMyMoney Users' mailing list' <kmymoney at kde.org>
> Assunto: RES: RES: RES: [Kmymoney] Quotes download
>
> 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!!!!
>
>
> 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, Rhaufed
>
> -----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
>>>
>>
>