tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/2834-updating-market-pricesInfinite Kind: Discussion 2024-02-10T17:57:15Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-02T19:13:22Z2017-12-02T19:23:10ZUpdating Market Prices <div><p>I am having problems with updating my portfolio, keep getting the 403 error message. Does anyone else have this problem?<br>
Date: 2 Dec 2017</p></div>rennis13tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-02T23:19:26Z2017-12-02T23:19:27ZUpdating Market Prices <div><p>Suggest you search the forums with search term 403....there are many many posts/threads on this topic since November. Yahoo shut down their service and IK has been working on a replacement. You can update prices with a csv file downloaded from, for example, finance.yahoo.com, or try the beta software mentioned in many of the other threads.</p></div>Randy Mackietag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-03T11:51:49Z2017-12-03T11:51:49ZUpdating Market Prices <div><p>I am not support staff, just a user.</p>
<p>There is a beta version of the Q & ER extension out from Sean the lead software developer which uses Alpha Vantage instead of Yahoo. See <a href="https://infinitekind.com/tmp/yahooqt.mxt">https://infinitekind.com/tmp/yahooqt.mxt</a> Remove the old extension and install the new one. Make sure it ends in “.mxt” not “.zip after you download it. Edit zip if required. You must also be running the latest preview build of 2017 downloaded from <a href="https://infinitekind.com/preview">https://infinitekind.com/preview</a><br>
You will be asked to get and enter an Alpha Vantage Key when you first open the extension.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-04T00:37:56Z2017-12-04T00:37:56ZUpdating Market Prices <div><p>Unfortunately Yahoo has turned off their price/rate downloading to third party apps. Our lead developer is working on a solution now and we hope to have an update available for the extension very soon. Sorry for the inconvenience this has caused. I have flagged this discussion so we can notify you as soon as this has been resolved and the update is available.</p>
<p>As Derek states there is a beta version of the extension with a new quote provider. If you are uncomfortable using the beta, we are hoping to go live with a stable version soon.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-04T00:47:40Z2017-12-04T00:47:40ZUpdating Market Prices <div><p>Tom, will the new extension work with MD 2014?</p></div>Nonametag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-04T00:53:23Z2017-12-04T00:53:23ZUpdating Market Prices <div><p>I believe the intention is to have it work on older versions. It shouldn't be much work to update the extension for older versions. The developers are just trying to get all the bugs resolved with the current extension version.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-04T00:57:29Z2017-12-04T00:57:29ZUpdating Market Prices <div><p>That's great news. And thanks for the quick reply.</p></div>Nonametag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-04T02:58:54Z2017-12-04T02:58:54ZUpdating Market Prices <div><p>Tom,<br>
Thank you for your response. I upgraded to a newer version and was not pleased initially. After working with it, I have found it to be a bit of an improvement. All the visuals, bells, and whistles of some well known software only cause more computer work. Moneydance's simplicity was why I purchased it initially. Thanks again,<br>
Jean</p>
<p>----- Original Message -----</p></div>rennis13tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-04T03:27:23Z2017-12-04T03:27:23ZUpdating Market Prices <div><p>As I see it, while it is probably not too difficult or time consuming to update the older extension once all the kinks are ironed out, if the use of AlphaVantage requires a new certificate to be added to Moneydance itself that could be real problem with older releases as I would suspect TIK would not be too keen on doing that.</p>
<p>On a related theme I've noticed a couple of python scripts for bringing down and loading prices from AlphaVantage, does using scripting also require the security certificates?</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T11:10:06Z2017-12-05T11:10:08ZUpdating Market Prices <div><p>Unfortunately the process indicated:<br>
1-download: <a href="https://infinitekind.com/tmp/yahooqt.mxt">https://infinitekind.com/tmp/yahooqt.mxt</a><br>
2-running the latest preview build of 2017 downloaded from <a href="https://infinitekind.com/preview">https://infinitekind.com/preview</a><br>
3 I got an alpha vantage key and</p>
<p>I have Alpha Vantage in quotes and exchange rates</p>
<p>but no downloading</p>
<p>In the console I read: "Import error: skipping invalid line:" Error Message ":" Please make sure your API key is valid. Alternatively, claim your free API key on (<a href="https://www.alphavantage.co/support/#api-key">https://www.alphavantage.co/support/#api-key</a>). It should take less than 20 seconds, and is free permanently. "And this in several lines</p>
<p>-How to remove the clae API and give another one?</p>
<p>On the other hand the quotes are US ? or too all other contry like PARIS</p>
<p>Thank you</p></div>ed delettag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T13:19:06Z2017-12-05T13:19:06ZUpdating Market Prices <div><p>I am not support staff just a user.</p>
<p>At the moment I don't think there is a way to change a entered key. I think it is stored within your data set. I have posted on Sean's Slack channels suggesting he adds a reset button so a new key can be entered. Until he does, I think you are stuck. Unless you have a backup you can restore, a backup before you added the key.<br>
If you post the name and symbol and exchange of say three sectaries I can test them for you.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T13:24:15Z2017-12-05T13:24:16ZUpdating Market Prices <div><p>Thank you Derek. Since I am new to MD, I only had a file with very little<br>
data entered, soooo I created a new file and was able to enter the key<br>
correctly. Was surprised to find out that the key was case sensitive.</p>
<p>Thank you for your help!</p></div>runewhtag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T14:46:31Z2017-12-05T14:46:32ZUpdating Market Prices <div><p>Thank you Derek<br>
If you can test symbol market : EURONEXT-PARIS like RNO, ALO, RMS, LVMH<br>
And I can not find in: Extensions Management list he name of the extension "STOCK QUOTE SYNCHRONIZER" contained in "yahooqt.mxt" ..<br>
thank you</p></div>ed delettag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T15:22:56Z2017-12-05T15:22:56ZUpdating Market Prices <div><p>I am not support staff, just a user.</p>
<p>Under EXTENSIONS _EXTENSION MANAGER the version of Q & ER should be v007.<br>
When I run Q & ER I get the following results<br>
RNO returned €85.31, ALO €34.34, RMS €435.7 however it did not return any data for LVMH all set for Exchange Euronext – Paris.</p>
<p>There is a third party standalone tool into which you can enter a list of symbols and it returns the current Quote Prices. Once entered they are remembered for the next time. This tool works on UK funds stocks and other European Securities. See screen shot for the results of your securities.<br>
This is great for me as I hold mainly UK funds that are in the main not supported by Alpha Vantage. This tool is still at the beta stage of development, but works. You can then export as a CSV file containing all the prices. The only thing is you to need to have java loaded on your computer, as it is a java program. But that was not a problem download from java.com Official Site.<br>
You can then use the Security Price Loader extension from Mike Bray to import the data into Moneydance.</p>
<p>If you won’t more information on this tool just post.</p>
<p>Sorry I don’t understand your question “And I can not find in: Extensions Management list he name of the extension "STOCK QUOTE SYNCHRONIZER" contained in "yahooqt.mxt"”?</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T16:40:44Z2017-12-05T16:40:44ZUpdating Market Prices <div><p>Great got mine working now I had input my api code wrong, was able to use a 4 day old backup of my data file, it then asked my to reinput api code. Backup files for moneydance are held in user account, moneydace, backups.</p></div>francis.inmantag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T17:13:23Z2017-12-05T17:13:24ZUpdating Market Prices <div><p>@derek you:"Sorry I don’t understand your question “And I can not find in: Extensions Management list he name of the extension "STOCK QUOTE SYNCHRONIZER" contained in "yahooqt.mxt"”?" t<br>
My ; look derek2.png above:<br>
---> the extensions named "STOCK QUOTE SYNCHRONIZER" download in yahooqt.mxt is not ---> in list extensions screenshot derek1</p>
<p>And where find tool you are talking about (make >CSV file)</p>
<p>Thank you for your help!</p></div>ed delettag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T17:59:17Z2017-12-05T17:59:17ZUpdating Market Prices <div><p>I am not support staff, just a user.</p>
<p>Yes, install the item in your screen shot. It has just been updated to include a way to retrieve an entered Alpha Vantage key. Now v008</p>
<p>There is a third party standalone tool into which you can enter a list of symbols and it returns the current Quote Prices. Once entered they are remembered for the next time. This tool works on UK funds and two of the three test securities you provided. This is great for me as I hold mainly UK funds that are in the main not supported by Alpha Vantage. This tool is still at the beta stage of development, but works. You can then export as a CSV file containing all the prices. The only thing is you to need to have java loaded on your computer, as it is a java program. But that was not a problem download from java.com Official Site.<br>
Download the hleofxqoutes program from<br>
<a href="https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/test/hleOfxQuotes-gui-Build_20171201_160.zip?raw=true">https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/test/...</a></p>
<p>Right clicking on the Price window allows you to save a CSV file. You can then use the Security Price Loader extension from Mike Bray to import the data into Moneydance. See <a href="https://bitbucket.org/mikerb/moneydance-2015/wiki/Home">https://bitbucket.org/mikerb/moneydance-2015/wiki/Home</a></p>
<p>If you won’t more information on how to use this tool just post</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T18:55:33Z2017-12-05T18:55:34ZUpdating Market Prices <div><p>Thank derek<br>
but<br>
the file hleOfxQuotes-gui-Build_20171201_160…<br>
I don’t save to CSV file only OFX<br>
/ Where is my mistake I am grateful for all your help<br>
ed</p></div>ed delettag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T19:05:53Z2017-12-05T19:05:53ZUpdating Market Prices <div><p>I am not support staff, just a user.</p>
<p>In the price window right click on one of the results to give a menu MD – Save CSV</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T19:14:55Z2024-02-10T17:57:15ZUpdating Market Prices <div><p>Thanks for the beta version of the stock quote updater. It looks like it's working fine for me.</p>
<p>-Chris</p></div>cwieczorektag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T19:27:48Z2017-12-05T19:27:50ZUpdating Market Prices <div><p>@derek It works<br>
good<br>
thank for your help<br>
and in download the update Good with set API Key i change my serial and EUREKA<br>
It download quotes<br>
Good job for the team</p></div>ed delettag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-05T19:30:47Z2017-12-05T19:30:48ZUpdating Market Prices <div><p>Thanks for the stock quote updater.<br>
The button SET API KEY was a good thing<br>
It looks like it's working fine for me<br>
Well done!<br>
team of hell</p></div>ed delettag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822017-12-06T00:01:48Z2017-12-06T00:01:48ZUpdating Market Prices <div><p>I am not a support staff, just a user.</p>
<p>The best and tried/true way of doing this is to File-> Export Backup to<br>
a common directory on the first computer (one that you can move to the<br>
new computer or share*). Once you move the file to the new computer,<br>
important that you rename it to what you want the data to be (and not<br>
the archive name). Locate the file on the drive that you feel most<br>
comfortable with.</p>
<p>Note. It has a habit of building the directory of files for MD as a<br>
subdirectory. This way you could have multiple versions of your data<br>
depending on when you did the export/import. Typically, I build my<br>
directory structure as --<br>
1st level (off of root (or C: drive) as Finances<br>
2nd level as Finances+Finance Data (+ indicates the slash is different<br>
for Linux vs. Windows vs. Mac) for your data<br>
Finances+MoneyDance-20xx for all of the software including any special extensions<br>
Finances+Backup for the back copy of the export. The backup copies of the data always goes on a separate drive from C or<br>
root, like a thumb drive....you never know!<br>
3rd level as Finances+Finance Data+name and version is the directory<br>
that will be created when you import the backup.</p>
<p>On the 2nd computer, do a File->Import from Backup (it might take a<br>
couple of minutes depending on the amount of data. You will need to<br>
re-enter your product key. The IK license terms are very friendly, but<br>
you should read them.</p>
<p>*If you put it on a share, you should delete it (really erase it) since the file is not password protected.</p>
<p>Hope this helps. (I have been doing this for years across any number of<br>
computers and OS's)</p>
<p>Steve Primost</p></div>sprimosttag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822018-01-01T11:43:44Z2018-01-01T11:43:44ZUpdating Market Prices <div><p>I am not support staff, just a user.</p>
<p>For anyone who is interested take a look at this thread on a third-party Quote and Exchange Rate Program from hleofxquotes.<br>
<a href="http://help.infinitekind.com/discussions/investments/3036-third-party-quote-and-exchange-rate-program-from-hleofxquotes?unresolve=true">http://help.infinitekind.com/discussions/investments/3036-third-par...</a></p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/441975822018-01-01T11:44:11Z2018-01-01T11:44:12ZUpdating Market Prices <div><p>Désolé, Vacances</p></div>edeleted