[smf_addin] Digest Number 4542

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4542

1a

Help with concatenate by "Omar Jaleel" saanajaleel

1b

Re: Help with concatenate by "Randy Harmelink" rharmelink

1c

Re: Help with concatenate by "Omar Jaleel" saanajaleel

1d

Re: Help with concatenate by "Randy Harmelink" rharmelink

Messages

1a

Help with concatenate

Sun May 12, 2019 9:13 am (PDT) . Posted by:

"Omar Jaleel" saanajaleel

Randy

Hope all is well with you. Could you help me figure out why my concatenate
is not working? Here is the formula for GE:

=RCHGetTableCell("
https://www.rocketfinancial.com/Financials.aspx?fID=2120&pw=69918",1,"Total
revenues")

When I try this formula it returns an error:
=RCHGetTableCell("
https://www.rocketfinancial.com/Financials.aspx?fID=&Ticker",1,"Total
revenues")

I've tried different iterations to no avail. Thanks for your help and all
you do for the group.

--
Omar Jaleel
www.jaleellaw.com
www.defenseadvocates.com

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

1b

Re: Help with concatenate

Sun May 12, 2019 10:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Because you've got the concatenation within the literal. You want to
concatenate the literal to the cell reference:

=RCHGetTableCell("https://www.rocketfinancial.com/Financials.aspx?fID="&Ticker,1,"Total
revenues")

On Sun, May 12, 2019 at 9:13 AM Omar Jaleel omar.jaleel@... wrote:

>
> Hope all is well with you. Could you help me figure out why my concatenate
> is not working? Here is the formula for GE:
>
> =RCHGetTableCell("
> https://www.rocketfinancial.com/Financials.aspx?fID=2120&pw=69918",1,"Total
> revenues")
>
> When I try this formula it returns an error:
> =RCHGetTableCell("
> https://www.rocketfinancial.com/Financials.aspx?fID=&Ticker",1,"Total
> revenues")
>
> I've tried different iterations to no avail. Thanks for your help and all
> you do for the group.
>
>
>

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

1c

Re: Help with concatenate

Sun May 12, 2019 1:30 pm (PDT) . Posted by:

"Omar Jaleel" saanajaleel

That formula returns an error as well. Does the formula need the
"&pw=69918"? It appears that every page uses the fID=2120&pw=69918
<https://www.rocketfinancial.com/Financials.aspx?fID=2120&pw=69918> to
identify the stock for example another page is
https://www.rocketfinancial.com/Financials.aspx?fID=20906&p=2&i=3&pw=689856&rID=1&tID=1&stID=1&segID=-1

All my formulas without using the Ticker cell work fine.

Thanks

On Sun, May 12, 2019 at 12:28 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Because you've got the concatenation within the literal. You want to
> concatenate the literal to the cell reference:
>
> =RCHGetTableCell("https://www.rocketfinancial.com/Financials.aspx?fID="&Ticker,1,"Total
> revenues")
>
> On Sun, May 12, 2019 at 9:13 AM Omar Jaleel omar.jaleel@... wrote:
>
>>
>> Hope all is well with you. Could you help me figure out why my
>> concatenate is not working? Here is the formula for GE:
>>
>> =RCHGetTableCell("
>> https://www.rocketfinancial.com/Financials.aspx?fID=2120&pw=69918",1,"Total
>> revenues")
>>
>> When I try this formula it returns an error:
>> =RCHGetTableCell("
>> https://www.rocketfinancial.com/Financials.aspx?fID=&Ticker",1,"Total
>> revenues")
>>
>> I've tried different iterations to no avail. Thanks for your help and all
>> you do for the group.
>>
>>
>>
>

--
Omar Jaleel
www.jaleellaw.com
www.defenseadvocates.com

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

1d

Re: Help with concatenate

Sun May 12, 2019 2:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't answer that. I don't have access to the web pages, so I have no
idea which parameters may be necessary.

Since you need to be logged in to access the web pages, have you created
the necessary security cookie using the IE object from within EXCEL
(keyboard shortcut alt+d+d+w)? You need to do that so EXCEL and the add-in
can access secure web pages.

On Sun, May 12, 2019 at 1:30 PM Omar Jaleel omar.jaleel@... wrote:

>
> That formula returns an error as well. Does the formula need the
> "&pw=69918"? It appears that every page uses the fID=2120&pw=69918
> <https://www.rocketfinancial.com/Financials.aspx?fID=2120&pw=69918> to
> identify the stock for example another page is
> https://www.rocketfinancial.com/Financials.aspx?fID=20906&p=2&i=3&pw=689856&rID=1&tID=1&stID=1&segID=-1
>
> All my formulas without using the Ticker cell work fine.
>
>
>

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use