Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =INDEX(GETHISTORY("PETR4.SA",1,TODAY()-1),1,5)
- 0 = Last traded price
- 1 = Change in price for the day
- 2 = Opening price of the day
- 3 = High price of the day
- 4 = Low price of the day
- 5 = Volume
- 6 = Average Daily Volume
- 7 = Ask Price
- 8 = Bid Price
- 9 = Book Value
- 10 = Dividend/Share
- 11 = Earnings/Share
- 12 = Earnings/Share Estimate Current Year
- 13 = Earnings/Share Estimate Next Year
- 14 = Earnings/Share Estimate Next Quarter
- 15 = 52-week low
- 16 = Change from 52-week low
- 17 = 52-week high
- 18 = Change from 52-week high
- 19 = 50-day Moving Average
- 20 = 200-day Moving Average
- 21 = Previous Close
- 22 = Price/Earning Ratio
- 23 = Dividend Yield
- 24 = Price/Sales
- 25 = Price/Book
- 26 = PEG Ratio
- 27 = Price/EPS Estimate Current Year
- 28 = Price/EPS Estimate Next Year
- 29 = Short Ratio
- 30 = 1-year Target Price
- =GETQUOTE("PETR4.SA")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement