SHARE
TWEET

Untitled

a guest Jul 15th, 2019 79 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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")
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top