Hello,

I am in dire need of help.

I'm trying to make a detailed stock overview, as mentioned in the title. For that, I'm looking for data that can be updated automatically, as the possibilities "from the internet" gives.
When I try to pull this data, I would like a single cell of data to be placed in a specific sheet and cell. For some reason, I can't get only one cell, without it being the "title" which cannot be implemented separately into the sheet.

- How can I pull a single cell of data, into my spreadsheet?

(I have attached a file, I hope, as an example)

I need data like P/E, Forward P/E, Profit margin, Insider buying, and everything else possible.
I would like these data as historic numbers, so I can make a table showing the data change over time.

- How is this possible, if so?

(again, I have tried attaching two other files as an example)

I hope someone can help, thanks in advance!