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.