Home

Find Time weighted return for each category

%3CLINGO-SUB%20id%3D%22lingo-sub-723315%22%20slang%3D%22en-US%22%3EFind%20Time%20weighted%20return%20for%20each%20category%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-723315%22%20slang%3D%22en-US%22%3E%3CP%3EAttached%20is%20a%20spreadsheet%20showing%20how%20to%20calculate%20time%20weighted%20return%20for%20a%20share.%20However%20my%20data%20has%20multiple%20shares%20in%20it.%20Is%20there%20a%20way%20the%20formula%20can%20be%20adapted%20to%20only%20read%20data%20matching%20a%20certain%20criteria.%20For%20example%20on%20read%20for%20data%20for%20BHP%2C%20then%20FXL%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20kindly%20for%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-723315%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%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
calof1
Contributor

Attached is a spreadsheet showing how to calculate time weighted return for a share. However my data has multiple shares in it. Is there a way the formula can be adapted to only read data matching a certain criteria. For example on read for data for BHP, then FXL etc.

 

Thank you kindly for any assistance.

Related Conversations