4 Messages
Digest #3912
Messages
Tue Feb 7, 2017 6:52 am (PST) . Posted by:
e_bartsch
Nifty. Thanks. I'll install your next beta release to pick up this change. Like everyone else, I appreciate all your hard work on this.
Regards,
Eric
Regards,
Eric
Tue Feb 7, 2017 7:34 am (PST) . Posted by:
caleb.mullins25
Hi,
I need help to pull $403,172 [placed in front of Total Value of Holdings (millions)] from the link below. It works without cell reference but when I try using cell reference for ticker (A1) it gives "Error"
http://www.nasdaq.com/symbol/aapl/institutional-holdings http://www.nasdaq.com/symbol/aapl/institutional-holdings
Thanks in advance for your help
I need help to pull $403,172 [placed in front of Total Value of Holdings (millions)] from the link below. It works without cell reference but when I try using cell reference for ticker (A1) it gives "Error"
http://www.nasdaq.com/symbol/aapl/institutional-holdings http://www.nasdaq.com/symbol/aapl/institutional-holdings
Thanks in advance for your help
Tue Feb 7, 2017 10:43 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Here's what the URL would look like using a cell reference for the ticker
symbol:
="http://www.nasdaq.com/symbol/" & A1 & "/institutional-holdings"
It's concatenating three strings together:
"http://www.nasdaq.com/symbol/"
A1
"/institutional-holdings"
On Tue, Feb 7, 2017 at 7:12 AM, naeem_4tk@
...wrote:
>
> I need help to pull $403,172 [placed in front of Total Value of
> Holdings (millions)] from the link below. It works without cell reference
> but when I try using cell reference for ticker (A1) it gives "Error"
>
> http://www.nasdaq.com/symbol/aapl/institutional-holdings
>
>
symbol:
="http://www.nasdaq.com/symbol/" & A1 & "/institutional-holdings"
It's concatenating three strings together:
"http://www.nasdaq.com/symbol/"
A1
"/institutional-holdings"
On Tue, Feb 7, 2017 at 7:12 AM, naeem_4tk@
...wrote:
>
> I need help to pull $403,172 [placed in front of Total Value of
> Holdings (millions)] from the link below. It works without cell reference
> but when I try using cell reference for ticker (A1) it gives "Error"
>
> http://www.nasdaq.com/symbol/aapl/institutional-holdings
>
>
Tue Feb 7, 2017 12:25 pm (PST) . Posted by:
waterboy5555
Sorry for the late response, but I found the problem. Since I have the add in saved on a server, my excel sheet was referencing the add in from the wrong location. When I deleted the location from the excel code so it just reads =RCHGetTableCell(A31,3,"Net%","Cash";) it pulls in just fine.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar