Export financial data to excel

Avatar
Jenseits
  • updated

Hi SA Team,

I've tried to download the financial data from different stock to excel. Sandy, it's all in text format. I'll try several things to change the format to numbers but nothing seems to work. I don't want to manually add every single number in my model or to manually change every single cell format. Therefore, please I need your help.is it there a solution? Did someone have the same problem?


Thanks in advance. Bye!

Replies 5
Avatar
2
rz130

I'm having the same problem, in fact the data doesn't even reveal the whole picture of what I wanted, it only displays bits of what I want 

Avatar
1
eazar001

Text? I don't even have THAT option anymore.

Avatar
1
auroramonk

Yeah, now I can't download anything but a pdf.  How am I supposed to load that data into programs that calculate metrics?  By hand?

Avatar
1
DeepThought43
Quote from auroramonk

Yeah, now I can't download anything but a pdf.  How am I supposed to load that data into programs that calculate metrics?  By hand?

Various PDF readers will allow you to save the PDF in Text format (e.g. Foxit, et al) which Excel can import.  Just tell it to "save as" in TXT format.  Then you have to do a lot of programming the actually locate and isolate what you're trying to access.  It's entirely doable though.

Other PDF readers (e.g. PDF-XChange) allow you to export directly to Excel.  Again, lots of programming is then required to isolate what your really want.

Avatar
-1
Mr. Hancock

Image 139469

This is how the export looks like. This can't be serious.