TLT link not working

24 views
Skip to first unread message

tripoli...@gmail.com

unread,
Mar 6, 2016, 10:43:36 PM3/6/16
to Google Finance
Working on a spreadsheet GoogleFinance (), not working for TLT( Treasure bond ETF)
Looks like below. Note how data stops for TLT after 2/1/16. If I put IEI into TLT cell I get full data, If I put TLT into IEI I get partial data matching this post. Does anyone else have this problem? Is thered a fix? thanks
IEIIEITLTTLT
CLOSECLOSECLOSECLOSE
1/7/20161/7/20161/7/20161/7/2016
40404040
1111
DateCloseDateClose
1/7/2016 16:00:00123.551/7/2016 16:00:00122.81
1/8/2016 16:00:00123.81/8/2016 16:00:00123.36
1/11/2016 16:00:00123.651/11/2016 16:00:00122.01
1/12/2016 16:00:00123.881/12/2016 16:00:00123.77
1/13/2016 16:00:00124.131/13/2016 16:00:00124.99
1/14/2016 16:00:00124.11/14/2016 16:00:00123.82
1/15/2016 16:00:00124.441/15/2016 16:00:00125.752
1/19/2016 16:00:00124.321/19/2016 16:00:00125.36
1/20/2016 16:00:00124.651/20/2016 16:00:00126.68
1/21/2016 16:00:00124.531/21/2016 16:00:00125.82
1/22/2016 16:00:00124.351/22/2016 16:00:00125.34
1/25/2016 16:00:00124.481/25/2016 16:00:00126.02
1/26/2016 16:00:00124.591/26/2016 16:00:00126.08
1/27/2016 16:00:00124.671/27/2016 16:00:00126.05
1/28/2016 16:00:00124.821/28/2016 16:00:00126.23
1/29/2016 16:00:00125.241/29/2016 16:00:00127.3
2/1/2016 16:00:00124.872/1/2016 16:00:00126.67
2/2/2016 16:00:00125.38
2/3/2016 16:00:00125.41
2/4/2016 16:00:00125.53
2/5/2016 16:00:00125.54
2/8/2016 16:00:00126.03
2/9/2016 16:00:00125.99
2/10/2016 16:00:00126.14
2/11/2016 16:00:00126.34
2/12/2016 16:00:00125.9
2/16/2016 16:00:00125.74
2/17/2016 16:00:00125.56
2/18/2016 16:00:00125.85
2/19/2016 16:00:00125.74
2/22/2016 16:00:00125.71
2/23/2016 16:00:00125.81
2/24/2016 16:00:00125.85
2/25/2016 16:00:00126.07
2/26/2016 16:00:00125.73
2/29/2016 16:00:00125.78
3/1/2016 16:00:00125.07
3/2/2016 16:00:00124.96
3/3/2016 16:00:00124.97
Reply all
Reply to author
Forward
0 new messages