This is the formula I use to check the price of, say, YHOO, at close , from 6 days ago.
= INDEX( GoogleFinance( "YHOO" ; "Close" ; TODAY()-6 ) ; 2 ; 2 )
The problem is that it registers dat 360 days a year and I don't know how to configure it to register data from workdays only.
Thanks! A LOT!
ps: I use google docs instrad of excel.. That´s ok right?
= INDEX( GoogleFinance( "YHOO" ; "Close" ; TODAY()-6 ) ; 2 ; 2 )
The problem is that it registers dat 360 days a year and I don't know how to configure it to register data from workdays only.
Thanks! A LOT!
ps: I use google docs instrad of excel.. That´s ok right?
