0

I want to get the list of weekly close Values of a Ticker. But they should begin with the newest date.

=GOOGLEFINANCE(XYL; "price"; $F$31;HEUTE();"WEEKLY")

or

=GOOGLEFINANCE(XYL; "price"; HEUTE(); $F$31;"WEEKLY")

show the same result. With this code I get the values, but the first colum is the value of the oldest date.

enter image description here

I want it to start with the newest Date. Is there a build in function that just flips the order of the List?

Best regards!

Max
  • 25
  • 5

1 Answers1

1

Could you simply use SORT(range,1,false) for the info the GOOGLEFINANCE() displays? You can do a simple sort to a new range or to flip the google finance without moving anything around you would:

=SORT((GOOGLEFINANCE(XYL; "price"; HEUTE(); $F$31;"WEEKLY")),1,false)
sweetswebb
  • 26
  • 3