Hello.

I am downloading eps estimates for a particular fiscal year going back into the past. For example I download the 2014 estimate for IBM that the analyst community produced of January 1st 2012...and other days during 2012. I have been able to do this for a single stock and for multiple stocks.

Here is the problem I am having. When I download multiple stocks instead of presenting multiple columns with the date aligned in one column on the left, it stacks the stocks vertically with a different row for each day and each stock. This makes the data much harder for me to use when I download for many tickers at once. I am using the new version of eikon with TR command. Does anybody know if it is possible to download any more efficient format (i.e. with dates aligned in one column on the left)? Thank you so much for any help.

To reproduce my results, take a blank sheet and type this formula in cell A1: =TR("HGTX3.SA;NATU3.SA","TR.EBITDAMedian(AlignType=PrelimOrPeriodEndDate Methodology=WeightedAnnual).date;TR.EBITDAMedian(AlignType=PrelimOrPeriodEndDate Methodology=WeightedAnnual).value","Period=FY2014 SDate=0D EDate=-6AY Frq=CW CH=Fd RH=In",$B$2)

You will see stacked data for EBITDA estimates for two stocks. What I want to see is something like this, below. THANKS!!!

Ticker1 Ticker2

Date1 x x

Date2 x x

Date3 x x

Date4 x x