Hi Randy

Many thanks for the fantastic work.

I was re-visiting a file for updating historic company financial data that I had created last year and for some reason I am unable to pull in data any more (just get "error"). I am using the "RCHGetElementNumber" function and I have checked to see if I had missed some change in the definitions, but they still seem good (the below example still being "Annual Indicators -- Ending Date -- FY10" ) and I should have your latest addin ( RCH_Stock_Market_Functions).

=RCHGetElementNumber(Ticker,5204)

Perhaps I am missing something. Would it be possible to guide me back on to the right path here?

regards

John

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

1b

Re: RCHGetElementNumber no longer working for me

Mon Jan 13, 2014 9:24 am (PST) . Posted by:

"Randy Harmelink" rharmelink

First off, did you try the IE fix suggesting in the LINKS area of the group?

Secondly, are you using the beta version of the add-in from the "Works in
Progress" folder of the FILES area of the Yahoo group? AdvFN recently made
changes to their website that required changes to add-in programming.

If those are both OK, or if you just want to check, what do you get with:

=RCHGetElementNumber("MMM";,5204)
=RCHGetElementNumber("Version")
=RCHGetWebData("
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM",
"/exchanges/", 50)
=RCHGetWebData("http://www.advfn.com/exchanges/NYSE/MMM/financials",
"/exchanges/", 50)
=RCHGetTableCell("
http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=start_date&start_date=11&mode=annual_reports",1,">Year
End Date")

On Mon, Jan 13, 2014 at 3:21 AM, <jsawyermib@yahoo.com> wrote:

> I was re-visiting a file for updating historic company financial data
> that I had created last year and for some reason I am unable to pull in
> data any more (just get "error"). I am using the "RCHGetElementNumber"
> function and I have checked to see if I had missed some change in the
> definitions, but they still seem good (the below example still being
> "Annual Indicators -- Ending Date -- FY10" ) and I should have your latest
> addin ( RCH_Stock_Market_Functions).
>
> =RCHGetElementNumber(Ticker,5204)
>
> Perhaps I am missing something. Would it be possible to guide me back on
> to the right path here?
>
>

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

2a

Re: emma

Mon Jan 13, 2014 6:37 am (PST) . Posted by:

Buck_69_69

Thank you Randy this helps a lot. A final question, what if I wanted only the actual trade date and not the header?

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

2b

Re: emma

Mon Jan 13, 2014 9:27 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Then you'd need to get an individual table cell:

=RCHGetTableCell("
http://emma.msrb.org/SecurityView/SecurityDetailsTrades.aspx?cusip=251129R61",1,">Trade
Date",,,,1)

On Mon, Jan 13, 2014 at 7:37 AM, <buck_69_69@yahoo.com> wrote:

> A final question, what if I wanted only the actual trade date and not
> the header?
>

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

3a

SMF Addin was disabled somehow

Mon Jan 13, 2014 8:44 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Do you have any suggestions as to why or how the SMF Addin was disabled in
my EXCEL 2007?

It was working fine and just stopped working. Every Cell with a formula then
displayed #NAME?

After trying several things and opening previously working spreadsheet I
decide to check the Addin status. It showed disabled.

I have never had that happen before so I don't know what might cause an
Addin to get disabled.

Kermit

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

3b

Re: SMF Addin was disabled somehow

Mon Jan 13, 2014 9:28 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not a clue as to what might have happened, sorry...

On Mon, Jan 13, 2014 at 9:44 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> Do you have any suggestions as to why or how the SMF Addin was disabled in
> my EXCEL 2007?
>
>
>
> It was working fine and just stopped working. Every Cell with a formula
> then displayed #NAME?
>
>
>
> After trying several things and opening previously working spreadsheet I
> decide to check the Addin status. It showed disabled.
>
>
>
> I have never had that happen before so I don't know what might cause an
> Addin to get disabled.
>
>
>

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

4a

Error in Excel 2010

Mon Jan 13, 2014 9:07 am (PST) . Posted by:

gaspar.dorey

Hi everyone! Can anybody help please? I have a spreadsheet using RCHGetYahooHistory formulae and I am trying to run it on an Excel 2010. If I ask the formula to pick up dates only "D", it will do so perfectly; when I ask it to retrieve "C" (closing price) it doesn't retrieve a thing. I tested it in Excel 2007 and works perfectly. Please advise on what could be happening... as I am getting a bit desperate... ;)
Thanks! Gaspar

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

4b

Re: Error in Excel 2010

Mon Jan 13, 2014 9:30 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Sample formula please...

However, I only have EXCEL 2007, so have no way to test it in EXCEL 2010.

On Mon, Jan 13, 2014 at 10:07 AM, <gaspar.dorey@yahoo.com> wrote:

>
> Hi everyone!
> Can anybody help please? I have a spreadsheet using RCHGetYahooHistory
> formulae and I am trying to run it on an Excel 2010. If I ask the formula
> to pick up dates only "D", it will do so perfectly; when I ask it to
> retrieve "C" (closing price) it doesn't retrieve a thing. I tested it in
> Excel 2007 and works perfectly. Please advise on what could be happening...
> as I am getting a bit desperate... ;)
> Thanks! Gaspar
>

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

4c

Re: Error in Excel 2010

Mon Jan 13, 2014 9:54 am (PST) . Posted by:

gaspar.dorey

Sorry, I have placed the file on a Folder called Error in Excel 2010 with a sample calculation.

Can you please check if you can open it? It's really odd...

Thanks,

Gaspar

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

4d

Re: Error in Excel 2010

Mon Jan 13, 2014 10:17 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Works fine here, but I have EXCEL 2007. I don't see anything wrong with the
formula.

You don't have anything funky going on, like non-U.S. date progressing,
right?

On Mon, Jan 13, 2014 at 10:54 AM, <gaspar.dorey@yahoo.com> wrote:

> Sorry, I have placed the file on a Folder called Error in Excel 2010 with
> a sample calculation.
>
> Can you please check if you can open it? It's really odd...
>
>

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

4e

Re: Error in Excel 2010

Mon Jan 13, 2014 10:29 am (PST) . Posted by:

mikemcq802

I have Excel 2010 and your sample spreadsheet works fine for me.

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

4f

Re: Error in Excel 2010

Mon Jan 13, 2014 10:30 am (PST) . Posted by:

gaspar.dorey

Ok Thanks very much!

I will keep on trying! If I manage to solve it, I will let you know how!

Gaspar

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

5a

AdvFN-A Element Numbers

Mon Jan 13, 2014 10:12 am (PST) . Posted by:

fhinnenkamp

Hello,

I am new to this board so I apologize if it has been board so I apologize if this has been asked already.

I am interested in generating some reports using the AdvFN-A element numbers for profitability ratios among others but keep receiving an error message. Is there a way to update the numbers?

I appreciate any help I can get in this matter.

Kind regards,
Fred

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

5b

Re: AdvFN-A Element Numbers

Mon Jan 13, 2014 10:18 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Just asked this morning...

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25009

On Mon, Jan 13, 2014 at 10:46 AM, <fhinnenkamp@gmail.com> wrote:

> I am new to this board so I apologize if it has been board so I apologize
> if this has been asked already.
>
> I am interested in generating some reports using the AdvFN-A element
> numbers for profitability ratios among others but keep receiving an error
> message. Is there a way to update the numbers?
>
> I appreciate any help I can get in this matter.
>

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

6 Ex-dividend date source

Mon Jan 13, 2014 10:48 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

I am trying to pick up the Ex-dividend date but in searching the elements I
see the only one for EX-Dividend date is

992
S
YahooKS
Ex-Dividend Date
SMF-Template-Yahoo-Key-Statistics.xls

Unfortunately, Yahoo Key Statistics does not exist for all stocks, funds,
preferred stocks, Ishares, and others

Any chance you might add other Elements for retrieving Ex-Dividend Date?
Dividata.com and dividendchannel.com are free sites that provide Ex-dividend
dates. Both are excellent sites
Dividend.com offers free and fee services, it also has the EX-dividend
dates. I use both the premium and free services.

I know I can pull the EX-Dividend dates with other features of the SMF-Addin
but I'd like to eliminate having to do that.

Thanks, Kermit