The Quote Loader third party extension seems to be what you are looking for.
I did a quick search for ticker symbols for Gold and Silver and the Gold prices returned seemed to match the price in your link, see screen shot.
Hi Derek, yes I had read through the pdfs and watched the videos. The GLD is a gold ETF and GC=F is the ticker for gold futures. Both vary from the spot price too much for my purposes. XAU/USD or XAU/CAD are the forex pairs of 1 Oz gold priced in USD and CAD but Yahoo does not list them.
Maybe the developer for the Quote Loader can scrape the investing.com site. It is the site has the most complete historical data in many currencies that I have found. I did not realize that MD converts USD quotes into CAD automatically. Thank you!
How do I change the volume format used in the investing.com historical data, so that MD can read it? It is given in "M" (5.22M) and "K" (300K) rather than whole numbers? I found an Excel formula online that converts whole numbers to millions, but it seems I cannot reverse the calculation because it was rounded. I found that investing.com has all the historical data for securities that are not listed on the Yahoo website.
Here is an update to one of my initial questions: I have been able to reconcile my precious metals investment account by entering a sell transaction for each monthly storage fee that reduces the oz/shares of my metal holdings and in the same transaction record the equivalent CAD in the Fee Category field which reduces the cash balance.
I read in a recent related thread that separating a Sell transaction from a MiscExp transaction may be better for reporting, would this be also true in my case?
I remember how that one person lost 172 thousand dollars, but it was due to the fact that he just started making money and wanted to make money on the stream, but lost. I am sure that none of you wants to lose as much as he did, and in order to avoid such mistakes, you need to study and do it for a sufficient amount of time, or you should just learn it. It is easiest to learn when professionals and people who have been doing this for a long time help you. These are the people who created the site https://forexkings.com , which helps beginners and inept in the topic of trading.
@harold a sell with fee is the same as a sell with no fee and then a miscExp for the fee. I don't see how one is better that the other unless you need to be able to filter Txns certain ways... What are you thinking about it being better? I personally avoid miscxxx txns and prefer to have the fee attached to the sale/buy...