**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

Please give me sometime then

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.*