Get spot prices for Gold and Silver using Stock converter

%3CLINGO-SUB%20id%3D%22lingo-sub-2663921%22%20slang%3D%22en-US%22%3EGet%20spot%20prices%20for%20Gold%20and%20Silver%20using%20Stock%20converter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2663921%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20prices%20nicely%20for%20any%20currency%20using%20the%20quotation%20EUR%2FUSD%2C%20Now%20if%20I%20do%20the%20same%20for%20XAU%2FUSD%20or%20XAG%2FUSD%20it%20doesnt%20work.%20I%20found%20out%20that%20i%20can%20input%20Gold%20or%20Silver%20but%20even%20then%20it%20chooses%20a%20stock%20instead%20of%20the%20spot%20price.%20TO%20get%20to%20that%20price%20i%20need%20to%20manually%20search%20in%20the%20data%20selector%26nbsp%3B%40SI0Y%20or%20%40PL0Y.%20I%20need%20to%20be%20doing%20this%20via%20vba%20automoatically%20each%20day%20however.%20Can%20you%20help%20me%20out%20on%20how%20to%20get%20the%20spot%20prices%20for%20gold%20and%20silver%20directly%20and%20not%20doing%20manual%20searches%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethx%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2663921%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

I am getting prices nicely for any currency using the quotation EUR/USD, Now if I do the same for XAU/USD or XAG/USD it doesnt work. I found out that i can input Gold or Silver but even then it chooses a stock instead of the spot price. TO get to that price i need to manually search in the data selector @SI0Y or @PL0Y. I need to be doing this via vba automoatically each day however. Can you help me out on how to get the spot prices for gold and silver directly and not doing manual searches?

 

thx

 

0 Replies