tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/5276-anybody-found-a-way-of-tracking-precious-metals-bullion-prices-using-quotes-and-exchange-rates-pluginInfinite Kind: Discussion 2020-10-25T20:30:22Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-22T17:43:58Z2020-07-22T17:43:58ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>I am not support staff, just a user.<br>
Hi David</p>
<p>I don’t track commodity prices but there may be a way.</p>
<p>To check I am on the right track can you list a number of commodities, e.g. gold, silver etc and the prices you would expect to see so I can tell what I am finding is what you are looking for.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-22T18:03:30Z2020-07-22T18:03:30ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>Hi Derek,</p>
<p>I'm personally just interested in gold and silver. A good site to see current spot prices is <a href="https://www.jmbullion.com">https://www.jmbullion.com</a> and look below the blue menu bar. For example as of this writing I'm seeing $1868.10 USD for gold and $22.86 USD for silver. Thanks in advance if you figure it out!</p>
<p>David</p></div>david_nedvedtag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-22T18:13:55Z2020-07-22T18:13:55ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>I am not support staff, just a user.<br>
Hi David.<br>
The Quote Loader third party extension seems to be what you are looking for.<br>
I did a quick search for ticker symbols for Gold and Silver plus some other commodities and the prices returned seemed to match your examples, see screen shot.<br>
For information see post 63 at<br>
<a href="https://infinitekind.tenderapp.com/discussions/investments/4914-the-new-quote-loader#comment_48442233">https://infinitekind.tenderapp.com/discussions/investments/4914-the...</a></p>
<p>Download the PDF attached to posts 63 and have a read.</p>
<p>To get an overview take a look at the YouTube videos by using the links on page 1 and 2 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/484793322020-07-22T18:30:03Z2020-07-22T18:30:03ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>Hi Derek,</p>
<p>I'll give it a spin, props for actually writing documentation for it!</p>
<p>2 questions before I make a backup and begin:<br>
- does the extension co-exist with "Quotes and Exchange Rates" or should I uninstall first? - should I set the commodities as currencies or as securities for them to get quotes?</p>
<p>Thanks,</p>
<p>David</p></div>david_nedvedtag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-22T18:37:23Z2020-07-22T18:37:23ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>I am not support staff, just a user.<br>
Hi David.</p>
<p>Most people find that once they start using Quote Loader they don't need "Quotes and Exchange Rates" but they should co-exist.</p>
<p>Set commodities up as Securities, using the tickers in the screen shot.<br>
I would suggest using the source Yahoo or Yahoo HD is you want historical data.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-23T19:51:57Z2020-07-23T19:51:57ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>That's a great plugin, thank you to you and Mike Bray for all the hard work that went into it. I have it updating manually, will see if it auto runs tomorrow.</p>
<p>By any chance is there a way of getting prices on options? I would have never thought to ask before seeing how limited the "Quotes and Exchange Rates" plugin is, but thought it might be worth asking. If so then what is the naming format for an option?</p>
<p>Thank you again!</p></div>david_nedvedtag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-23T20:45:43Z2020-07-23T20:45:43ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>I am not support staff, just a user.<br>
Hi David</p>
<p>Glad you are finding Quote Loader useful.</p>
<p>I doubt either Yahoo or FT support options, but then until I checked I did not know they supported commodities. Quote Loader can only return prices if these sources provide prices on their web pages.<br>
Page 6 of PDF has a link to the two web sites. If you can find data on these sites it may be possible to return prices.</p>
<p>Let us know how you get on.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-26T13:37:43Z2020-07-26T13:37:43ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>Well, Yahoo actually does report option prices and the plug-in takes them. Fantastic coding to work on a data set not tested against!</p>
<p>Now it isn’t actually helpful to me, for both a Moneydance and brokerage reason:</p>
<ul>
<li>
<p>Yahoo reports options prices on a per-share basis (the way they are often talked about in the abstract). My brokerage reports via OFX transactions on a per-contract basis (the way they are actually traded), thus 100x the per-share cost. Neither approach is “wrong”, they just aren’t compatible.</p>
</li>
<li>
<p>This doesn’t even come into play however because I typically sell options, don’t buy them. Thus I begin with a “sell to open” order, essentially going short with a negative transaction. Moneydance seems to ignore negative share counts, thus it doesn’t seem to show any debit at all to offset the credit for the money I receive for selling the contract. Not a big deal but something the devs should probably address at some point.</p>
</li>
</ul>
<p>Anyway, you’ve really helped me by pointing me to this most excellent plug-in. Thank you so much, I am once again totally in love with Moneydance (and for a relationship that’s been going on since 2006 that’s saying something).</p>
<p>David</p></div>david_nedvedtag:infinitekind.tenderapp.com,2009-01-14:Comment/484793322020-07-26T20:24:26Z2020-07-26T20:24:26ZAnybody found a way of tracking precious metals bullion prices using "Quotes and Exchange Rates" plugin?<div><p>I am not support staff, just a user.<br>
Hi David</p>
<p>Is there never an end to all the wonderful things you can do with Quote Loader.</p>
<p>Have Fun, Stay Safe</p></div>derekkent23