Kamis, 30 Oktober 2014

[smf_addin] Digest Number 3224

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?


For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar