# Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi i need a quick fix of my excel data showing corelation between two stock market fluctuations, the overall volem of the stock i need to buy needs to be takes form opening and closing the session not from the session average as sometimes the stock market drops at the 1 h of start of the session and the it peaks back and the moving average is not great function to calculate thestock price and the volume that the stock market is liste at the end of the session. so the goal is to make data more reliable upon the stock market at close so it actually can be more vialbe for further analysis. can u help me? need a stock market expert
Solved by F. S. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/05/2018 - 03:18
Hi
User 18/05/2018 - 03:18
hi u better be better expert than the one i got before
User 18/05/2018 - 03:18
[REPOST] Hi i need a quick fix of my excel data showing corelation between two stock market fluctuations, the overall volem of the stock i need to buy needs to be takes form opening and closing the session not from the session average as sometimes the stock market drops at the 1 h of start of the session and the it peaks back and the moving average is not great function to calculate thestock price and the volume that the stock market is liste at the end of the session. so the goal is to make data more reliable upon the stock market at close so it actually can be more vialbe for further analysis. can u help me? need a stock market expert
Excelchat Expert 18/05/2018 - 03:19
Sure
User 18/05/2018 - 03:20
did u understand?
Excelchat Expert 18/05/2018 - 03:20
Can you please share the formula which you are using
User 18/05/2018 - 03:20
its not a formula
User 18/05/2018 - 03:21
did u red the text?
User 18/05/2018 - 03:21
did u underatsn what i am trying to achieve?
Excelchat Expert 18/05/2018 - 03:21
let me check again
User 18/05/2018 - 03:21
ok
User 18/05/2018 - 03:21
i already spend 40 minutes with one guy
User 18/05/2018 - 03:21
i got no times to educating you guys here
User 18/05/2018 - 03:21
i thought there are experts here
User 18/05/2018 - 03:22
do you know how sotkc market works?
Excelchat Expert 18/05/2018 - 03:23
Yes
User 18/05/2018 - 03:23
great can u answer how i can create in excel?
Excelchat Expert 18/05/2018 - 03:23
Why don't we pick only the closing values in the Input data range
User 18/05/2018 - 03:23
in need mova
Excelchat Expert 18/05/2018 - 03:24
Sorry
User 18/05/2018 - 03:24
can u create a chart here?
User 18/05/2018 - 03:24
i will explain
Excelchat Expert 18/05/2018 - 03:24
ok
User 18/05/2018 - 03:26
going for cofee
User 18/05/2018 - 03:26
i though u guys are expertsd
Excelchat Expert 18/05/2018 - 03:26
can you please share some base data that I can work and show you the outcome
User 18/05/2018 - 03:27
i do not have here
User 18/05/2018 - 03:27
just take any random strock market data
Excelchat Expert 18/05/2018 - 03:27
ok
User 18/05/2018 - 03:27
daily
User 18/05/2018 - 03:27
can work
Excelchat Expert 18/05/2018 - 03:27
User 18/05/2018 - 03:27
hourly best case
User 18/05/2018 - 03:28
actually hourly
User 18/05/2018 - 03:28
on one day
User 18/05/2018 - 03:28
with columes etc all data needed to create a proper stock price chart
User 18/05/2018 - 03:28
get GE for example
Excelchat Expert 18/05/2018 - 03:33
This query is more on the Financial Modeling than an Excel formula
Excelchat Expert 18/05/2018 - 03:34
I fear I won't be able to help without the detailed case study
User 18/05/2018 - 03:34
excuse me?
User 18/05/2018 - 03:34
[REPOST] Hi i need a quick fix of my excel data showing corelation between two stock market fluctuations, the overall volem of the stock i need to buy needs to be takes form opening and closing the session not from the session average as sometimes the stock market drops at the 1 h of start of the session and the it peaks back and the moving average is not great function to calculate thestock price and the volume that the stock market is liste at the end of the session. so the goal is to make data more reliable upon the stock market at close so it actually can be more vialbe for further analysis. can u help me? need a stock market expert
User 18/05/2018 - 03:35
i thought i precised my question that i need an at least good stock market too
User 18/05/2018 - 03:35
experienced person
User 18/05/2018 - 03:35
why r you losing my time?
Excelchat Expert 18/05/2018 - 03:37
I would like to drop off with your permission, If I am not able to help you.
User 18/05/2018 - 03:39
to drop off?
Excelchat Expert 18/05/2018 - 03:39
yes
Excelchat Expert 18/05/2018 - 03:40
you may close the session if you have no further inputs to share
User 18/05/2018 - 03:40
i would like you to solve my question I have one hour
User 18/05/2018 - 03:40
I paid for one hour
Excelchat Expert 18/05/2018 - 03:40
ok
Excelchat Expert 18/05/2018 - 03:41
let us try to understand the case further
User 18/05/2018 - 03:41
the case is to show the correlation of two stock market prices upon the mova of the stock price
User 18/05/2018 - 03:41
it is simple
User 18/05/2018 - 03:41
but need to do it in excel
Excelchat Expert 18/05/2018 - 03:42
ok
Excelchat Expert 18/05/2018 - 03:42
let me check
Excelchat Expert 18/05/2018 - 03:51
Hi
Excelchat Expert 18/05/2018 - 03:52
Is the case I presented here does seem relevant to what you are looking for?
User 18/05/2018 - 03:57
you ar eperfect at losing other time
User 18/05/2018 - 03:57
i know how to calculate the mova and corelation
Excelchat Expert 18/05/2018 - 03:58
the thing is you need to take the hourly average as dat range in Correl formula
User 18/05/2018 - 03:58
Do you know how stock market chart works?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.