15 New Messages
Digest #2528
6a
Get Error when use RCHGetElementNumber("aapl",2742) to get data from by "jasonhuangcam" jasonhuangcam
6b
Re: Get Error when use RCHGetElementNumber("aapl",2742) to get data by "Randy Harmelink" rharmelink
6c
Get Error when use RCHGetElementNumber("aapl",2742) to get data from by "jasonhuangcam" jasonhuangcam
Messages
Fri Mar 1, 2013 6:41 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I, too, am getting errors using the MSN elements.
Using the below information here is the results. Not exactly sure when this started but has been a few days. I noticed it when trying to pull MSN data
In fact, I am getting errors on all MSN elements. I have been trying to figure out what I was doing wrong before posting the problem.
If need be I can upload the spreadsheet for you.
I just tested ramdomly over 30 elements for msn and they all fail.
Other elements are working fine -
This element for symbol GE returns 0.34 =RCHGetElementNumber(Ticker,597)
Ticker is cell B2
GE
Stock Market Functions add-in, Version 2.1.2013.02.12 (C:\Program Files\SMF Add-in; 1)
RCHGetElementNumber(Ticker,25)
Error
RCHGetElementNumber(Ticker,48)
Error
RCHGetElementNumber(Ticker,84)
Error
RCHGetElementNumber(Ticker,AM12)
Error
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, February 28, 2013 4:19 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add in Errors
I would suggest just using the latest official release. Exit EXCEL, download it from the group, and then extract all of the files into your SMF add-in folder, replacing files as needed. Then restart EXCEL and you should have that version of the add-in, and the latest element definitions.
You can check which version the add-in is with:
=RCHGetElementNumber("Version")
On Thu, Feb 28, 2013 at 12:50 PM, Chris Ball crball02@gmail.com > wrote:
The other day my computer crashed and I had to reboot my hard drive. Since rebooting I have been receiving these errors when running the add in:
=RCHGetElementNumber(Ticker,25)
=RCHGetElementNumber(Ticker,48)
=RCHGetElementNumber(Ticker,84)
=RCHGetElementNumber(Ticker,AN12)
I know the issue is I need to download new element definitions but it has been so long since I had to do it I am not sure what element definitions I need to download. Any help is appreciated.
Using the below information here is the results. Not exactly sure when this started but has been a few days. I noticed it when trying to pull MSN data
In fact, I am getting errors on all MSN elements. I have been trying to figure out what I was doing wrong before posting the problem.
If need be I can upload the spreadsheet for you.
I just tested ramdomly over 30 elements for msn and they all fail.
Other elements are working fine -
This element for symbol GE returns 0.34 =RCHGetElementNumbe
Ticker is cell B2
GE
Stock Market Functions add-in, Version 2.1.2013.02.
RCHGetElementNumber
Error
RCHGetElementNumber
Error
RCHGetElementNumber
Error
RCHGetElementNumber
Error
From: smf_addin@yahoogrou
Sent: Thursday, February 28, 2013 4:19 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] SMF Add in Errors
I would suggest just using the latest official release. Exit EXCEL, download it from the group, and then extract all of the files into your SMF add-in folder, replacing files as needed. Then restart EXCEL and you should have that version of the add-in, and the latest element definitions.
You can check which version the add-in is with:
=RCHGetElementNumbe
On Thu, Feb 28, 2013 at 12:50 PM, Chris Ball crball02@gmail.
The other day my computer crashed and I had to reboot my hard drive. Since rebooting I have been receiving these errors when running the add in:
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
I know the issue is I need to download new element definitions but it has been so long since I had to do it I am not sure what element definitions I need to download. Any help is appreciated.
Fri Mar 1, 2013 7:16 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I just backed off the work-in-progress version and installed the latest official release.
Closed everything and
Rebooted my machine and I still get the MSN errors.
Any suggestions on what I do next?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Kermit W. Prather
Sent: Friday, March 01, 2013 9:42 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] SMF Add in Errors
Randy, I, too, am getting errors using the MSN elements.
Using the below information here is the results. Not exactly sure when this started but has been a few days. I noticed it when trying to pull MSN data
In fact, I am getting errors on all MSN elements. I have been trying to figure out what I was doing wrong before posting the problem.
If need be I can upload the spreadsheet for you.
I just tested ramdomly over 30 elements for msn and they all fail.
Other elements are working fine -
This element for symbol GE returns 0.34 =RCHGetElementNumber(Ticker,597)
Ticker is cell B2
GE
Stock Market Functions add-in, Version 2.1.2013.02.12 (C:\Program Files\SMF Add-in; 1)
RCHGetElementNumber(Ticker,25)
Error
RCHGetElementNumber(Ticker,48)
Error
RCHGetElementNumber(Ticker,84)
Error
RCHGetElementNumber(Ticker,AM12)
Error
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, February 28, 2013 4:19 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add in Errors
I would suggest just using the latest official release. Exit EXCEL, download it from the group, and then extract all of the files into your SMF add-in folder, replacing files as needed. Then restart EXCEL and you should have that version of the add-in, and the latest element definitions.
You can check which version the add-in is with:
=RCHGetElementNumber("Version")
On Thu, Feb 28, 2013 at 12:50 PM, Chris Ball crball02@gmail.com > wrote:
The other day my computer crashed and I had to reboot my hard drive. Since rebooting I have been receiving these errors when running the add in:
=RCHGetElementNumber(Ticker,25)
=RCHGetElementNumber(Ticker,48)
=RCHGetElementNumber(Ticker,84)
=RCHGetElementNumber(Ticker,AN12)
I know the issue is I need to download new element definitions but it has been so long since I had to do it I am not sure what element definitions I need to download. Any help is appreciated.
Closed everything and
Rebooted my machine and I still get the MSN errors.
Any suggestions on what I do next?
From: smf_addin@yahoogrou
Sent: Friday, March 01, 2013 9:42 AM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] SMF Add in Errors
Randy, I, too, am getting errors using the MSN elements.
Using the below information here is the results. Not exactly sure when this started but has been a few days. I noticed it when trying to pull MSN data
In fact, I am getting errors on all MSN elements. I have been trying to figure out what I was doing wrong before posting the problem.
If need be I can upload the spreadsheet for you.
I just tested ramdomly over 30 elements for msn and they all fail.
Other elements are working fine -
This element for symbol GE returns 0.34 =RCHGetElementNumbe
Ticker is cell B2
GE
Stock Market Functions add-in, Version 2.1.2013.02.
RCHGetElementNumber
Error
RCHGetElementNumber
Error
RCHGetElementNumber
Error
RCHGetElementNumber
Error
From: smf_addin@yahoogrou
Sent: Thursday, February 28, 2013 4:19 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] SMF Add in Errors
I would suggest just using the latest official release. Exit EXCEL, download it from the group, and then extract all of the files into your SMF add-in folder, replacing files as needed. Then restart EXCEL and you should have that version of the add-in, and the latest element definitions.
You can check which version the add-in is with:
=RCHGetElementNumbe
On Thu, Feb 28, 2013 at 12:50 PM, Chris Ball crball02@gmail.
The other day my computer crashed and I had to reboot my hard drive. Since rebooting I have been receiving these errors when running the add in:
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
I know the issue is I need to download new element definitions but it has been so long since I had to do it I am not sure what element definitions I need to download. Any help is appreciated.
Fri Mar 1, 2013 8:07 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Those three elements are working for me, using GE or MMM as the ticker
symbol.
What do you get for:
=smfGetAParms(25)
On Fri, Mar 1, 2013 at 7:41 AM, Kermit W. Prather
kermitp@tampabay.rr.com >wrote:
>
> Randy, I, too, am getting errors using the MSN elements. ****
>
> ** **
>
> Using the below information here is the results. Not exactly sure when
> this started but has been a few days. I noticed it when trying to pull MSN
> data****
>
> In fact, I am getting errors on all MSN elements. I have been trying to
> figure out what I was doing wrong before posting the problem.****
>
> ** **
>
> If need be I can upload the spreadsheet for you.****
>
> ** **
>
> I just tested ramdomly over 30 elements for msn and they all fail. ****
>
> Other elements are working fine - ****
>
> This element for symbol GE returns 0.34 =RCHGetElementNumber(Ticker,597)
>
symbol.
What do you get for:
=smfGetAParms(
On Fri, Mar 1, 2013 at 7:41 AM, Kermit W. Prather
kermitp@tampabay.
>
> Randy, I, too, am getting errors using the MSN elements. ****
>
> ** **
>
> Using the below information here is the results. Not exactly sure when
> this started but has been a few days. I noticed it when trying to pull MSN
> data****
>
> In fact, I am getting errors on all MSN elements. I have been trying to
> figure out what I was doing wrong before posting the problem.****
>
> ** **
>
> If need be I can upload the spreadsheet for you.****
>
> ** **
>
> I just tested ramdomly over 30 elements for msn and they all fail. ****
>
> Other elements are working fine - ****
>
> This element for symbol GE returns 0.34 =RCHGetElementNumbe
>
Fri Mar 1, 2013 8:27 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I get
MSN;Last Price;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0
I, also, was able to retrieve parms for any of the MSN elements I tried
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, March 01, 2013 11:08 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add in Errors
Those three elements are working for me, using GE or MMM as the ticker symbol.
What do you get for:
=smfGetAParms(25)
On Fri, Mar 1, 2013 at 7:41 AM, Kermit W. Prather kermitp@tampabay.rr.com > wrote:
Randy, I, too, am getting errors using the MSN elements.
Using the below information here is the results. Not exactly sure when this started but has been a few days. I noticed it when trying to pull MSN data
In fact, I am getting errors on all MSN elements. I have been trying to figure out what I was doing wrong before posting the problem.
If need be I can upload the spreadsheet for you.
I just tested ramdomly over 30 elements for msn and they all fail.
Other elements are working fine -
This element for symbol GE returns 0.34 =RCHGetElementNumber(Ticker,597)
MSN;Last Price;http://investing.
I, also, was able to retrieve parms for any of the MSN elements I tried
From: smf_addin@yahoogrou
Sent: Friday, March 01, 2013 11:08 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] SMF Add in Errors
Those three elements are working for me, using GE or MMM as the ticker symbol.
What do you get for:
=smfGetAParms(
On Fri, Mar 1, 2013 at 7:41 AM, Kermit W. Prather kermitp@tampabay.
Randy, I, too, am getting errors using the MSN elements.
Using the below information here is the results. Not exactly sure when this started but has been a few days. I noticed it when trying to pull MSN data
In fact, I am getting errors on all MSN elements. I have been trying to figure out what I was doing wrong before posting the problem.
If need be I can upload the spreadsheet for you.
I just tested ramdomly over 30 elements for msn and they all fail.
Other elements are working fine -
This element for symbol GE returns 0.34 =RCHGetElementNumbe
Fri Mar 1, 2013 8:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That's the current definition of element #25, so I have no idea why you're
receiving an error -- unless the web page wasn't available when you were
trying.
Element #25 should just be doing something like this:
=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM ",1,">Last
Price")
On Fri, Mar 1, 2013 at 9:27 AM, Kermit W. Prather
kermitp@tampabay.rr.com >wrote:
>
> I get ****
>
> ** **
>
> MSN;Last Price;
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST PRICE; ; ;0;0;0;0
> ****
>
> ** **
>
> I, also, was able to retrieve parms for any of the MSN elements I tried
>
receiving an error -- unless the web page wasn't available when you were
trying.
Element #25 should just be doing something like this:
=RCHGetTableCell(
http://investing.
Price")
On Fri, Mar 1, 2013 at 9:27 AM, Kermit W. Prather
kermitp@tampabay.
>
> I get ****
>
> ** **
>
> MSN;Last Price;
> http://investing.
> ****
>
> ** **
>
> I, also, was able to retrieve parms for any of the MSN elements I tried
>
Fri Mar 1, 2013 9:37 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, thanks for your efforts.
But in trying to fix this problem I have totally screwed up the whole thing now nothing works in the addin.
I'll have to fix that and then I'll post the results.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, March 01, 2013 11:32 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] SMF Add in Errors
That's the current definition of element #25, so I have no idea why you're receiving an error -- unless the web page wasn't available when you were trying.
Element #25 should just be doing something like this:
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-report?CR=1 http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=MMM",1,">Last Price")
On Fri, Mar 1, 2013 at 9:27 AM, Kermit W. Prather kermitp@tampabay.rr.com > wrote:
I get
MSN;Last Price;http://investing.money.msn.com/investments/stock-report?CR=1 http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0
I, also, was able to retrieve parms for any of the MSN elements I tried
But in trying to fix this problem I have totally screwed up the whole thing now nothing works in the addin.
I'll have to fix that and then I'll post the results.
From: smf_addin@yahoogrou
Sent: Friday, March 01, 2013 11:32 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] SMF Add in Errors
That's the current definition of element #25, so I have no idea why you're receiving an error -- unless the web page wasn't available when you were trying.
Element #25 should just be doing something like this:
=RCHGetTableCell(
On Fri, Mar 1, 2013 at 9:27 AM, Kermit W. Prather kermitp@tampabay.
I get
MSN;Last Price;http://investing.
I, also, was able to retrieve parms for any of the MSN elements I tried
Fri Mar 1, 2013 6:45 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I just tried the examples and I get a B rating and the webpage shows a B
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, February 28, 2013 4:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Obtaining Grade and Buy ratings from thestreet.com
When I go to:
http://ratings.thestreet.com/tools/inc/basicjs/AAPL.js
...I see A+. Maybe this is what you need?
=smfStrExtr(RCHGetWebData("http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html ","LetterGradeRating",100),":""","""")
=smfStrExtr(RCHGetWebData("http://www.thestreet.com/quote/AAPL/details/analyst-ratings.html ","CurrentRating",100),":""","""")
On Thu, Feb 28, 2013 at 11:47 AM, mdouglashaas douglashaas4974@earthlink.net > wrote:
I have manually visited the thestreet.com to obtain a rating for AAPL using 3 different PC's , two different browsers, (all with clean caches). In each case I show AAPL as rating = B, Buy.
I normally use IE10 as my default browser.
AM I still missing something?
From: smf_addin@yahoogrou
Sent: Thursday, February 28, 2013 4:13 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: Obtaining Grade and Buy ratings from thestreet.com
When I go to:
http://ratings.
...I see A+. Maybe this is what you need?
=smfStrExtr(
=smfStrExtr(
On Thu, Feb 28, 2013 at 11:47 AM, mdouglashaas douglashaas4974@
I have manually visited the thestreet.com to obtain a rating for AAPL using 3 different PC's , two different browsers, (all with clean caches). In each case I show AAPL as rating = B, Buy.
I normally use IE10 as my default browser.
AM I still missing something?
Fri Mar 1, 2013 8:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You'd need to extract the hyperlinks yourself. They are part of the HTML
tag, so RCHGetHTMLTable() throws them away.
On Fri, Mar 1, 2013 at 4:15 AM, j14mako johnyu@yahoo.com.au > wrote:
> I'm wondering if I can pull the hyperlinks into my spreadsheet so I can
> have a single place to open the PDFs from the web?
>
> e.g. From this page, there are links to PDFs:
>
>
> http://www.asx.com.au/asx/statistics/announcements.do?by=asxCode&asxCode=hvn&timeframe=Y&year=2013
>
> I tried this:
>
> =RCHGetHTMLTable("
> http://www.asx.com.au/asx/statistics/announcements.do?by=asxCode&asxCode=hvn&timeframe=Y&year=2013
> ","Date",-1,"",1)
>
> But the hyperlinks are returned as plain text.
>
tag, so RCHGetHTMLTable(
On Fri, Mar 1, 2013 at 4:15 AM, j14mako johnyu@yahoo.
> I'm wondering if I can pull the hyperlinks into my spreadsheet so I can
> have a single place to open the PDFs from the web?
>
> e.g. From this page, there are links to PDFs:
>
>
> http://www.asx.
>
> I tried this:
>
> =RCHGetHTMLTable(
> http://www.asx.
> ","
>
> But the hyperlinks are returned as plain text.
>
Fri Mar 1, 2013 1:03 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I finally got this to work. But now I can't figure out how to change it so I can refer to a cell such as Ticker or just cell A1 instead of hard coding AGNC in the tag.
=smfGetTagContent("http://dividata.com/stock/AGNC/dividend ","p",2,,,,">Ex-Dividend Date")
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, February 28, 2013 11:47 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Need help to capture data to a spreadsheet
Just use:
=smfGetTagContent("http://dividata.com/stock/AGNC/dividend ","p",...n...,">Ex-Dividend Date")
...where "...n..." is 2, 4, 6, 8, ... for the dates and 3, 5, 7, 9, ... for the amounts.
On Thu, Feb 28, 2013 at 8:45 AM, Kermit W. Prather kermitp@tampabay.rr.com > wrote:
Randy, I hate to ask but I have no idea how to capture the data I need from this webpage http://dividata.com/stock/AGNC/dividend
I'm hoping you can show me how.
I want to capture just the Dividend Payment History from the webpage.
I can't figure out how to parse this into a spreadsheet. I have looked thru the documentation
But can't figure out which function to use as this is in a list not in a table.
Can you point me to the function or provide an example?
Thank You,
Kermit
Data in Webpage
Dividend Payment History
=smfGetTagContent(
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, February 28, 2013 11:47 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Need help to capture data to a spreadsheet
Just use:
=smfGetTagContent(
...where "...n..
On Thu, Feb 28, 2013 at 8:45 AM, Kermit W. Prather kermitp@tampabay.
Randy, I hate to ask but I have no idea how to capture the data I need from this webpage http://dividata.
I'm hoping you can show me how.
I want to capture just the Dividend Payment History from the webpage.
I can't figure out how to parse this into a spreadsheet. I have looked thru the documentation
But can't figure out which function to use as this is in a list not in a table.
Can you point me to the function or provide an example?
Thank You,
Kermit
Data in Webpage
Dividend Payment History
>
Ex-Dividend Date
Dividend Amount
- >
Dec 24, 2012
$1.25
Sep 19, 2012
$1.25
Jun 19, 2012
$1.25
Mar 05, 2012
$1.25
Dec 20, 2011
$1.40
Sep 21, 2011
$1.40
Jun 21, 2011
$1.40
Mar 21, 2011
$1.40
Dec 29, 2010
$1.40
Sep 24, 2010
$1.40
Jun 28, 2010
$1.40
Mar 29, 2010
$1.40
Dec 29, 2009
$1.40
Sep 30, 2009
$1.40
Jun 30, 2009
$1.50
Mar 31, 2009
$0.85
Dec 29, 2008
$1.20
Sep 25, 2008
$1.00
Jun 30, 2008
$0.31
>
Fri Mar 1, 2013 2:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You just need to use normal EXCEL concatenation to join the cell reference
into the URL string:
=smfGetTagContent("http://dividata.com/stock/ "&F4&"/dividend","p",2,,,,">Ex-Dividend
Date")
On Fri, Mar 1, 2013 at 2:03 PM, Kermit W. Prather
kermitp@tampabay.rr.com >wrote:
>
> Randy, I finally got this to work. But now I can't figure out how to
> change it so I can refer to a cell such as Ticker or just cell A1 instead
> of hard coding AGNC in the tag.****
>
> ** **
>
> =smfGetTagContent("http://dividata.com/stock/AGNC/dividend ","p",2,,,,">Ex-Dividend
> Date")****
>
into the URL string:
=smfGetTagContent(
Date")
On Fri, Mar 1, 2013 at 2:03 PM, Kermit W. Prather
kermitp@tampabay.
>
> Randy, I finally got this to work. But now I can't figure out how to
> change it so I can refer to a cell such as Ticker or just cell A1 instead
> of hard coding AGNC in the tag.****
>
> ** **
>
> =smfGetTagContent(
> Date")*
>
Fri Mar 1, 2013 2:28 pm (PST) . Posted by:
"Dhiraj" frodo_dhiraj
hi Folks,
I am new to SMF Admin, so far loving it. Any suggestion on how to resolve the#NAME? error. I tried to open the recent file create as MorningStar.xlsx and it opens for a flicker of a second, after that it shows as #NAME?
I do have the addin in C:\Program Files; C:\ and c:\Program Filex (x86) all three locations.
Have not been able to resolve this.
Appreciate your help in this regards .
Thanks DC
I am new to SMF Admin, so far loving it. Any suggestion on how to resolve the#NAME? error. I tried to open the recent file create as MorningStar.
I do have the addin in C:\Program Files; C:\ and c:\Program Filex (x86) all three locations.
Have not been able to resolve this.
Appreciate your help in this regards .
Thanks DC
Fri Mar 1, 2013 2:31 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the "location errors" entry in the LINKS area of the Yahoo Group.
On Fri, Mar 1, 2013 at 2:38 PM, Dhiraj dhiraj.chhajer@gmail.com > wrote:
>
> I am new to SMF Admin, so far loving it. Any suggestion on how to resolve
> the#NAME? error. I tried to open the recent file create as MorningStar.xlsx
> and it opens for a flicker of a second, after that it shows as #NAME?
>
> I do have the addin in C:\Program Files; C:\ and c:\Program Filex (x86)
> all three locations.
>
> Have not been able to resolve this.
>
On Fri, Mar 1, 2013 at 2:38 PM, Dhiraj dhiraj.chhajer@
>
> I am new to SMF Admin, so far loving it. Any suggestion on how to resolve
> the#NAME? error. I tried to open the recent file create as MorningStar.
> and it opens for a flicker of a second, after that it shows as #NAME?
>
> I do have the addin in C:\Program Files; C:\ and c:\Program Filex (x86)
> all three locations.
>
> Have not been able to resolve this.
>
Fri Mar 1, 2013 7:48 pm (PST) . Posted by:
"jasonhuangcam" jasonhuangcam
Dear All,
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.
Thank you very much!!
jason
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.
Thank you very much!!
jason
Fri Mar 1, 2013 7:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
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 jasonhuang.gm@gmail.com >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.
>
=RCHGetElementNumbe
=smfGetAParms(
Do you see the appropriate web page when you go to this URL in the EXCEL
Web Query dialog?
http://www.google.
On Fri, Mar 1, 2013 at 7:28 PM, jasonhuangcam jasonhuang.gm@
>
> 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:11 pm (PST) . Posted by:
"jasonhuangcam" jasonhuangcam
Dear all,
I always get Error when I use RCHGetElementNumber with elements between 2742 to 3973 which is the Google Finance elements (smf-elements-3.txt). Does anyone know how to solve this?
Thanks in advance.
Jason
I always get Error when I use RCHGetElementNumber with elements between 2742 to 3973 which is the Google Finance elements (smf-elements-
Thanks in advance.
Jason
Tidak ada komentar:
Posting Komentar