I want to make a stock portfolio, with live updated key figures, prices and graphs

%3CLINGO-SUB%20id%3D%22lingo-sub-2653934%22%20slang%3D%22en-US%22%3EI%20want%20to%20make%20a%20stock%20portfolio%2C%20with%20live%20updated%20key%20figures%2C%20prices%20and%20graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2653934%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20am%20in%20dire%20need%20of%20help.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20trying%20to%20make%20a%20detailed%20stock%20overview%2C%20as%20mentioned%20in%20the%20title.%20For%20that%2C%20I'm%20looking%20for%20data%20that%20can%20be%20updated%20automatically%2C%20as%20the%20possibilities%20%22from%20the%20internet%22%20gives.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EWhen%20I%20try%20to%20pull%20this%20data%2C%20I%20would%20like%20a%20single%20cell%20of%20data%20to%20be%20placed%20in%20a%20specific%20sheet%20and%20cell.%20For%20some%20reason%2C%20I%20can't%20get%20only%20one%20cell%2C%20without%20it%20being%20the%20%22title%22%20which%20cannot%20be%20implemented%20separately%20into%20the%20sheet.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E-%20How%20can%20I%20pull%20a%20single%20cell%20of%20data%2C%20into%20my%20spreadsheet%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22aaaaaaaaaaaaaaaaaa.PNG%22%20style%3D%22width%3A%20731px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303585i010A49E9FDAFEA69%2Fimage-dimensions%2F731x50%3Fv%3Dv2%22%20width%3D%22731%22%20height%3D%2250%22%20role%3D%22button%22%20title%3D%22aaaaaaaaaaaaaaaaaa.PNG%22%20alt%3D%22aaaaaaaaaaaaaaaaaa.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20need%20data%20like%20P%2FE%2C%20Forward%20P%2FE%2C%20Profit%20margin%2C%20Insider%20buying%2C%20and%20everything%20else%20possible.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20would%20like%20these%20data%20as%20historic%20numbers%2C%20so%20I%20can%20make%20a%20table%20showing%20the%20data%20change%20over%20time.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E-%20How%20is%20this%20possible%2C%20if%20so%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222222.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303588i950008375DA9FE06%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222222.PNG%22%20alt%3D%222222.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22333333333.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303589iDD84BB22EDCB0649%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22333333333.PNG%22%20alt%3D%22333333333.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%E2%80%83%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%3EI%20hope%20someone%20can%20help%2C%20thanks%20in%20advance!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2653934%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2660585%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20make%20a%20stock%20portfolio%2C%20with%20live%20updated%20key%20figures%2C%20prices%20and%20graphs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1129795%22%20target%3D%22_blank%22%3E%40nyboe2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20a%20lot%20easier%20to%20offer%20specific%20help%20if%20you%20uploaded%20a%20copy%20of%20your%20actual%20workbook%2Fspreadsheets.%20Images%20help%20a%20little%2C%20but%20one%20can't%20actually%20DO%20anything%20with%20them%20other%20than%20look%20at%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20said%2C%20if%20general%20advice%20is%20all%20you%20need%2C%20I%20suggest%20you%20familiarize%20yourself%20with%20functions%20like%3A%3C%2FP%3E%3CP%3EXLOOKUP%3C%2FP%3E%3CP%3EINDEX%20and%20MATCH%20used%20together%3C%2FP%3E%3CP%3EVLOOKUP%3C%2FP%3E%3CP%3EHere's%20a%20website%20that%20might%20help%20if%20you're%20comfortable%20doing%20your%20own%20research.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

aaaaaaaaaaaaaaaaaa.PNG

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?

2222.PNG

333333333.PNG

  


I hope someone can help, thanks in advance!

1 Reply

@nyboe2020 

 

It would be a lot easier to offer specific help if you uploaded a copy of your actual workbook/spreadsheets. Images help a little, but one can't actually DO anything with them other than look at them.

 

That said, if general advice is all you need, I suggest you familiarize yourself with functions like:

XLOOKUP

INDEX and MATCH used together

VLOOKUP

Here's a website that might help if you're comfortable doing your own research. https://exceljet.net