• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Google Docs help?

S

stang3O2

n00b
Joined
Dec 3, 2011
Messages
21
Feeling like an idiot here. I'm trying to write a formula that will give me the highest price the stock has traded since a specific date through today and I keep getting this 41549.6666666667 as the result.
If I change the max to min in the "high" formula it gives me the lowest high since the date but when I change it to max it gives me this 41k number. I was told that 41k # was some sort of date but not sure how to fix it. If you change the stock ticker it gives the same 41k result.

=max(GoogleFinance("F","high", "01/22/2013",today(),"1"))

41549.666666667



My other formula to find the low since a specific date works-
=min(GoogleFinance("AAPL","low", "01/01/2013",now(),"1"))

Can someone tell me how to get fix this?
Thanks!
 
You must log in or register to reply here.
Back
Top