tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/4689-importing-historical-prices-manuallyInfinite Kind: Discussion 2020-01-21T20:00:26Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/477490052019-10-21T10:26:09Z2019-10-21T10:26:09ZImporting historical prices manually.<div><p>I am not support staff, just a user.</p>
<p>If you want to use Mikes Security History Loader extension to load a number of security history downloads in one go, you could follow this process.</p>
<ol>
<li>Download each of your security price histories from Yahoo as individual CSV files.<br></li>
<li>In notepad++ open each CSV file in turn and:<br>
a. From the menu click SEARCH – REPLACE to open a window.<br>
b. In the “Find what:” box enter the year, e.g. 2019<br>
c. In the “Replace with:” box enter Security “Ticker,year” e.g. AAPL,2019<br>
d. Click REPLACE ALL. Note if there are entries for more than one year repeat the to add Ticker, in front of each year.<br>
e. FILE - SAVE the file.<br></li>
<li>In notepad++ create a master file, FILE – NEW and copy/paste each of the individual CSV file contents into the master file. Exclude the heading from all but the first copy/paste.<br></li>
<li>Add Ticker, to the first line. E.g. Ticker,Date,Op......<br></li>
<li>Save the master CSV file, FILE – SAVE AS. Make sure you add the extension .csv to the name e.g. Master CSV File.csv See screen shot of master CSV file with two security price histories.<br></li>
<li>In Moneydance temporarily set the date format to the format type used in the CSV file. That is under Preference set date format to yyyy/MM/dd<br></li>
<li>Once installed open the Security History Loader under Extensions.<br></li>
<li>Click CHOOSE FILE and OPEN FILE the master CSV file.<br></li>
<li>Set the select dropdowns as screen shot.<br></li>
<li>Click LOAD DATA. See screen shot example of two securities.<br></li>
<li>Click the box, bottom left, to tick all the SELECT boxes.<br></li>
<li>Click SAVE SELECTED VALUES and CLOSE window.<br></li>
<li>Reset required date format under preferences.</li>
</ol>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/477490052019-10-21T16:54:32Z2019-10-21T16:56:35ZImporting historical prices manually.<div><p>Yes, Mike also suggested that in another thread. It's a way to get historical prices into MD, but it does involve considerable manual manipulation. MD already has a built in Import function for historical prices. One can (still) get a range of historical prices from Yahoo, download as a .csv text file and import that into MD (no extension needed) and it's not necessary to manipulate or even open the .csv file. Seems like far fewer steps. I haven't tried the Security_History_Loader extension, so I'm just theorizing. But I have used the method I described and it is pretty efficient with no failures so far.</p>
<p>It's really too bad that we lost the previously inbuilt MD function to do this all automatically when Yahoo began to block it some years ago. These are all work-arounds. I wonder if InfiniteKind could simply pay Yahoo for the privilege of using their data. Would it be cost prohibitive?</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/477490052019-10-22T19:50:51Z2019-10-22T20:00:22ZImporting historical prices manually.<div><p>Downloading Historical Prices from Yahoo efficiently. OK, playing with the "manual" method a bit more.<br>
1. Make a text list of securities you own with: name of security security_symbol The list should be sorted by MD Account > Portfolio_View > security<br>
2. Go to the Yahoo Finance site and paste the first security_symbol in your list into the "Quote Lookup" search space. A list of choices will drop down, click on your security...it should be at or near the top of the drop-down.<br>
3. The historical prices of your security fills the page. Edit the date range and hit "Apply" Note: pick a useful date range like the end of the last quarter to the present if you reconcile your portfolio quarterly.<br>
4. Then hit "download" and the dialog pop-up will give you a choice to open or save; choose "save." The file should be usefully named something like "QQQ.csv" Note, it is not necessary to open or manipulate this file in any way.<br>
5. Go to the next security on your list and repeat the process, etc. The date range you chose for the first security should stick on the Yahoo site, but you will need to hit, "Apply" for each new security before downloading it. This is really fast! But you can go faster than the Yahoo site! If you do, you'll get a page error. Do a page refresh. You'll then have to reset the date range. So go a bit slower and you'll get no errors.<br>
6. Once you have all your security.csv files, go back to MD > Accounts > Portfolio_View and click on the first security_symbol listed at the top left of the page. The Price_History of that security will open. Do an Import > from_file and navigate to the just downloaded file for that security, and hit "enter." The MD history will look unchanged, so close and re-open to refresh and your new prices will appear. Make sure that the top box with the "current" price is correct.<br>
7. Go back to MD > Accounts > Portfolio_View and repeat with the next security, etc.</p>
<p>After creating my securities list, it took me about 20 minutes to get the histories of 25 securities from Yahoo. It took about the same amount of time to import them into MD. Not as great as the old now-broken (by Yahoo) built-in MD system, but not horrible for a once a quarter process. Note that your will overwrite some prices using this method. Historical prices should remain the same, so this won't be a problem unless you've manually changed a price for some reason. If you own mutual funds, their .csv file will have entries for "high," "low," etc. You could edit them to only have "Close" prices and the "Date" by opening the file in a spreadsheet like Excel, or like me, just import them "as is" and don't worry about the extra meaningless columns.</p>
<p>Although I have a Yahoo user/password, I tested this process w/o logging in and it worked fine. I see that Yahoo has a "Premium" version of the site to monetize it, so this may eventually break this method, but for now it works on the "free" site. Any comment or corrections would be appreciated.</p></div>feffer777