portfolio challenge in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1516357%22%20slang%3D%22en-US%22%3Eportfolio%20challenge%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516357%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20made%20an%20excel%20document%20for%20my%20portfolio%20and%20for%20following%20various%20shares%3C%2FP%3E%3CP%3Eit's%20fairly%20easy%20-%20but%20I%20miss%20one%20thing%20-%20that%20I%20know%20can%20be%20made%20i%20google%3C%2FP%3E%3CP%3EI%20would%20like%20to%20integrate%20a%20chart-line%20for%20the%20last%2090%20days%20in%20a%20column%20for%20each%20share%3C%2FP%3E%3CP%3Ecan%20anyone%20tell%20me%20how%20to%20do%20it%20-%20and%20from%20where%20I%20can%20fetch%20the%20chart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516357%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516401%22%20slang%3D%22en-US%22%3ERe%3A%20portfolio%20challenge%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725702%22%20target%3D%22_blank%22%3E%40tinke10%3C%2FA%3E%26nbsp%3B%20Looks%20like%20you%20need%20the%20new%20STOCKHISTORY%20function.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fannouncing-stockhistory%2Fba-p%2F1404338%22%20target%3D%22_blank%22%3EAnnouncing%20STOCKHISTORY%20-%20Microsoft%20Tech%20Community%20-%201404338%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20the%20lucky%2050%25%20in%20the%20Beta%20channel%2C%20that%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EDisclaimer%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESTOCKHISTORY%20is%20currently%20available%20to%2050%25%20of%26nbsp%3BMicrosoft%20365%20Subscribers%20in%20the%20Beta%20level%20of%20the%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fjoin%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOffice%20Insider%20program%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%3E.%20The%20behavior%20and%20signature%20of%20this%20function%20is%20subject%20to%20change.%20Releasing%20this%20way%20allows%20us%20to%20get%20early%20feedback%20to%20prepare%20for%20a%20broader%20release.%20This%20function%20will%20only%20be%20available%20to%20Microsoft%20365%20customers%20who%20are%20signed%20in.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516411%22%20slang%3D%22en-US%22%3ERe%3A%20portfolio%20challenge%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516411%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725702%22%20target%3D%22_blank%22%3E%40tinke10%3C%2FA%3E%26nbsp%3BHello%20Friend%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirstly%20try%20attaching%20the%20file%20in%20English%20Language.%3C%2FP%3E%3CP%3ESecondly%20I%20think%20you%20want%20a%20chart%20line%20of%20past%2090%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20integrate%20this%20but%20for%20that%20please%20find%20the%20website%20where%20the%20shares%20History%20is%20maintained%20and%20from%20there%20using%20Webquery%20you%20can%20Import%20any%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20get%20this%20done%20you%20contact%20me%20privately%20therein%20I%20will%20give%20you%20My%20mail%20Id%20and%20then%20we%20can%20connect%20through%20mail%20and%20solve%20your%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20%26amp%3B%20Regards%2C%3C%2FP%3E%3CP%3EDevendra%20Jain%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I've made an excel document for my portfolio and for following various shares

it's fairly easy - but I miss one thing - that I know can be made i google

I would like to integrate a chart-line for the last 90 days in a column for each share

can anyone tell me how to do it - and from where I can fetch the chart

2 Replies

@tinke10  Looks like you need the new STOCKHISTORY function.

Announcing STOCKHISTORY - Microsoft Tech Community - 1404338

 

If you are the lucky 50% in the Beta channel, that is.

 

Disclaimer

STOCKHISTORY is currently available to 50% of Microsoft 365 Subscribers in the Beta level of the Office Insider program. The behavior and signature of this function is subject to change. Releasing this way allows us to get early feedback to prepare for a broader release. This function will only be available to Microsoft 365 customers who are signed in.

@tinke10 Hello Friend,

 

Firstly try attaching the file in English Language.

Secondly I think you want a chart line of past 90 days.

 

You can integrate this but for that please find the website where the shares History is maintained and from there using Webquery you can Import any data

 

If you want to get this done you contact me privately therein I will give you My mail Id and then we can connect through mail and solve your query.

 

Thanks & Regards,

Devendra Jain