Reply to topic

How to setup Bloomberg as an Online Quote Provider

ldeseta
Registered Member
Posts
1
Karma
0
After having many issues with Yahoo Currency (and its many fixes) in KMymoney 4.8.1, I managed to setup Bloomberg as both a stock provider, and a currency provider (to replace Yahoo Currency).

To setup Bloomberg as a new stock provider:
Code: Select all
URL: https://www.bloomberg.com/quote/%1
Symbol:
Price: <div class="price">(\d*,?\d+\.\d+)
Date: <div class="price-datetime">[a-zA-Z0-9:\s]*(\d+\/\d+\/\d+)
Date format:   %m/%d/%y
Skip HTML stripping: true


To setup Bloomberg as a currency provider, edit Yahoo Currency and set the following settings:
Code: Select all
URL: https://www.bloomberg.com/quote/%1%2:CUR
Symbol:
Price: <div class="price">(\d*,?\d+\.\d+)
Date: <div class="price-datetime">[a-zA-Z0-9:\s]*(\d+\/\d+\/\d+)
Date format: %m/%d/%y
Skip HTML stripping: true


Hope this helps to the ones having problems with Yahoo Currency, or want to use Bloomberg as a provider!
grahamdo
Registered Member
Posts
3
Karma
0
Hi ldeseta,

I created an account specifically so that I could respond to this thread. I hope you get notified somehow. :-)

I have a set of books in KMyMoney for my author business, and I have accounts in probably six or seven currencies. I implemented your solution back in April, and it worked beautifully. But it's broken again, because Bloomberg has changed the layout of their page.

I tried to fix it myself by looking through the page source and updating the values in Configure KMyMoney, but my regx knowledge isn't good enough. :-(

By any chance, would you be willing to take a look and let me know what settings I need to use for Price, Date, and Date Format?

Here's an example: https://www.bloomberg.com/quote/AUDUSD:CUR

I'd really appreciate it!

Cheers
Graham
grahamdo
Registered Member
Posts
3
Karma
0
Okay, nevermind. I was on KMyMoney 4.8.1. I just upgraded to 4.8.2, and there's a new source, called KMyMoney Currency, which works. In case anyone's following this thread, please upgrade to 4.8.2. :-)
User avatar vistasp
Registered Member
Posts
3
Karma
0
ldeseta wrote:After having many issues with Yahoo Currency (and its many fixes) in KMymoney 4.8.1, I managed to setup Bloomberg as both a stock provider, and a currency provider (to replace Yahoo Currency).


Hi Ideseta,

Does your syntax still work? Bloomberg seems to have changed their page format.

I had successfully used Bloomberg in the past to update Indian stock prices (v 4.8.2 on Windows) but I can't any longer. I keep getting the error message:
"Unable to update price for <symbolname> (no price or no date)"

An example page would be https://www.bloomberg.com/quote/TTMT:IN

What I've been using until recently:
Code: Select all
URL: https://www.bloomberg.com/quote/%1
Symbol:
Price: (\d+.\d+)INR
Date: (\d+/\d+/\d+) EDT
Date format: %m/%d/%y
Skip HTML stripping: not checked

This used to work but it doesn't any longer. The format of the Bloomberg page changes every little while, but I've always been able to modify the settings to match. This time however, I just cannot seem to get the correct syntax.

I'd be very grateful if you or anyone else who is experienced in regular expressions could take a look and correct my error(s).
grahamdo
Registered Member
Posts
3
Karma
0
Hi vistasp,

Did you see my post?

What version of KMyMoney are you on? If you upgrade to 4.8.2, they have a new currency conversion URL (Not Yahoo, Google, OR Bloomberg, but a brand new one) that actually works. :-)
User avatar vistasp
Registered Member
Posts
3
Karma
0
Hi grahamdo,

Yes, I read your post, but I'm looking for stock prices only, not currency. :(

As mentioned, I'm using 4.8.2 on Windows.

 
Reply to topic

Bookmarks



Who is online

Registered users: arkascha, Baidu [Spider], Bing [Bot], bluewizard, cmiranda, Google [Bot], grapejuice, gusarg, matthiasb, mehdisaada, rblackwell, sadi, Sogou [Bot], Yahoo [Bot]