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 G. W. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/05/2018 - 03:02
Hello Welcome to Gotit pro, your problem will be highly answered here. May I ask how may I help you?
User 18/05/2018 - 03:03
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:03
I am currently analyzing your question
Excelchat Expert 18/05/2018 - 03:03
:)
Excelchat Expert 18/05/2018 - 03:03
do you have your data?
User 18/05/2018 - 03:03
Ok please hurru i got no much time
User 18/05/2018 - 03:03
no
User 18/05/2018 - 03:04
no data
User 18/05/2018 - 03:04
i need concept
Excelchat Expert 18/05/2018 - 03:04
we can't able to create solution for this If we don't have a data
User 18/05/2018 - 03:05
why u let me my ticket run then?
Excelchat Expert 18/05/2018 - 03:05
Im sorry, I thought you will upload it
User 18/05/2018 - 03:06
U SORRY?
User 18/05/2018 - 03:06
dont sorry euither help or give me 10$ back
User 18/05/2018 - 03:06
i siad i need a stock market expert
User 18/05/2018 - 03:06
with excel help
Excelchat Expert 18/05/2018 - 03:06
I can help you to create function, how ever need some info for us to begin
Excelchat Expert 18/05/2018 - 03:07
I'm good with stock market too
User 18/05/2018 - 03:07
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:07
great pelase help me with this hten
User 18/05/2018 - 03:07
create a volume chart
User 18/05/2018 - 03:07
with price
Excelchat Expert 18/05/2018 - 03:07
ok i will try my best for this one
User 18/05/2018 - 03:09
have u ever seen a stock market chart before?
User 18/05/2018 - 03:09
have u ever seen a srock market chart before?
Excelchat Expert 18/05/2018 - 03:09
yes,
Excelchat Expert 18/05/2018 - 03:09
I am creating table first then will show u a chart
User 18/05/2018 - 03:10
dude
User 18/05/2018 - 03:10
eductae yourself
Excelchat Expert 18/05/2018 - 03:10
Im sorry, will show you the chart one the table once done
Excelchat Expert 18/05/2018 - 03:11
we can't show up graph until we dont have table
User 18/05/2018 - 03:11
i need serious help
User 18/05/2018 - 03:11
i need serious help
User 18/05/2018 - 03:11
not some bullshit
Excelchat Expert 18/05/2018 - 03:11
im sorry, this was only a sample, unless you have the actual data
User 18/05/2018 - 03:12
what the hell isthis
User 18/05/2018 - 03:12
i mean stock market
User 18/05/2018 - 03:12
fluctuations
User 18/05/2018 - 03:12
are you guys for real????????????
User 18/05/2018 - 03:13
and this is 10$ support?
User 18/05/2018 - 03:13
are you nuts?
User 18/05/2018 - 03:13
stop wasting my time
Excelchat Expert 18/05/2018 - 03:13
i'm sorry, this was only we can do, far from stock market that was already out of our scope
Excelchat Expert 18/05/2018 - 03:13
:(
User 18/05/2018 - 03:13
i need excel expert with basic stock markte knowledge
User 18/05/2018 - 03:13
what?
User 18/05/2018 - 03:13
why u take a ticket then?
User 18/05/2018 - 03:13
and lose my money?
Excelchat Expert 18/05/2018 - 03:14
im sorry,
User 18/05/2018 - 03:14
if i was here to do line graph i would hire my 4 years daughter for doing so
User 18/05/2018 - 03:14
dont be sorry
User 18/05/2018 - 03:14
either help ofr take another
User 18/05/2018 - 03:14
expert
User 18/05/2018 - 03:14
please
User 18/05/2018 - 03:14
this is some serious bullshit
Excelchat Expert 18/05/2018 - 03:14
probably some expert could help with this
User 18/05/2018 - 03:15
then when they put me to some random amatour
User 18/05/2018 - 03:15
why?
User 18/05/2018 - 03:15
i need an expert
User 18/05/2018 - 03:15
EXPERT
Excelchat Expert 18/05/2018 - 03:15
I believe we have free session, you could end this session and raise it again
User 18/05/2018 - 03:15
give me another expert plz
User 18/05/2018 - 03:15
i paid 10$
User 18/05/2018 - 03:16
for this shit
Excelchat Expert 18/05/2018 - 03:16
you paid for 1 month free session I believe

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc