Macro import link working for Tickers on Yahoo and Google, but not all

%3CLINGO-SUB%20id%3D%22lingo-sub-896033%22%20slang%3D%22en-US%22%3EMacro%20import%20link%20working%20for%20Tickers%20on%20Yahoo%20and%20Google%2C%20but%20not%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-896033%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20attached%20spreadsheet%20a%20developer%20sent%20to%20me.%20It%20works%20to%20import%20prices%20from%20Yahoo%20and%20Google%20finance.%20However%20it%20works%20for%20some%20tickers%20such%20as%20BHP%2C%20but%20not%20ones%20such%20as%20BHP.AX.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20advise%20how%20to%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-896033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Contributor

Hi,

 

I have the attached spreadsheet a developer sent to me. It works to import prices from Yahoo and Google finance. However it works for some tickers such as BHP, but not ones such as BHP.AX.

 

Can anyone please advise how to fix this?

 

Many thanks,