tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/6111-quoteloader-missing-securitiesInfinite Kind: Discussion 2021-11-29T07:40:21Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-15T19:36:10Z2021-08-15T19:36:10ZQuoteloader Missing Securities<div><p>On your first point can you send Screenshots of the tools/securities edit screen of a security that does not work in QL along with SSs of the QL setup screen?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-15T19:55:36Z2021-08-15T19:55:36ZQuoteloader Missing Securities<div><p>Attached:<br>
- TPINX (which works) - TWMIX (which does not work) - QL setup screen</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-15T20:21:29Z2021-08-15T20:21:29ZQuoteloader Missing Securities<div><p>Does TWMIX have any share balance/holdings in MD? If not, tick the ‘include zero accounts’. Any good?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-20T13:25:38Z2021-08-20T13:25:38ZQuoteloader Missing Securities<div><p>On the first point - 'include zero accounts' did the trick, thanks.</p>
<p>On the second point, multiple securities with the same ticker, how do I get QuoteLoader to include both securities?</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-21T07:23:15Z2021-08-21T07:23:15ZQuoteloader Missing Securities<div><p>QL doesn't include multiple securities with the same ticker. This is<br>
not how Moneydance works, you should only have one security and include<br>
it in multiple accounts. QL then loads the price for the security and<br>
this is reflected in all accounts with that security.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-21T20:38:51Z2021-08-21T20:38:51ZQuoteloader Missing Securities<div><p>The other post I linked to at the top of this thread explains why multiple securities with the same ticker is necessary. Has to do with how brokerages handle the same security offered in a 401(k) vs. an individual account.</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-21T20:54:50Z2021-08-21T20:54:50ZQuoteloader Missing Securities<div><p>If I have to choose, I'd rather QL retrieve the ticker tied with the regular (non-employer) accounts. Unfortunately, it is currently retrieving the 401(k) version of the security. I've tried re-naming the security to something farther down the list (alphabetically), but QL continues to retrieve the 401(k) version. I've uninstalled QL, restated MD, reinstalled QL, but hasn't helped.</p>
<p>Given two different MD securities both the the same ticker, how do I force QL to pick one over the other?</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-21T21:44:03Z2021-08-21T21:44:03ZQuoteloader Missing Securities<div><p>QL updates the first ticker it finds, so change the ticker.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-22T07:27:38Z2021-08-22T07:27:38ZQuoteloader Missing Securities<div><p>I know about the issue with multiple securities with the same ticker and<br>
the reasons why. What I am considering doing is adding the CUSIP id to<br>
the ticker in QL, eg. XXX.ddd and only doing one get quote for XXX and<br>
then updating all instances of XXX. This is not a simple change and, in<br>
my mind goes against the design of MD. As dwg pointed out, once I have<br>
an entry for a ticker I do not acccept any more. If I make the change I<br>
am suggesting then each duplicate ticker will need to have a different<br>
CUSIP id.</p>
<p>Another approach is to just update all entries with the same ticker,<br>
this is a bigger change and with all changes there is the danger of<br>
breaking some working code.<br>
Mike</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-22T20:18:36Z2021-08-22T20:18:36ZQuoteloader Missing Securities<div><p>Mike,</p>
<p>I appreciate the investment you've made into this extension. I would truly value a solution to this problem - preferably a fix for MD that allows me to use one security for both individual and employer accounts or barring that, an update to QL so that it will recognize two securities with the same ticker. Either would make a big difference.</p>
<p>Having said that, I value stability more, and one of the things I appreciate most about MD and its related extensions is the stability. It would be great if you're able to offer a solution to this problem, but not at the cost of breaking the code. My thoughts for your consideration. Thanks.</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-22T20:48:53Z2021-08-22T20:48:53ZQuoteloader Missing Securities<div><p>In my mind your investment house has done the wrong thing here in order to suit their own purposes, whatever that may be.</p>
<p>Within a market a ticker is supposed to be unique to one security and one security only, the CUSPID is just unique to a security full stop. The "extra" CUSPID that Fidelity has assigned is not even a valid one, so in my thinking they have done the wrong thing by not following the rules.</p>
<p>If you want you can try using the Quotes and Exchange rates extension, with Yahoo as the source, I suspect this may give you what you want as the original author of this extension, if my memory serves, just iterates through each ticker it finds.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-23T04:27:07Z2021-08-23T04:27:07ZQuoteloader Missing Securities<div><p>@dwg - I do agree. The investment house is using a 'bad' and invalid cusip on his 401k accounts which is the main root cause. However, MD has a flaw in that it's design doesn't let the user properly cope with this situation and forces a new Security to be created just so it can store a different CUSIP. Why MD doesn't just use the Ticker number I'm not sure (or display/edit the CUSIP on the Tools>Security screen). In addition, MD shouldn't really let you create duplicate Securities for the same Ticker. However, none of this is the User's fault. Mike's suggestion for QL would be a neat 'fix' for this issue regarding the price updates where duplicate tickers exist.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-23T04:55:59Z2021-08-23T04:55:59ZQuoteloader Missing Securities<div><p>@Stuart, The only thing I can think of that Moneydance is using the CUSPID as a validation check on downloaded transactions to ensure they are going to the right account/security.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-23T12:21:56Z2021-08-23T12:21:56ZQuoteloader Missing Securities<div><p>What I have decided is that the user can put in a ticker with an<br>
extension to it. It doesn't matter what this extension is but it allows<br>
QL to recognise matching tickers. For example AAPL#1, AAPL#2, AAPL#3. <br>
These will show on the QL page. At the moment they will not get a price<br>
but the change I am considering is to take the first entry with an<br>
extension, strip the extension off, get the price, update all entries<br>
with the same ticker. I will disable, but show the lines with<br>
extensions, except the first.</p>
<p>In my example QL will have</p>
<p>AAPL#1, you can choose the source and save the price from this line<br>
AAPL#2, this line will be disabled, the price will be updated with the<br>
one above.<br>
AAPL#3,this line will be disabled, the price will be updated with the<br>
one above.<br>
Any thoughts? What character for the extension identifier. It should be<br>
one that can not appear in a ticker.<br>
Mike</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-23T12:37:14Z2021-08-23T12:37:14ZQuoteloader Missing Securities<div><p>Mike, I can see how this would work - would there be any ramifications elsewhere in MD as a result of the extension to the ticker - some other part of the program that wouldn't know how to deal with it?</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-23T14:06:44Z2021-08-23T14:06:44ZQuoteloader Missing Securities<div><p>As far as I am aware no other part of the program uses the Ticker. The<br>
Q&ER extension does but you would not run it with QL.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-23T14:38:29Z2021-08-23T14:38:29ZQuoteloader Missing Securities<div><p>My 'hunt' agrees with this. It's just a reference field.. The good thing is that Mike's approach means that nothing in MD is being detrimentally changed.</p>
<p>I like the use of the '#' character.</p>
<p>My only question is which one 'wins' and becomes the one where you set the QL options (and thus the others are 'disabled')?</p>
<p>In this logic you've laid out above, does QL actually check for the CUSIP at all, or just for tickers with the #xxxxx added?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T04:53:31Z2021-08-24T04:53:31ZQuoteloader Missing Securities<div><p>The one that wins is the first I come across, the CUSIP is not used at all.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T07:45:50Z2021-08-24T07:45:50ZQuoteloader Missing Securities<div><p>I have given this some more thought and think the user needs to create<br>
one security for the ticker without the extension, this is the one I<br>
will do the quote on. Any other security with the same ticker needs to<br>
have an extension. Lines with an extension will have the source<br>
disabled but the check box for saving a line enabled. They will be<br>
updated with the price from the quotge.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T09:06:37Z2021-08-24T09:06:37ZQuoteloader Missing Securities<div><p>I see an issue with this. At the moment (taking this thread as the example). The user wants 1 security. Because of the Investment house's bad data, MD is forcing the user to have two securities. Both have a cusip. I think your QL suggestion will make them hold three securities? One with a normal ticker and no cusip, and two more, for each cusip and with #something on the end...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T09:09:12Z2021-08-24T09:09:12ZQuoteloader Missing Securities<div><p>...or I suppose the user chooses which one is their 'master' and leaves the ticker as normal (even though it has a cusip) and only sets the second Security to have the extra #xxxx on the ticker.... If this is what you mean, then yes that could work..</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T09:16:25Z2021-08-24T09:16:25ZQuoteloader Missing Securities<div><p>I'm reading Mike's proposal a little differently.</p>
<p>I take it as meaning you will need to have one security with the normal ticker- call this the primary, and any other instance of the same security will need to have an # extension, call these secondary instances, So you have 1 primary in all cases but you can have"x" secondary instances. I see the CUSIP being not part of this solution.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T10:58:07Z2021-08-24T10:58:07ZQuoteloader Missing Securities<div><p>This is my take on Mikes current thinking for a future build, confirmed by Mike.</p>
<p>Normally in Moneydance you should not use the same Ticker Symbol in more than one Security. Quote Loader will only list one of the Duplicate Securities and hence only one will be updated. Some Financial Institutions in there downloads when the same Security exists in more than one Account indicate to which account the data should be routed by adding an extra identifier in addition to the Ticker Symbol. These identifiers are not normally visible to the user and can’t be found for example in the Security History window for a Security under TOOLS – SECURITIES. This creates in Quote Loader terms a Duplicate Security. In these cases, the user must manually add an extension to the Duplicate Security Ticker Symbol using the # symbol. Example, there are three securities all using the Ticker AAPL. Under TOOLS - SECURITIES edit two duplicate to add an extension to the Ticker Symbol. This gives AAPL#1 and AAPL#2 so each has a uniquely identified plus the unedited Security with the Ticker AAPL. In Quote Loader all three Securities will be listed but only the one without the extension will be enabled to set a source and retrieve data. However, on Save Selected Values all ticked data lines will be entered into their respective Security History windows, thus solving the duplicate problem.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T11:50:08Z2021-08-24T11:50:08ZQuoteloader Missing Securities<div><p>dwg and Derek are correct, CUSIP id is not relevant. You do not need an<br>
extra account.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-24T20:23:19Z2021-08-24T20:23:19ZQuoteloader Missing Securities<div><p>My appreciation to Mike, Stuart and others for looking into this. Clearly having only one security would be the best outcome, but I can easily make Mike's proposal work and it would address the issue well. Based on my limited experience with MD, I don't see a deal-breaker here. Again, many thanks.</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-25T11:41:14Z2021-08-25T11:41:14ZQuoteloader Missing Securities<div><p>I have just uploaded a new version of Quote Loader to <a href="https://bitbucket.org/mikerb/moneydance-2019/downloads/">https://bitbucket.org/mikerb/moneydance-2019/downloads/</a>. It is called securityquoteloader3042.mxt. To install download it and rename to securityquoteload.mxt. Use Manage Extensions/Add from file to install.</p>
<p>This version will accept tickers in the form ttt#eee where ttt is the ticker on the exchange and eee is any set of characters. ttt#eee must be unique. All other parameters are the same. If you do not add this security to an account and buy some shares then you must click on 'Include zero accounts'.</p>
<p>You will not be able to update any fields on the lines with these tickers. You must have a security with the ticker ttt.</p>
<p>When prices are retrieved all lines with a source and a ticker without the #eee will be retrieved, Quote Loader will then go through the list and try to update any line with a ticker of the format ttt#eee. It will update the line with data from the line with the ticker ttt.</p>
<p>Please put any issues or questions here.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-26T00:35:32Z2021-08-26T00:35:32ZQuoteloader Missing Securities<div><p>@Mike - I downloaded the extension as listed above and gave it a whirl. The first time I ran it after updating the ticker symbols it hung immediately after pressing "Get Prices." The New Price column was all yellow.</p>
<p>Since I had not restarted MD after updating the extension, I closed MD and restarted it and tried again, this time it worked. It updated all prices, skipping the TTTTT#002 versions, and then filled in those prices at the end. Save Selected Values then saved the updated prices back to the security as expected.</p>
<p>So it seems to work as intended, thank you. I'll let you know if any other anomalies show up, in the meantime, thanks again for your help on this. Much appreciated.</p></div>retailtag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-26T07:24:00Z2021-08-26T07:24:00ZQuoteloader Missing Securities<div><p>Hi retail</p>
<p>You always have to restart Moneydance after a QL install, that's normal.<br>
There have been some small issues found, but nothing to worry about. I am sure Mike will fix them</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/493407322021-08-30T07:38:47Z2021-08-30T07:38:47ZQuoteloader Missing Securities<div><p>I am not support staff, just a user.<br>
Hi retail</p>
<p>Just a heads up.</p>
<p>Sean has signed and released Quote Loader build 3042 under EXTENSIONS – MANAGE EXTENSION.</p>
<p>This release replaces the beta builds of 3042 fixing some bugs.</p>
<p>You may wish to uninstall Quote Loader and reinstall.</p>
<p>Hope this helps.</p></div>derekkent23