Sabtu, 02 Maret 2013

[smf_addin] Digest Number 2529[4 Attachments]

15 New Messages

Digest #2529

Messages

Fri Mar 1, 2013 8:17 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

Thank you.

I get this

[Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)] for RCHGetElementNumber("Version")
and blank for smfGetAParms(2742)

and I can also view the page using excel web.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> They're working fine here. What do you get for:
>
> =RCHGetElementNumber("Version")
> =smfGetAParms(2742)
>
> Do you see the appropriate web page when you go to this URL in the EXCEL
> Web Query dialog?
>
> http://www.google.com/finance?fstype=ii&q=AAPL
>
> On Fri, Mar 1, 2013 at 7:28 PM, jasonhuangcam wrote:
>
> >
> > I have trouble with using RCHGetElementNumber to get financial statement
> > data from all the elements (ranges from 2742 to 3973) from Google finance.
> > It always return Error but others like yahoo or msn works fine.
> >
>

Fri Mar 1, 2013 8:32 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

Hi,

I get this

[Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)] for
=RCHGetElementNumber("Version")
and
[Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(except for per share items); ; ;0;




smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> They're working fine here. What do you get for:
>
> =RCHGetElementNumber("Version")
> =smfGetAParms(2742)
>
> Do you see the appropriate web page when you go to this URL in the EXCEL
> Web Query dialog?
>
> http://www.google.com/finance?fstype=ii&q=AAPL
>
> On Fri, Mar 1, 2013 at 7:28 PM, jasonhuangcam wrote:
>
> >
> > I have trouble with using RCHGetElementNumber to get financial statement
> > data from all the elements (ranges from 2742 to 3973) from Google finance.
> > It always return Error but others like yahoo or msn works fine.
> >
>

Fri Mar 1, 2013 8:40 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

Oh My Goodness.

For =smfGetAParms(2742), sometimes I get blank result and sometimes get the [Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(except for per share items); ; ;0;


smf_addin@yahoogroups.com, "jasonhuangcam" wrote:
>
> Hi,
>
> I get this
>
> [Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)] for
> =RCHGetElementNumber("Version")
> and
> [Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(except for per share items); ; ;0;
for smfGetAParms(2742)
>
> and I can also view the page using excel web.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
> >
> > They're working fine here. What do you get for:
> >
> > =RCHGetElementNumber("Version")
> > =smfGetAParms(2742)
> >
> > Do you see the appropriate web page when you go to this URL in the EXCEL
> > Web Query dialog?
> >
> > http://www.google.com/finance?fstype=ii&q=AAPL
> >
> > On Fri, Mar 1, 2013 at 7:28 PM, jasonhuangcam wrote:
> >
> > >
> > > I have trouble with using RCHGetElementNumber to get financial statement
> > > data from all the elements (ranges from 2742 to 3973) from Google finance.
> > > It always return Error but others like yahoo or msn works fine.
> > >
> >
>

Fri Mar 1, 2013 8:50 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

Very Strange. You won't believe it.

If I create a brand new excel workbook and enter the GetAParms query I will get blank result. But if I open an old workbook which contains some RCHGetElementNumber queries (which works perfectly before), and then go back to the new workbook and recalculate the GetAParms query, it will return the proper results. Looks like the old workbook can wake up something.

--- In smf_addin@yahoogroups.com, "jasonhuangcam" wrote:
>
> Oh My Goodness.
>
> For =smfGetAParms(2742), sometimes I get blank result and sometimes get the [Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(except for per share items); ; ;0;

> Thank you.
> --- In smf_addin@yahoogroups.com, "jasonhuangcam" wrote:
> >
> > Hi,
> >
> > I get this
> >
> > [Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)] for
> > =RCHGetElementNumber("Version")
> > and
> > [Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(except for per share items); ; ;0;
> for smfGetAParms(2742)
> >
> > and I can also view the page using excel web.
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
> > >
> > > They're working fine here. What do you get for:
> > >
> > > =RCHGetElementNumber("Version")
> > > =smfGetAParms(2742)
> > >
> > > Do you see the appropriate web page when you go to this URL in the EXCEL
> > > Web Query dialog?
> > >
> > > http://www.google.com/finance?fstype=ii&q=AAPL
> > >
> > > On Fri, Mar 1, 2013 at 7:28 PM, jasonhuangcam wrote:
> > >
> > > >
> > > > I have trouble with using RCHGetElementNumber to get financial statement
> > > > data from all the elements (ranges from 2742 to 3973) from Google finance.
> > > > It always return Error but others like yahoo or msn works fine.
> > > >
> > >
> >
>

Fri Mar 1, 2013 9:00 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

Forgot to mention one very important point.

The "old workbook which contains existing RCHGetElementNumber" is from my friend. I remember the first time I opened it, I have to change the source link to my RCH_Stock_Market_Functions.xla in my C Drive. Maybe this workbook has stored some data from my friends computer and it confuses itself?

--- In smf_addin@yahoogroups.com, "jasonhuangcam" wrote:
>
> Very Strange. You won't believe it.
>
> If I create a brand new excel workbook and enter the GetAParms query I will get blank result. But if I open an old workbook which contains some RCHGetElementNumber queries (which works perfectly before), and then go back to the new workbook and recalculate the GetAParms query, it will return the proper results. Looks like the old workbook can wake up something.
>
> --- In smf_addin@yahoogroups.com, "jasonhuangcam" wrote:
> >
> > Oh My Goodness.
> >
> > For =smfGetAParms(2742), sometimes I get blank result and sometimes get the [Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(except for per share items); ; ;0;
>
> > Thank you.
> > --- In smf_addin@yahoogroups.com, "jasonhuangcam" wrote:
> > >
> > > Hi,
> > >
> > > I get this
> > >
> > > [Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)] for
> > > =RCHGetElementNumber("Version")
> > > and
> > > [Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(except for per share items); ; ;0;
> > for smfGetAParms(2742)
> > >
> > > and I can also view the page using excel web.
> > >
> > > --- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
> > > >
> > > > They're working fine here. What do you get for:
> > > >
> > > > =RCHGetElementNumber("Version")
> > > > =smfGetAParms(2742)
> > > >
> > > > Do you see the appropriate web page when you go to this URL in the EXCEL
> > > > Web Query dialog?
> > > >
> > > > http://www.google.com/finance?fstype=ii&q=AAPL
> > > >
> > > > On Fri, Mar 1, 2013 at 7:28 PM, jasonhuangcam wrote:
> > > >
> > > > >
> > > > > I have trouble with using RCHGetElementNumber to get financial statement
> > > > > data from all the elements (ranges from 2742 to 3973) from Google finance.
> > > > > It always return Error but others like yahoo or msn works fine.
> > > > >
> > > >
> > >
> >
>

Fri Mar 1, 2013 9:06 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't know what to tell you. Everything looks good there -- it will be
blank if you haven't done any element number retrievals prior to doing
smfGetAParms().

What do you get with:

=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=AAPL",1,"per
share items")
=smfGetTagContent("http://www.google.com/finance?fstype=ii&q=AAPL","tr",-1,"per
share items")

On Fri, Mar 1, 2013 at 9:32 PM, jasonhuangcam jasonhuang.gm@gmail.com>wrote:

>
> I get this
>
> [Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)]
> for
> =RCHGetElementNumber("Version")
> and
> [Google;Quarterly Income Statement -- Date -- FQ1;
> http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(exceptfor per share items); ; ;0;
for smfGetAParms(2742)
>
> and I can also view the page using excel web.
>

Fri Mar 1, 2013 9:45 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

I get error for both query.

I was trying to reinstall my Office2007Pro to clean every thing. But after I reinstall the office (I even changed directory to D drive) that, I open up Excel and it automatically reconfigure the add-ins and the SMF plug-in is already there(the most recently opened files list is there as well, there means the uninstallation is not clean). There is no way I can completely delete the the Plug-in and every thing and re-install the Plug-in.

Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I don't know what to tell you. Everything looks good there -- it will be
> blank if you haven't done any element number retrievals prior to doing
> smfGetAParms().
>
> What do you get with:
>
> =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=AAPL",1,"per
> share items")
> =smfGetTagContent("http://www.google.com/finance?fstype=ii&q=AAPL","tr",-1,"per
> share items")
>
> On Fri, Mar 1, 2013 at 9:32 PM, jasonhuangcam wrote:
>
> >
> > I get this
> >
> > [Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)]
> > for
> > =RCHGetElementNumber("Version")
> > and
> > [Google;Quarterly Income Statement -- Date -- FQ1;
> > http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(exceptfor per share items); ; ;0;
> for smfGetAParms(2742)
> >
> > and I can also view the page using excel web.
> >
>

Fri Mar 1, 2013 10:12 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

If you're getting errors on both queries, it likely isn't even retrieving
the web page. Can you do a web query on it?

The way to delete the add-in is to uncheck it within the add-in manager,
then exit EXCEL, and then delete the add-in contents and folder.

On Fri, Mar 1, 2013 at 10:45 PM, jasonhuangcam jasonhuang.gm@gmail.com>wrote:

> I get error for both query.
>
> I was trying to reinstall my Office2007Pro to clean every thing. But after
> I reinstall the office (I even changed directory to D drive) that, I open
> up Excel and it automatically reconfigure the add-ins and the SMF plug-in
> is already there(the most recently opened files list is there as well,
> there means the uninstallation is not clean). There is no way I can
> completely delete the the Plug-in and every thing and re-install the
> Plug-in.
>

Fri Mar 1, 2013 10:13 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

Another Strange thing.
When I press the enter button, the computer displays Error immediately instead of normally waiting for a second or two to load the content. It is like it is presumed to be error without trying.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I don't know what to tell you. Everything looks good there -- it will be
> blank if you haven't done any element number retrievals prior to doing
> smfGetAParms().
>
> What do you get with:
>
> =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=AAPL",1,"per
> share items")
> =smfGetTagContent("http://www.google.com/finance?fstype=ii&q=AAPL","tr",-1,"per
> share items")
>
> On Fri, Mar 1, 2013 at 9:32 PM, jasonhuangcam wrote:
>
> >
> > I get this
> >
> > [Stock Market Functions add-in, Version 2.1.2012.12.29 (D:\SMFADDIN; 1)]
> > for
> > =RCHGetElementNumber("Version")
> > and
> > [Google;Quarterly Income Statement -- Date -- FQ1;
> > http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(exceptfor per share items); ; ;0;
> for smfGetAParms(2742)
> >
> > and I can also view the page using excel web.
> >
>

Fri Mar 1, 2013 10:25 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It would depend on whether it needs to retrieve the web page from the
Internet, or whether it already has a copy stored. But if it can't retrieve
a copy of the web page in the first place, you'll always get Error until
you can get a fresh copy of the web page (either via smfForceRecalculation
or by exiting and restarting EXCEL).

On Fri, Mar 1, 2013 at 11:13 PM, jasonhuangcam jasonhuang.gm@gmail.com>wrote:

> Another Strange thing.
> When I press the enter button, the computer displays Error immediately
> instead of normally waiting for a second or two to load the content. It is
> like it is presumed to be error without trying.
>

Fri Mar 1, 2013 10:29 pm (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

When you say web query do you mean go to "Data" then "From Web" then type in the URL address?

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> If you're getting errors on both queries, it likely isn't even retrieving
> the web page. Can you do a web query on it?
>
> The way to delete the add-in is to uncheck it within the add-in manager,
> then exit EXCEL, and then delete the add-in contents and folder.
>
> On Fri, Mar 1, 2013 at 10:45 PM, jasonhuangcam wrote:
>
> > I get error for both query.
> >
> > I was trying to reinstall my Office2007Pro to clean every thing. But after
> > I reinstall the office (I even changed directory to D drive) that, I open
> > up Excel and it automatically reconfigure the add-ins and the SMF plug-in
> > is already there(the most recently opened files list is there as well,
> > there means the uninstallation is not clean). There is no way I can
> > completely delete the the Plug-in and every thing and re-install the
> > Plug-in.
> >
>

Fri Mar 1, 2013 10:37 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yup. I always use the keyboard shortcut: alt+d+d+w

After you enter the URL and go to the web page, make sure it doesn't
redirect you to a different one...and then try to import the results.

Hmmm. I just tried it to check it out, and it tells me the web query
imported no results. Curious. That's usually a sign that the add-in won't
be able to grab data from the web page. But the formulas I've given you
work for me, so I know the add-in is accessing the web page here...

On Fri, Mar 1, 2013 at 11:29 PM, jasonhuangcam jasonhuang.gm@gmail.com>wrote:

> When you say web query do you mean go to "Data" then "From Web" then type
> in the URL address?
>

Fri Mar 1, 2013 11:04 pm (PST) . Posted by:

"Jiacheng Huang" jasonhuangcam

Dear Randy,

You are right, I have some trouble with accessing the URL with Excel. I
have attached screen shorts.

1st case. I type in www.google.com/finance and step by step to get to the
statement page. It keeps pop up Security Warning Window and Script Error
window and then it says contents does not exist. So I cannot even view the
statements.

2nd case. I copy and paste the address
http://www.google.com/finance?fstype=ii&q=AAPL then I can view the
statements even though the Security Warnning still pops up. Then I press
the small yellow tick to import the statement, excel says the web query
returns no data.

Thanks.
Jason
Attachments with this message:
4 of 4 Photo(s)

Fri Mar 1, 2013 11:21 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm concerned that the URL in the screen shot is NOT the web address you're
entering. It looks like it is redirecting you to an https web page, which
may be why you get the security warning.

It appears something is interfering on with your ability to retrieve that
web page, which would explain why the add-in is having problems.

On Sat, Mar 2, 2013 at 12:04 AM, Jiacheng Huang jasonhuang.gm@gmail.com>wrote:

>
> You are right, I have some trouble with accessing the URL with Excel. I
> have attached screen shorts.
>
> 1st case. I type in www.google.com/finance and step by step to get to the
> statement page. It keeps pop up Security Warning Window and Script Error
> window and then it says contents does not exist. So I cannot even view the
> statements.
>
> 2nd case. I copy and paste the address
> http://www.google.com/finance?fstype=ii&q=AAPL then I can view the
> statements even though the Security Warnning still pops up. Then I press
> the small yellow tick to import the statement, excel says the web query
> returns no data.
>
>

Sat Mar 2, 2013 2:01 am (PST) . Posted by:

"jasonhuangcam" jasonhuangcam

Problem solved!

Dear Randy,

Finally, problem solved. It is the problem of IE security settings. I normally use Chrome and IE left untouched for a while. Since Excel Web browsing is base on IE so I opened up the IE browser. There was a notification about security settings which is between the Tab and the content page. I clicked on it and confirm something allowed (I forget what it exactly is), then back to excel and it pops up a security warning window ask whether I want to proceed. Sure I did and everything works.

Thank you very much for your help

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I'm concerned that the URL in the screen shot is NOT the web address you're
> entering. It looks like it is redirecting you to an https web page, which
> may be why you get the security warning.
>
> It appears something is interfering on with your ability to retrieve that
> web page, which would explain why the add-in is having problems.
>
> On Sat, Mar 2, 2013 at 12:04 AM, Jiacheng Huang wrote:
>
> >
> > You are right, I have some trouble with accessing the URL with Excel. I
> > have attached screen shorts.
> >
> > 1st case. I type in www.google.com/finance and step by step to get to the
> > statement page. It keeps pop up Security Warning Window and Script Error
> > window and then it says contents does not exist. So I cannot even view the
> > statements.
> >
> > 2nd case. I copy and paste the address
> > http://www.google.com/finance?fstype=ii&q=AAPL then I can view the
> > statements even though the Security Warnning still pops up. Then I press
> > the small yellow tick to import the statement, excel says the web query
> > returns no data.
> >
> >
>

Diposting oleh EXCEL FEED LEARNING di 02.01

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)