2 New Messages

Digest #2285

Re: Thank you - That's it! by "Victor" vkiarsis

group query with smfGetADVFNElement by "Koushik Krishnan" notkoushik

Messages

1a

Re: Thank you - That's it!

Fri Jul 20, 2012 10:49 am (PDT) . Posted by:

"Victor" vkiarsis

Ditto -- a great add in. thanks for the work and for making it very flexible and extensible.

best regards,

Victor Kiarsis

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2 group query with smfGetADVFNElement

Sat Jul 21, 2012 1:00 am (PDT) . Posted by:

Hi Randy,
Does smfGetADVFNElement support single web query for a group of elements -just like how RCHGetYahooHistory does it? I am trying to avoid multiple queries to access the data that is mostly available in the same table.

For instance:
=smfGetAdvFNElement("NYSE:SHW","A",2,"Total Revenue") returns 7979.7

Can I use the same routine like this -
{=smfGetAdvFNElement("NYSE:SHW","A",2,3,"Total Revenue","cost of sales")} to return 7776.4 4120
7094.2 3660.2

It looks like smfGetAdvFNElement will need arguements like RCGGetYahooHistory. Or maybe I have to use RCHGetHTMLTable/RCHGetTableCell - which I am not too familiar with. It would be great if you can give me an example.

thanks
Koushik