How to identify trends or correlations in time series

%3CLINGO-SUB%20id%3D%22lingo-sub-1337022%22%20slang%3D%22en-US%22%3EHow%20to%20identify%20trends%20or%20correlations%20in%20time%20series%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337022%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20data%20set%20of%20a%20few%20weeks%20which%20includes%20account%20transactions%20per%20date%2C%20and%20also%20the%20corresponding%20premium%2Fdiscount%20on%20the%20day.%20Is%20there%20a%20way%20i%20can%20use%20excel%20to%20identify%20accounts%20which%20have%20recorded%20and%20traded%20when%20the%20premium%2Fdiscount%20is%20better%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20set%20column%20J%20of%20sheet%201%20to%20be%20the%20premium%2Fdiscount%20per%20date.%20Then%20i%20have%20the%20movement%20in%20units%20per%20date%20also%20given%20on%20the%20sheet.%20Is%20there%20a%20way%20to%20identify%20and%20trends%20or%20correlations%20between%20premium%20and%20account%20movement%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20all%20kindly%20for%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1337022%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Contributor

Hi All,

 

I have a data set of a few weeks which includes account transactions per date, and also the corresponding premium/discount on the day. Is there a way i can use excel to identify accounts which have recorded and traded when the premium/discount is better?

 

I have set column J of sheet 1 to be the premium/discount per date. Then i have the movement in units per date also given on the sheet. Is there a way to identify and trends or correlations between premium and account movement?

 

Thank you all kindly for any assistance.

4 Replies
Yes you can do time series trend analysis in Excel. I have custom developed a template that can do a form of time series analysis segmentation automatically. Here is a post I wrote on this forum describing it, and, let me know if this is a technique your are looking to apply: https://techcommunity.microsoft.com/t5/excel/automatically-create-time-series-segments-in-excel/m-p/...
Hi,

Thanks for this, much appreciated. I will have a look.

Kind regards,

@calof1 let me know if you have any questions.

@calof1 I just looked at your data which I did not see before. If you had your data summarized like in the attached sample data sheet, I could help you find time series trends at the accountholder level. I could either sell you a one time report or a template that you could use over and over on your data.