11 Messages
Digest #3937
Messages
Tue Mar 7, 2017 7:35 pm (PST) . Posted by:
gbullr
Had no luck w/ that.
If you have another suggestion I would appreciate it
If you have another suggestion I would appreciate it
Tue Mar 7, 2017 10:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I just copied and pasted what I see in the message on the Yahoo group, and
it worked fine for me.
You are array-entering the formula over a range, right?
On Tue, Mar 7, 2017 at 8:35 PM, gaston.bullrich@
..
wrote:
>
> Had no luck w/ that.
>
> If you have another suggestion I would appreciate it
>
>
it worked fine for me.
You are array-entering the formula over a range, right?
On Tue, Mar 7, 2017 at 8:35 PM, gaston.bullrich@
..
wrote:
>
> Had no luck w/ that.
>
> If you have another suggestion I would appreciate it
>
>
Wed Mar 8, 2017 7:44 am (PST) . Posted by:
gbullr
Ahhhh its the little things in EXCEL.
as per usual you are a supernova within my blackhole of mediocrity...
THANK YOU!!
as per usual you are a supernova within my blackhole of mediocrity..
THANK YOU!!
Tue Mar 7, 2017 9:33 pm (PST) . Posted by:
shane.kelly2222
Hi Again,
I have tried to get this Add-in working on my home laptop, but I am failing and asking for help!
I have a simple task to get some market cap data for a bunch of stock, with plans to add on and make a screener once i can get it working, but it is beating me at the moment. the simple RCHGetElementNumber query is not working on my home laptop, though it works fine on my work computer. my problem is I have to do some work when I am there, and really want to be able to do my personal finance stuff at home.
I installed the add-in to my D drive initially, but have since deleted that and moved it to my C, to check if that was part of the issue- it did not help.
When i put in the code "=RCHGetElementNumber("Version")" i get the correct xla version returned, which tells me it is working. when i input "'=RCHGetElementNumber(A4,941)", I get an "Error" returned value, though the same sheet works perfect on my work pc. Looking at the links, when i "check status", it says the links are working and source open.
i would really appreciate any help trouble shooting this
thanks
Shane
I have tried to get this Add-in working on my home laptop, but I am failing and asking for help!
I have a simple task to get some market cap data for a bunch of stock, with plans to add on and make a screener once i can get it working, but it is beating me at the moment. the simple RCHGetElementNumber query is not working on my home laptop, though it works fine on my work computer. my problem is I have to do some work when I am there, and really want to be able to do my personal finance stuff at home.
I installed the add-in to my D drive initially, but have since deleted that and moved it to my C, to check if that was part of the issue- it did not help.
When i put in the code "=RCHGetElemen
i would really appreciate any help trouble shooting this
thanks
Shane
Attachment(s) from
1 of 1 Photo(s)
1 of 1 File(s)
Tue Mar 7, 2017 10:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Your attached workbook works fine here.
Do this:
1. Close EXCEL
2. Restart EXCEL
3. Open a new workbook
4. Use this formula:
=RCHGetElementNumber("MMM";,941)
What result do you get?
On Tue, Mar 7, 2017 at 10:30 PM, skelly22@
...wrote:
>
> Hi Again,
>
> I have tried to get this Add-in working on my home laptop, but I am
> failing and asking for help!
>
> I have a simple task to get some market cap data for a bunch of stock,
> with plans to add on and make a screener once i can get it working, but it
> is beating me at the moment. the simple RCHGetElementNumber query is not
> working on my home laptop, though it works fine on my work computer. my
> problem is I have to do some work when I am there, and really want to be
> able to do my personal finance stuff at home.
>
> I installed the add-in to my D drive initially, but have since deleted
> that and moved it to my C, to check if that was part of the issue- it did
> not help.
>
> When i put in the code "=RCHGetElementNumber("Version")" i get the
> correct xla version returned, which tells me it is working. when i input
> "'=RCHGetElementNumber(A4,941)", I get an "Error" returned value, though
> the same sheet works perfect on my work pc. Looking at the links, when i
> "check status", it says the links are working and source open.
>
> i would really appreciate any help trouble shooting this
>
>
Do this:
1. Close EXCEL
2. Restart EXCEL
3. Open a new workbook
4. Use this formula:
=RCHGetElementNumbe
What result do you get?
On Tue, Mar 7, 2017 at 10:30 PM, skelly22@
...wrote:
>
> Hi Again,
>
> I have tried to get this Add-in working on my home laptop, but I am
> failing and asking for help!
>
> I have a simple task to get some market cap data for a bunch of stock,
> with plans to add on and make a screener once i can get it working, but it
> is beating me at the moment. the simple RCHGetElementNumber query is not
> working on my home laptop, though it works fine on my work computer. my
> problem is I have to do some work when I am there, and really want to be
> able to do my personal finance stuff at home.
>
> I installed the add-in to my D drive initially, but have since deleted
> that and moved it to my C, to check if that was part of the issue- it did
> not help.
>
> When i put in the code "=RCHGetElemen
> correct xla version returned, which tells me it is working. when i input
> "'=
> the same sheet works perfect on my work pc. Looking at the links, when i
> "check status"
>
> i would really appreciate any help trouble shooting this
>
>
Wed Mar 8, 2017 12:56 am (PST) . Posted by:
shane.kelly2222
unfortunately i get "Error".
i do notice i have to re-point excel to the addin location each time to have it recognize the rch formulas, if this is an indicator of what may be wrong?
i do notice i have to re-point excel to the addin location each time to have it recognize the rch formulas, if this is an indicator of what may be wrong?
Wed Mar 8, 2017 2:53 am (PST) . Posted by:
"shane kelly" shane.kelly2222
Actually, I think I have figured it out- it's my firewall blocking excel
from getting online access. I have turned it off and it's working. Any idea
which component of the excel exe's would need to be added to the firewall
permission list to allow web access? It doesn't seem to be the main "excel"
executable
Shane
from getting online access. I have turned it off and it's working. Any idea
which component of the excel exe's would need to be added to the firewall
permission list to allow web access? It doesn't seem to be the main "excel"
executable
Shane
Wed Mar 8, 2017 5:43 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Maybe the add-in's XLA file?
Otherwise, not a clue.
On Wed, Mar 8, 2017 at 3:27 AM, shane kelly skelly22@
...wrote:
>
> Actually, I think I have figured it out- it's my firewall blocking excel
> from getting online access. I have turned it off and it's working. Any idea
> which component of the excel exe's would need to be added to the firewall
> permission list to allow web access? It doesn't seem to be the main "excel"
> executable
>
Otherwise, not a clue.
On Wed, Mar 8, 2017 at 3:27 AM, shane kelly skelly22@
...wrote:
>
> Actually, I think I have figured it out- it's my firewall blocking excel
> from getting online access. I have turned it off and it's working. Any idea
> which component of the excel exe's would need to be added to the firewall
> permission list to allow web access? It doesn't seem to be the main "excel"
> executable
>
Wed Mar 8, 2017 12:39 pm (PST) . Posted by:
"shane kelly" shane.kelly2222
thanks for all your help!
On 9 March 2017 at 00:43, Randy Harmelink rharmelink@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Maybe the add-in's XLA file?
>
> Otherwise, not a clue.
>
> On Wed, Mar 8, 2017 at 3:27 AM, shane kelly skelly22@
> ...wrote:
>
>>
>> Actually, I think I have figured it out- it's my firewall blocking excel
>> from getting online access. I have turned it off and it's working. Any idea
>> which component of the excel exe's would need to be added to the firewall
>> permission list to allow web access? It doesn't seem to be the main "excel"
>> executable
>>
>
>
>
On 9 March 2017 at 00:43, Randy Harmelink rharmelink@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Maybe the add-in's XLA file?
>
> Otherwise, not a clue.
>
> On Wed, Mar 8, 2017 at 3:27 AM, shane kelly skelly22@
> ...wrote:
>
>>
>> Actually, I think I have figured it out- it's my firewall blocking excel
>> from getting online access. I have turned it off and it's working. Any idea
>> which component of the excel exe's would need to be added to the firewall
>> permission list to allow web access? It doesn't seem to be the main "excel"
>> executable
>>
>
>
>
Wed Mar 8, 2017 7:20 am (PST) . Posted by:
timdutoit
Andy have you perhaps found another source of Japanese quotes.
I am getting tired of typing them from a Google Finance portfolio....
I am getting tired of typing them from a Google Finance portfolio...
Wed Mar 8, 2017 8:27 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Why not just download the portfolio? Copy the URL of the "Download to
Spreadsheet" link, and use it in the smfGetCSVFile() function. Something
like this, array-entered over a range:
=smfGetCSVFile("
https://www.google.com/finance/portfolio?pid=1&output=csv&action=view&pview=sview&ei=xxxxxxxxxx
")
You may need to log in with IE or the EXCEL Web Query dialog, in order to
have the necessary security cookie.
On Wed, Mar 8, 2017 at 8:20 AM, tdutoit@gmx.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Andy have you perhaps found another source of Japanese quotes.
>
> I am getting tired of typing them from a Google Finance portfolio....
>
Spreadsheet" link, and use it in the smfGetCSVFile() function. Something
like this, array-entered over a range:
=smfGetCSVFile("
https://www.google.com/finance/portfolio?pid=1&output=csv&action=view&pview=sview&ei=xxxxxxxxxx
")
You may need to log in with IE or the EXCEL Web Query dialog, in order to
have the necessary security cookie.
On Wed, Mar 8, 2017 at 8:20 AM, tdutoit@gmx.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Andy have you perhaps found another source of Japanese quotes.
>
> I am getting tired of typing them from a Google Finance portfolio...
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar