tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/502-security-prices-updateInfinite Kind: Discussion 2018-10-18T14:04:15Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-11-11T18:30:06Z2016-11-25T19:38:56ZSecurity prices update<div><p>The extension works by going to the Yahoo finance page,
retrieving an download file made available there, then importing
that into MD.</p>
<p>Unfortunately Yahoo support for Non-US funds can be spotty. One
way to test is to go to the yahoo finance page for that security,
scroll down to the bottom right for the toolbox, click on the link
downloadable file. Open that in a spreadsheet app to confirm that
it ti populated.</p>
<p>One helpful hint it to have the extension set to Yahoo USA, even
if you have the exchanges set to London exchanges.</p>
<p>If you can send a screen shot of your extension page, I can
confirm if the set up is correct.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-06T14:16:22Z2016-11-25T19:38:56ZSecurity prices update<div><p>I have the same problem but this only started after I updated to
the latest version of moneydance. I have updates set to Yahoo
Finance Uk and London Exchange (pence) and this worked fine before.
I've tried Yahoo USA and switching to £ instead of pence but
nothing works. The error message I get is input data was not
text.</p></div>kai_hoochtag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-06T14:32:03Z2016-11-25T19:38:56ZSecurity prices update<div><p>Can you give me an example ticker symbol that is not working for
you.</p>
<p>Ben Spencer<br>
Infinite Kind Support</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-11T07:57:12Z2016-11-25T19:38:56ZSecurity prices update<div><p>Thanks Ben, I could give an example (Centrica ticker symbol =
CNA) - but the problem seems to be fixed! All are updating OK again
now. Many thanks</p></div>kai_hoochtag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-12T00:15:16Z2016-11-25T19:38:56ZSecurity prices update<div><p>Sometimes Yahoo support for UK funds is spotty. hey usually
correct it eventually. Please let us know if there are further
issues.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-12T11:26:15Z2016-11-25T19:38:56ZSecurity prices update<div><p>Following the guidance in kai_hooch's message yesterday, I also
am now<br>
successfully getting security prices through - I wonder how many
other<br>
users in the UK have had the same problems and simply given up,
like me<br>
'til now! The breakthrough was kai's revelation that the ticker
code he used for Centrica was CNA, which is the EPIC code. I tried
this,<br>
experimenting with various settings until something finally
came<br>
through. The settings for someone in the UK would seem to be as
follows:</p>
<p>/Source: Yahoo Finance USA/ - nothing at all comes through if
source set to Yahoo Finance UK<br>
/Stock Exchange: London Exchange (Pence)/ - this works for most
securities, but not if a fund has a non-GB ticker code (see
below)<br>
/Ticker code: EPIC (for individual equities, e.g. Centrica); ISIN
(for funds)//- /N.B. the EPIC code will not work for funds; the
ISIN code<br>
will not work for individual equities.</p>
<p>Some funds are not quoted on the London Exchange. The ISIN code
for<br>
funds quoted on the London Exchange begins with the letters GB
(e.g.<br>
Invesco Perpetual Income Class Y Income - GB00BJ04HX60). For
funds<br>
quoted on other exchanges the ISIN code begins with two
different<br>
letters, e.g. IE = Irish Stock Exchange; LU = Luxemburg (EBS).
For<br>
these funds, the 'Stock Exchange' should presumably be set to
the<br>
relevant exchange. I have tried setting the IE stocks to 'Irish
Stock<br>
Exchange' (e.g. Lindsell Train Global Equity Class D Income -<br>
IE00BJSPMJ28). I get a price through, but the price is in GB
Pounds<br>
whereas Moneydance automatically treats it as in Euro. The only<br>
solution that I can see to this would be to create an additional
field<br>
in 'Quotes and Exchange Rate Settings' for the currency of the
quote.</p>
<p>Finally, for some reason no quotes are available for any of the
Jupiter<br>
funds, a major UK fund manager (e.g. Jupiter Financial
Opportunities -<br>
GB00B8JYV946). This seems strange - would it be possible to raise
this<br>
with Yahoo?</p>
<p>Kind regards<br>
Jeremy</p></div>norfolkjptag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-12T11:26:16Z2016-11-25T19:38:56ZSecurity prices update<div><p>Following the guidance in kai_hooch's message yesterday, I also
am now<br>
successfully getting security prices through - I wonder how many
other<br>
users in the UK have had the same problems and simply given up,
like me<br>
'til now! The breakthrough was kai's revelation that the ticker
code he used for Centrica was CNA, which is the EPIC code. I tried
this,<br>
experimenting with various settings until something finally
came<br>
through. The settings for someone in the UK would seem to be as
follows:</p>
<p>/Source: Yahoo Finance USA/ - nothing at all comes through if
source set to Yahoo Finance UK<br>
/Stock Exchange: London Exchange (Pence)/ - this works for most
securities, but not if a fund has a non-GB ticker code (see
below)<br>
/Ticker code: EPIC (for individual equities, e.g. Centrica); ISIN
(for funds)//- /N.B. the EPIC code will not work for funds; the
ISIN code<br>
will not work for individual equities.</p>
<p>Some funds are not quoted on the London Exchange. The ISIN code
for<br>
funds quoted on the London Exchange begins with the letters GB
(e.g.<br>
Invesco Perpetual Income Class Y Income - GB00BJ04HX60). For
funds<br>
quoted on other exchanges the ISIN code begins with two
different<br>
letters, e.g. IE = Irish Stock Exchange; LU = Luxemburg (EBS).
For<br>
these funds, the 'Stock Exchange' should presumably be set to
the<br>
relevant exchange. I have tried setting the IE stocks to 'Irish
Stock<br>
Exchange' (e.g. Lindsell Train Global Equity Class D Income -<br>
IE00BJSPMJ28). I get a price through, but the price is in GB
Pounds<br>
whereas Moneydance automatically treats it as in Euro. The only<br>
solution that I can see to this would be to create an additional
field<br>
in 'Quotes and Exchange Rate Settings' for the currency of the
quote.</p>
<p>Finally, for some reason no quotes are available for any of the
Jupiter<br>
funds, a major UK fund manager (e.g. Jupiter Financial
Opportunities -<br>
GB00B8JYV946). This seems strange - would it be possible to raise
this<br>
with Yahoo?</p>
<p>Kind regards<br>
Jeremy</p></div>norfolkjptag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-13T12:59:03Z2016-11-25T19:38:56ZSecurity prices update<div><p>I have had similar problems with downloading security prices. I
made some suggestion to improve the situation and the reply was
“Thanks for the suggestion for improving Moneydance! I've
passed your feedback onto the developers, so they'll be taking it
into consideration”, but no update has yet been forthcoming.
Take a look, <a href="http://help.infinitekind.com/discussions/suggestions/9255-quotes-and-exchange-rates-extension">
http://help.infinitekind.com/discussions/suggestions/9255-quotes-an...</a>
The more people that request an improvement to the Quotes and
Exchange Rates Extension the more likely it is to happen. At the
moment I am updating prices manually using the “Security
Price Entry” extension.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-14T08:48:06Z2016-11-25T19:38:56ZSecurity prices update<div><p>What would help as an interim measure would be a report at the
end of a<br>
securities price update listing those securities for which the
update<br>
failed, so that these can be updated manually. If there is some way
of<br>
getting this information already, other than checking each
individual<br>
security, it would be very helpful to know.</p></div>norfolkjptag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392015-12-14T15:10:43Z2016-11-25T19:38:57ZSecurity prices update<div><p>You can have the system run a test to tell you which securities
updated correctly. To do this:</p>
<p>From the menu bar select Extensions->Quotes and Exchange
Rates...<br>
Click the "Advances >>" link on the right hand side.<br>
Click the "Test" button on the bottom left.</p>
<p>Ben Spencer<br>
Infinite Kind Support</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392016-03-09T12:26:10Z2016-11-25T19:38:57ZSecurity prices update<div><p>I've found the same problem as norfolkjp regarding GBP funds on
the Irish Stock Exchange. For example, IE00B1S75374, the Vanguard
UK Government Bond Index, is listed on the Irish Exchange, but its
price is in GBP.</p>
<p>So the Quotes and Exchange Rates Updater fetches the price (say,
150.00) and says it's in Euros, when it's actually in GBP. Even
only doing the Updater's 'Test' fetching, it changes the Currency
of the security - if I subsequently open the security's History
window, its Currency gets set to Euro, even when I've manually
changed it to British Pound. This also screws up the graph of
previously-manually-entered prices until I change the Currency back
again.</p></div>philtag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392016-03-09T21:55:30Z2016-11-25T19:38:57ZSecurity prices update<div><p>In the extension set the exchange to the Irish stock exchange.
Then right click the exchange field and set the currency to
GBP.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392016-03-10T10:37:08Z2016-11-25T19:38:57ZSecurity prices update<div><p>Thanks Tom, but I'm a bit stumped. If I right click (Control
click, as I'm on a Mac) on the exchange field I just get the same
drop-down menu to select the exchange that I do if I normal-click
on it. The London exchange has options for GBP or pence, but
there's only one Irish exchange. Am I missing something?</p></div>philtag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392016-03-15T19:03:43Z2016-11-25T19:38:57ZSecurity prices update<div><p>I wondered if this wasn't working for me because I was still on
Moneydance 2014, but I've just updated to 2015.7 and still no joy.
If I Control-click on anything it's just the same as if I do a
standard click. How do I get it to work as it did for you?
Thanks.</p></div>philtag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392016-03-18T18:55:50Z2016-11-25T19:38:57ZSecurity prices update<div><p>I asked a mac person and they said if you have a two button
mouse you can right click to bring it up or if using a touch pad, a
two finger tap. I have attached an image as to what you are looking
for.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/384357392016-03-21T09:19:03Z2016-11-25T19:38:57ZSecurity prices update<div><p>That's strange... In general, on a Mac, doing a Control-click
behaves exactly the same as right-click with a two-button mouse, or
a two-finger-tap on the trackpad (if that option is enabled in
System Preferences). But it seems that in Moneydance that's not the
case.</p>
<p>In the Quotes and Exchange Rates Updater, if I Control-click on
something it behaves exactly the same as a standard (left) click.
So Control-clicking the exchange drop-down menu opens the drop-down
menu. But a two-finger-trackpad tap or a right-click on a
two-button mouse on the menu does the trick. Which is peculiar and
impossible to predict.</p>
<p>Even aside from that, having a drop-down menu act as a button,
not a drop-down menu, when it's right-clicked doesn't seem very
intuitive.</p>
<p>But thanks for your help in figuring out the UI.</p></div>phil