Advertisement
Guest User

Untitled

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