tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/57692-quotes-and-exchange-rates-extension-not-workingInfinite Kind: Discussion 2020-02-23T09:20:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-21T20:54:18Z2019-11-21T20:54:18ZQuotes and Exchange Rates Extension not working<div><p>I am not support staff, jut a user.</p>
<p>Can you post say four ticker symbols plus their security names so I can test for you?<br>
Note IEX trading has closed its API as a source for quotes so can’t be used as a source.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-21T20:58:23Z2019-11-21T20:58:23ZQuotes and Exchange Rates Extension not working<div><p>IBM - IBM<br>
3M - MMM<br>
ALPHABET - GOOGL<br>
DOLLAR TREE - DLTR</p></div>davidsclovetag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-21T21:47:36Z2019-11-21T21:47:36ZQuotes and Exchange Rates Extension not working<div><p>I am not support staff, just a user.<br>
Hi davidsclove</p>
<p>I tested your 4 security examples using extension “Quote and Exchange Rate Updater v1024 and all 4 returned quotes. See an example of a security price history window screen shot after running the extension. Perhaps provide a screen shot of your Q & ER settings.</p>
<p>If the Quote and exchange rate updater does not work well for you try the free third-party Quote Loader. Both of the sources in the Quote Loader have good coverage of worldwide securities.</p>
<p>See Screen shot of Quotes returned by Quote Loader. Both Quote Loader sources returned prices.</p>
<p>See post 205 at <a href="https://infinitekind.tenderapp.com/discussions/investments/4039-quote-loader-securitycurrency-price-loader-for-moneydance-2019/page/7#comment_47493595">https://infinitekind.tenderapp.com/discussions/investments/4039-quo...</a></p>
<p>Download the PDF attached to posts 205 and have a read.</p>
<p>To get an overview take a look at the YouTube video by using the link on page 1 of the PDF.</p>
<p>Let us know how you get on or if you need help just post.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-21T22:39:41Z2019-11-21T22:39:41ZQuotes and Exchange Rates Extension not working<div><p>I’ve got Quote Loader working, but the data is not showing up in the Security “History” window.</p></div>davidsclovetag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-21T22:42:20Z2019-11-21T22:42:20ZQuotes and Exchange Rates Extension not working<div><p>I’ve got Quote Loader working, but the data is not showing up in the Security “History” window.</p>
<p>Also, the listings in Portfolio don’t reflect the data from Quote Loader</p></div>davidsclovetag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-22T08:10:41Z2019-11-22T08:10:41ZQuotes and Exchange Rates Extension not working<div><p>I am not support staff, just a user.<br>
Hi davidsclove</p>
<p>Assuming you got the same as far as the screen shot I posted in my last post did you then select the quotes you wanted to save?<br>
1 "Click to Select all lines"<br>
2 "Save Selected Values"</p>
<p>If you now open the security history price window for say DOLLAR TREE you should see the Current Price updated and a dated price added in this case for the 21/11/2019.</p>
<p>Post if you still have problems.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-22T14:32:42Z2019-11-22T14:32:42ZQuotes and Exchange Rates Extension not working<div><p>Yes, I got all that to work and the prices are updated. Thanks.</p>
<p>Next, I set up an automatic run which ran this morning and got an error message that there was a problem. It said I should check the price date to see which ones didn’t get updated. None were updated.</p></div>davidsclovetag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-22T14:48:32Z2019-11-22T14:48:32ZQuotes and Exchange Rates Extension not working<div><p>I am not support staff, just a user.<br>
Hi davidsclove</p>
<p>Can you post a screen shot of the Quote Loader window so I can see the settings etc.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-22T14:58:58Z2019-11-22T15:15:12ZQuotes and Exchange Rates Extension not working<div><p><img width="640" height="367" class=""><br class="">
<br></p>
<div><br class="">
<br>
<div class="">On Nov 22, 2019, at 9:48 AM, derekkent23 <<a href="mailto:tender+d9e389cf27@tenderapp.com" class="">tender+d9e389cf27@tenderapp.com</a>> wrote:</div>
<br>
<br class="Apple-interchange-newline">
<br>
<div class=""><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<table width="100%" class="">
<tr class="">
<td class=""><br>
<p class="">// Please reply above this line<span class="Apple-converted-space"> </span><br class="">
<br>
==================================================<span class="Apple-converted-space"> </span></p>
<p class=""><b class="">From</b>: derekkent23</p>
<br>
<div class=""><br>
<p class="">I am not support staff, just a user.<span class="Apple-converted-space"> </span><br class="">
<br>
Hi davidsclove</p>
<br>
<p class="">Can you post a screen shot of the Quote Loader window so I can see the settings etc.</p>
<br></div>
<br>
<div class=""><br>
<p class="">On Fri, Nov 22 at 06:32 AM PST, davidsclove wrote:</p>
<br>
<blockquote class=""><br>
<div class=""><br>
<p class="">Yes, I got all that to work and the prices are updated. Thanks.</p>
<br>
<p class="">Next, I set up an automatic run which ran this morning and got an error message that there was a problem. It said I should check the price date to see which ones didn’t get updated. None were updated.</p>
<br></div>
<br></blockquote>
<br></div>
<br></td>
</tr>
<tr class="">
<td class=""><br>
<p class="">Having trouble reading this? View this discussion online:<span class="Apple-converted-space"> </span><a href="https://infinitekind.tenderapp.com/discussions/problems/57692-quotes-and-exchange-rates-extension-not-working" class="">Quotes and Exchange Rates Extension not working</a>.</p>
<br>
<p class="">To unsubscribe and stop receiving emails from<span class="Apple-converted-space"> </span><a href="https://infinitekind.tenderapp.com/" class="">https://infinitekind.tenderapp.com</a>, visit<span class="Apple-converted-space"> </span><a href="https://infinitekind.tenderapp.com/unsubscribe/483039c079f09890e0995d3ff5cab65a7737dc00" class="">this page</a></p>
<br></td>
</tr>
</table>
<br></div>
<br></div>
<br>
<br class=""></div>davidsclovetag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-22T15:47:33Z2019-11-22T15:47:33ZQuotes and Exchange Rates Extension not working<div><p>I am not support staff, just a user.<br>
Hi davidsclove</p>
<p>The setting looks OK.<br>
I have asked Mike the Quote Load developer to take a look at this thread, he may ask and walk you through how to post an error log.<br>
In the meantime, as a test can you set the “Time of Run” to a time that has already passed with the “Next” dates set for today’s date. Close and open Moneydance. On opening watch the status bar at the bottom, you should see the prices update. Report if you get an error message and if the “Next” date has incremented.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-22T21:36:10Z2019-11-22T21:36:10ZQuotes and Exchange Rates Extension not working<div><p>I think it’s running OK now. Early this morning I had set it to run at 11:00 today. I just got home and it had run and had generated the error message. I noticed that one of the securities was highlighted in red. I checked and found out that the symbol was incorrect. I changed it and ran it again. It ran OK and the prices are updated.</p>
<p>It’s now set to run automatically each morning. I’ll let you know if I have any more problems.</p>
<p>Thanks!</p>
<p>On Nov 22, 2019, at 10:47 AM, derekkent23 <a href="mailto:tender+d9e389cf27@tenderapp.com">tender+d9e389cf27@tenderapp.com</a> wrote:</p>
<h1><a name="-please-reply-above-this-line-" class="anchor" href="#-please-reply-above-this-line-"></a>// Please reply above this line</h1>
<p>From: derekkent23</p>
<p>I am not support staff, just a user.<br>
Hi davidsclove</p>
<p>The setting looks OK.<br>
I have asked Mike the Quote Load developer to take a look at this thread, he may ask and walk you through how to post an error log.<br>
In the meantime, as a test can you set the “Time of Run” to a time that has already passed with the “Next” dates set for today’s date. Close and open Moneydance. On opening watch the status bar at the bottom, you should see the prices update. Report if you get an error message and if the “Next” date has incremented.</p></div>davidsclovetag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-22T21:58:08Z2019-11-22T21:58:08ZQuotes and Exchange Rates Extension not working<div><p>I am not support staff, just a user.<br>
Hi davidsclove</p>
<p>It sounds like Quote Loader correctly indicated it could not return a price for one of the security. Now you have corrected the ticker issue you should be good to go, with no further problems.</p>
<p>Have Fun.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-23T08:00:01Z2019-11-23T08:00:01ZQuotes and Exchange Rates Extension not working<div><p>A couple of things</p>
<ol>
<li>
<p>Your screenshot shows the last run as 11/22/2019 and the next run as 11/22/2019. This shouldn't happen, either it has run on 11/22 and the next run should be 11/23 or it hasn't run and the last run should be 11/21. Have you changed the settings?</p>
</li>
<li>
<p>When it runs automatically and there is an error you get the message. If you immediately run Quote Loader the update date of the line in error will be red with an * next to it. This indicates that the Ticker is incorrect.</p>
</li>
</ol>
<p>One thing to note is that when you change the automatic run settings you need to shut down Moneydance and restart to make the new settings effective.</p>
<p>Please can you do the following:</p>
<ol>
<li>Run Quote Loader and set the debug level to 'Detailed' (Help/Debug/Detailed)<br></li>
<li>Change the start time to 'At Startup'<br></li>
<li>Close down Quote Loader and Moneydance<br></li>
<li>Start Moneydance<br></li>
<li>Post the Moneydance Log to this forum (Help/Console, copy to clipboard, paste to a text file and save.</li>
</ol>
<p>Thanks, let me know if you have any problems with this.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-23T15:06:49Z2019-11-23T15:06:49ZQuotes and Exchange Rates Extension not working<div><p>Question 1 - I think I had set the next run date back to 11/22 before i took the screenshot.</p>
<ol>
<li>- It seems to be running OK since I found the incorrect ticker symbol and changed it. When I checked this morning it showed last run date 11/23 and next run date 11/24. There was no error message.</li>
</ol>
<p>Thanks.</p>
<p>Here’s the log:</p>
<p>Starting Moneydance 2019.3 (1880) at Sat Nov 23 10:01:33 EST 2019<br>
Settings Folder: /Users/David/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance<br>
OS: Mac OS X 10.14.6 x86_64<br>
Java: 11.0.1 (Oracle Corporation)<br>
Is in sandbox: true; restricted file access: false<br>
outdated extension: detailedBudget findandreplace (0): 11-23 10:01:33.598|Initialized build 1211 ok<br>
initialized extension findandreplace in 0.025 seconds<br>
outdated extension: myposition initialized extension priceui in 0.001 seconds<br>
2019-11-23 10:01:33.702 INFO [main] READ_CONFIGURATION - from file=/Users/David/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/fmodules/.rhumba/rhumbaConfiguration.json<br>
DEBUG_FLAGS - debug=false<br>
2019-11-23 10:01:33.729 INFO [main] CACHE - enable, ttl=600000<br>
DIRECTORY cwd=/Users/David/Library/Containers/com.infinitekind.MoneydanceOSX/Data/.<br>
2019-11-23 10:01:33.730 INFO [main] > init - Name: rhumba, Build: 1058<br>
2019-11-23 10:01:33.733 INFO [main] RHUMBA - looking for exec jar file in dir=/Users/David/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/fmodules/.rhumba<br>
2019-11-23 10:01:33.735 INFO [main] RHUMBA - found 1 exec jar file(s) ...<br>
2019-11-23 10:01:33.735 INFO [main] RHUMBA - exec jarFile[0]=/Users/David/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/fmodules/.rhumba/hleOfxQuotes.jar<br>
2019-11-23 10:01:33.736 INFO [main] RHUMBA - SELECTED Rhumba exec jar file=/Users/David/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/fmodules/.rhumba/hleOfxQuotes.jar<br>
LOG4J - (reflection) manually set log4j.debug=true<br>
LOG4J - (reflection) manually set log4j.defaultInitOverride=true<br>
2019-11-23 10:01:33.788 INFO [main] launcher: com.moneydance.modules.features.rhumba.sandbox.MyJarLauncher@65d09a04<br>
2019-11-23 10:01:33.788 INFO [main] launcherClassLoader: com.moneydance.modules.features.rhumba.sandbox.MyLaunchedURLClassLoader@7d8704ef<br>
ERROR StatusLogger No Log4j 2 configuration file found. Using default configuration (logging only errors to the console), or user programmatically provided configurations. Set system property 'log4j2.debug' to show Log4j 2 internal initialization logging. See <a href="https://logging.apache.org/log4j/2.x/manual/configuration.html">https://logging.apache.org/log4j/2.x/manual/configuration.html</a> for instructions on how to configure Log4j 2<br>
2019-11-23 10:01:34.446 INFO [main] yahooService: com.hungle.msmoney.rhumba.RhumbaYahooSS2Service@258d79be<br>
2019-11-23 10:01:34.448 INFO [main] ftService: com.hungle.msmoney.rhumba.RhumbaFtService@4f6f416f<br>
2019-11-23 10:01:34.450 INFO [main] yhService: com.hungle.msmoney.rhumba.RhumbaYhService@7b8b43c7<br>
initialized extension rhumba in 0.722 seconds<br>
initialized extension securityquoteload in 0.028 seconds<br>
Quote Load>INFO:10:01:34-main(Quote Load,Init) Started Build 3016<br>
Quote Load>INFO:10:01:34-main(Quote Load,Init) Locale en_US<br>
Initializing fonts:<br>
preferred: [[Helvetica Neue, Helvetica, Dialog]] regular: [[Helvetica Regular, Arial, SansSerif, Dialog]] mono: [[Gill Sans, Monospaced]] fonts resolved:<br>
default: Helvetica Neue:13.0:style0 mono: Gill Sans:13.0:style0 header: Helvetica Neue:15.0:style0 register: Helvetica Regular:12.0:style0 registerMinor: Helvetica Neue:12.0:style0 reportTitle: Helvetica Regular:32.0:style0 calendarTitle: Helvetica Neue:12.0:style0 reportHeader: Helvetica Neue:11.0:style0 detailTitle: Helvetica Neue:15.0:style0 Setting look and feel class to com.apple.laf.AquaLookAndFeel<br>
Initializing fonts:<br>
preferred: [[Helvetica Neue, Helvetica, Dialog]] regular: [[Helvetica Regular, Arial, SansSerif, Dialog]] mono: [[Gill Sans, Monospaced]] fonts resolved:<br>
default: Helvetica Neue:13.0:style0 mono: Gill Sans:13.0:style0 header: Helvetica Neue:15.0:style0 register: Helvetica Regular:12.0:style0 registerMinor: Helvetica Neue:12.0:style0 reportTitle: Helvetica Regular:32.0:style0 calendarTitle: Helvetica Neue:12.0:style0 reportHeader: Helvetica Neue:11.0:style0 detailTitle: Helvetica Neue:15.0:style0 opening last file: /Users/David/Documents/Critical Data/Current.moneydance<br>
loading dataset: /Users/David/Documents/Critical Data/Current.moneydance<br>
loading with 128 bit encryption key<br>
reading trunk data tiksync/trunk<br>
trunk data loaded (2.265 seconds), checking for incremental updates<br>
loading un-synced txn files...<br>
error loading txn file tiksync/out/20160910152659_652.txn; continuing. error: java.io.IOException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.<br>
error loading txn file tiksync/out/20170221141725_727.txn; continuing. error: java.io.IOException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.<br>
error loading txn file tiksync/out/20160609154444_396.txn; continuing. error: java.io.IOException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.<br>
loading synced txn files...<br>
replacing root: null () with new root: Root Account (e09c77a6-7464-4f91-b1d8-ef953c6589a4<br>
Info: no currencies found for UUID: f175e593-6118-4e44-9713-87064d449a94 or oldID: 3439502 from KPMG 401(k):VANGUARD INSTL 500 IDX TRUST (mod.acct:option_price=0.0&pid=867&type=s&parentid=99f3858e-109c-4dd9-9158-c1898d74bf8f&sbal=0&num_years=0&sec_dividend=0&obj_type=acct&id=1f1a94d2-6471-42de-8319-027e40082820&currid=f175e593-6118-4e44-9713-87064d449a94&curr=3439502&apr=0.0&maturity=-25200000&sec_subtype=&strike=0&broker=&face_value=0&bond_type=0&cost_basis=y&compounding=0&hide=yes&month=0&sec_type=3&name=VANGUARD INSTL 500 IDX TRUST&old_id=8886162&broker_ph=&comment=&sec_exchange=NYSE&option=y&ts=1546458403002)<br>
2019-11-23 10:01:45.675 INFO [main] > handleEvent, appEvent=md:file:opening<br>
dropbox folder should be at /Users/David/Dropbox and exists=true<br>
base sync folder: /Users/David/Dropbox/.moneydancesync<br>
dropbox folder should be at /Users/David/Dropbox and exists=true<br>
base sync folder: /Users/David/Dropbox/.moneydancesync<br>
2019-11-23 10:01:46.026 INFO [AWT-EventQueue-0] > handleEvent, appEvent=md:account:root<br>
2019-11-23 10:01:46.157 INFO [main] > handleEvent, appEvent=md:file:opened<br>
Quote Load>INFO:10:01:46-main(Quote Load,HandleEventFileOpened) Debug level set to DET<br>
Quote Load>DET:10:01:46-main(Quote Load,HandleEventFileOpened) Servertype rhumba<br>
Quote Load>SUMM:10:01:46-main(Quote Load,HandleEventFileOpened) Using Rhumba<br>
Quote Load>SUMM:10:01:46-AWT-EventQueue-0(Main,invoke) Command checkauto<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(Main,invoke) Processing checkauto<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(Main,processCommand) process command invoked checkauto<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(Main,processCommand) Running Checkautocmd<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(Quote Load,Process Command) Security Auto mode detected<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(Quote Load,Process Command) Currency Auto mode detected<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(Main,processCommand) Date check false false<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(Quote Load,Process Command) Nothing to run<br>
Quote Load>INFO:10:01:46-AWT-EventQueue-0(Main,sendAuto) now 10:01:46.945258 next 2019-11-23T11:00<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(TaskExecutor,startExecutionAt) when time 23/11 11:0<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(TaskExecutor,startExecutionAt) time 10 1<br>
Quote Load>DET:10:01:46-AWT-EventQueue-0(TaskExecutor,startExecutionAt) setting run at 11 0<br>
Quote Load>SUMM:10:02:16-AWT-EventQueue-0(Main,invoke) Command showconsole<br>
Quote Load>SUMM:10:02:16-AWT-EventQueue-0(Main,showConsole) Sending Hello<br>
Quote Load>SUMM:10:02:16-Thread-2(Main,RhumbaTimer) Timer started<br>
2019-11-23 10:02:16.852 INFO [pool-1-thread-1] > REQUEST - class=HelloRequest, tid=null, callingModuleName=securityquoteload<br>
Quote Load>SUMM:10:02:16-AWT-EventQueue-0(Main,invoke) Command iamhere<br>
Quote Load>DET:10:02:16-AWT-EventQueue-0(Main,invoke) Processing iamhere<br>
Quote Load>DET:10:02:16-AWT-EventQueue-0(Main,processCommand) process command invoked iamhere<br>
Quote Load>SUMM:10:02:16-AWT-EventQueue-0(Main,invoke) Server Present<br>
Quote Load>INFO:10:02:16-AWT-EventQueue-0(Main,showConsole) Starting Quote Load<br>
Quote Load>INFO:10:02:16-AWT-EventQueue-0(Main,showConsole) Manual Run<br>
Quote Load>DET:10:02:16-Thread-2(Main,RhumbaTimer) Timer interrupted<br>
Quote Load>DET:10:02:16-AWT-EventQueue-0(Parameters,findFile) New 2<br>
Quote Load>DET:10:02:16-AWT-EventQueue-0(Parameters,Parameters) Parameters found /Users/David/Documents/Critical Data/Current.moneydance/securityquoteload.bpam2<br>
Quote Load>SUMM:10:02:16-AWT-EventQueue-0(ExchangeList,getData) Input stream found<br>
Quote Load>SUMM:10:02:16-AWT-EventQueue-0(PseudoList,getData) Input stream found<br>
Quote Load>DET:10:02:16-AWT-EventQueue-0(MyTableModel,MyTableModel) Decimal Format #,##0.00<br>
Quote Load>SUMM:10:02:34-AWT-EventQueue-0(Main,createAndShowGUI) Yes<br>
Quote Load>DET:10:02:34-AWT-EventQueue-0(Quote Load,closeConsole) closing Console</p></div>davidsclovetag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-23T17:27:37Z2019-11-23T17:27:37ZQuotes and Exchange Rates Extension not working<div><p>I am not support staff, just a user.<br>
Hi davidsclove</p>
<p>Great, sounds like Quote Loader is working</p>
<p>Have Fun.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/478592632019-11-24T09:13:10Z2019-11-24T09:13:10ZQuotes and Exchange Rates Extension not working<div><p>Glad it is working for you, don't forget to change the Quote Loader debug back to Off or Information otherwise you will generate a lot of messages.<br>
Regards<br>
Mike</p></div>Mike Bray (Quote Loader Author)