1 Message
Digest #3224
Message
Thu Oct 30, 2014 2:24 am (PDT) . Posted by:
tzewei_79
Hi,
I'm using =RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s=ARLP&annual",1,"Operating Income or Loss") to get operation income now. I am converting my long list to point the ticker to a specific cell so that I don't need to change formula from the cell.
I used to be able to do this by =RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol="&A12,1,"Operating Income") where cell A12 is my ticker ARLP.
But I can't do the same with the new hyperlink. =RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s=&annual"&A12,1,"Operating Income or Loss") will show an error.
=RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s="&A12&annual,1,"Operating Income or Loss") will show #VALUE!.
Anyone knows how I can point it correctly?
I'm using =RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s=ARLP&annual",1,"Operating Income or Loss") to get operation income now. I am converting my long list to point the ticker to a specific cell so that I don't need to change formula from the cell.
I used to be able to do this by =RCHGetTableCell("http://investing.money.msn.com/investments/stock-income-statement/?symbol="&A12,1,"Operating Income") where cell A12 is my ticker ARLP.
But I can't do the same with the new hyperlink. =RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s=&annual"&A12,1,"Operating Income or Loss") will show an error.
=RCHGetTableCell("https://sg.finance.yahoo.com/q/is?s="&A12&annual,
Anyone knows how I can point it correctly?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar