tag:infinitekind.tenderapp.com,2009-01-14:/discussions/moneydance-development/2012-security-price-loader-a-suggestion-for-improvementInfinite Kind: Discussion 2018-10-18T14:10:01Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/444672602018-01-09T13:34:34Z2018-01-09T13:34:34ZSecurity Price Loader, a suggestion for improvement<div><p>Thanks for the suggestion. I have had a quick look. First thing, where do you get your encrypted userid from? I can see you can extract it from the 'export' option but we will need an easy way to get it.<br>
Secondly, the URL you gave seems to tail off at the end, I am not sure where the userid ends and the rest of the URL continues. Please clarify.</p>
<p>I have now problem with adding the option to my extension though it would be for US users only as many GB stocks have no prices.<br>
If you could give the steps you took to get to this I will have a look.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/444672602018-01-11T23:56:04Z2018-01-11T23:56:04ZSecurity Price Loader, a suggestion for improvement<div><p>The encrypted userid is assigned by Yahoo as a function of the person's userID and password. I verified that it is the same over multiple login's and logout's. On the Firefox browser, I hover over the "export" link and copy link location. For my testing, and use, I open up a separate tab, paste the link in, and enter to return to the location (or refresh). It does save the quotes in a csv file (quotes(x).csv if quotes.csv exist).</p>
<p>Note that since URL's are stateless (going from 1 page to another page requires that information be save, like a cookie, or within the URL parameters, like this!</p>
<p>The URL that I used is the following:</p>
<p><a href="https://query1.finance.yahoo.com/v6/finance/portfolio">https://query1.finance.yahoo.com/v6/finance/portfolio</a><br>
/download?userId=xxxxxxxxxxxxxxxxxxxxxxxTBI&pfId=pf_3</p>
<p>So, here are the steps:<br>
(1) As noted in previous postings, set up your list of stocks in a portfolio. You will need a userID and password. (2) For the first time, check the quotes for each of the stocks set up so that you know that you have the correct ticker. (3) You try the export and look at the csv file to make sure it is correct for your extension. (just because I am cautious about my "production data" (4) Try copying the link location to another browser tab and performing the same action as described above. It will prompt you for the save of quote.csv. (5) I remember the version number of the previous file and use the extension.</p>
<p>I hope this explains how I did this "google-hack"....</p></div>sprimosttag:infinitekind.tenderapp.com,2009-01-14:Comment/444672602018-01-12T08:42:10Z2018-01-12T08:42:10ZSecurity Price Loader, a suggestion for improvement<div><p>Thanks for the info. This is how I did it to test your request. I was hoping for a more elegant way of obtaining the encrypted user id. I will investigate further and let you know.</p></div>Mike Bray (Quote Loader Author)tag:infinitekind.tenderapp.com,2009-01-14:Comment/444672602018-01-12T16:11:52Z2018-01-12T16:11:52ZSecurity Price Loader, a suggestion for improvement<div><p>There are a couple of other ways to get this field, actually known as a "handle". It is an internal to Yahoo field done as a security "feature". But without logging in somewhere within its number of services, you don't get it available. I haven't checked if there is a cookie that has it been set (usually if you allow the connection to stay open for 2 weeks) but even if that is the case, the data is encrypted. I quickly checked and did not find any, but I will do some research also.</p></div>sprimost