JMiguez
unread,Apr 20, 2012, 5:14:21 PM4/20/12Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Google Finance
Support,
Problem:
Average volume used in finance market is 50 days.
Presently google finance makes the average for 30 days.
Problem replication:
A) Google Finance
When a stock is displayed, let's say FRAN, (Friday April 20, after
market closed)
Vol / Avg. 887,335.00/766,292.00
B) Google Documents
When the function is used, =GoogleFinance("FRAN", "volumeavg")
Ask for change:
Move from 30 days to 50 days.
Optional:
A) Google Finance
Under settings, when the volume is checked ON, a box should be
displayed as Vol. Ave. and the user could type their own settings.
B) Google Finance
Using the same formula, the user could type the volume average for any
amount of days by adding the value after the attribute "volumeavg".
=GoogleFinance("FRAN", "volumeavg50") //For an average volume of 50
days.
=GoogleFinance("FRAN", "volumeavg200") //For an average volume of 200
days.
=GoogleFinance("FRAN", "volumeavg30") //For an average volume of 30
days.
Thank you in advanced.