External data grab linked to a reference cell

External data grab linked to a reference cell


I am trying to set up an external data link - namely, pulling in the current price of a stock (can be from anywhere...Yahoo, Google, etc). I want to set the function up such that the stock symbol is entered in another cell and my external data link knows to grab that for the operation. In excel there was an add-in function that allowed me to scrape data this way. Here is a sample of the string used: RCHGetTableCell("http://finance.yahoo.com/q/ae?s="&$A7;3;">Revenue Est";" Avg. Estimate ") Note that the symbol would be located in cell A7. This allowed easy cut and paste of the formula. Can I/How do I do this on Zoho ?
jhellman