Stock Data: Volume Average

%3CLINGO-SUB%20id%3D%22lingo-sub-1125210%22%20slang%3D%22en-US%22%3EStock%20Data%3A%20Volume%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1125210%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20unable%20to%20verify%20what%20volume%20average%20is%20being%20used%20when%20syncing%20data%20on%20stocks.%20For%20example%2C%20if%20I%20input%20Amazon%20in%20cell%20A1%20and%20use%20the%20formula%20%3DA1.%5BVolume%20average%5D%20it%20gives%20me%20a%20number%20but%20I%20cannot%20find%20that%20same%20number%20anywhere%20else%20online%20to%20confirm%20it%20is%20correct%20or%20what%20time%20period%20it%20is%20using%20for%20the%20volume%20average.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20Excel%20is%20pulling%20data%20from%20Nasdaq%20but%2C%20again%2C%20I%20cannot%20match%20the%20number%20that%20is%20updated%20in%20the%20spreadsheet%20with%20any%20numbers%20under%20Amazon's%20quote%20on%20Nasdaq's%20website.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20from%20where%20it%20is%20pulling%20the%20Volume%20average%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1125210%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1125299%22%20slang%3D%22en-US%22%3ERe%3A%20Stock%20Data%3A%20Volume%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1125299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F523090%22%20target%3D%22_blank%22%3E%40CarltonSW%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20in%20case%2C%20more%20about%20data%20providers%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fabout-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fabout-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EHave%20no%20idea%20about%20Volume%20Average.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I have been unable to verify what volume average is being used when syncing data on stocks. For example, if I input Amazon in cell A1 and use the formula =A1.[Volume average] it gives me a number but I cannot find that same number anywhere else online to confirm it is correct or what time period it is using for the volume average.

 

I know Excel is pulling data from Nasdaq but, again, I cannot match the number that is updated in the spreadsheet with any numbers under Amazon's quote on Nasdaq's website.

 

Does anyone know from where it is pulling the Volume average data?

2 Replies

@CarltonSW 

Just in case, more about data providers is here https://support.office.com/en-us/article/about-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6

Have no idea about Volume Average.

@CarltonSW 

Were you able to get hold of the documentation of the definitions of Stock Data Attributes like Beta and Volume Average ?