Home

Download Financial Information directly to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-760114%22%20slang%3D%22en-US%22%3EDownload%20Financial%20Information%20directly%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-760114%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20example%20online%20which%20are%20able%20to%20download%20information%20regarding%20shares%20directly%20into%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20i%20have%20been%20unable%20to%20get%20the%20macro%20to%20work.%20I%20have%20attached%20an%20example%20of%20the%20information%20included.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-760114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762201%22%20slang%3D%22en-US%22%3ERe%3A%20Download%20Financial%20Information%20directly%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762201%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20the%20instructions%20in%20your%20spreadsheet%2C%20it%20looks%20like%20a%20Google%20Spreadsheet.%20The%20formulae%20written%20for%20Google%20will%20not%20work%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
calof1
Contributor

Hi,

 

I have seen example online which are able to download information regarding shares directly into excel.

 

However i have been unable to get the macro to work. I have attached an example of the information included.

 

Can someone please assist.

 

Kind regards,

1 Reply

Hi @calof1 

From the instructions in your spreadsheet, it looks like a Google Spreadsheet. The formulae written for Google will not work in Excel.