Hello everyone !

I suddenly get the formula below where I used the add-in

='C:\Program Files\SMF
Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B10;"j1")

What can I do???

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

1b

See the "Location errors" entry in the LINKS area of the group.

I usually just run the smfFixLinks macro to remove them.

On Thu, Oct 17, 2013 at 2:48 AM, <johkouf@hotmail.com> wrote:

>
> I suddenly get the formula below where I used the add-in
>
> ='C:\Program Files\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B10;"j1")
>
> What can I do???
>

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

2a

Latest SMF beta and AdvFn Quarterlies

Thu Oct 17, 2013 6:22 am (PDT) . Posted by:

mikemcq802

That's great Randy - thanks a lot. Like dcharlotte99 I am very happy to have SMF working with AdvFn working again (if only temporarily).

Just a note to other readers that AdvFn posts a notice that the most recent quarterly financials are not updating correctly and to use their beta site for that. See this page for an example warning:
http://www.advfn.com/exchanges/NYSE/MCD/financials?btn=quarterly_reports&mode=company_data

The one data error I saw on their most recent quarterly is the quarter indicator is "Q" when it is supposed to be 1,2,3, or 4. This threw off my spreadsheets that derive a TTM figure from the most recent quarterlies so it was quite obvious something was amiss.

Thanks Randy.

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

2b

Re: Latest SMF beta and AdvFn Quarterlies

Thu Oct 17, 2013 6:50 am (PDT) . Posted by:

rb_luther

Thank you Randy!!! This is critical to my personal, and more importantly, professional work. Thanks for getting ADVFN back on track. I really appreciate it.

---In smf_addin@yahoogroups.com, <mikemcq802@...> wrote:

That's great Randy - thanks a lot. Like dcharlotte99 I am very happy to have SMF working with AdvFn working again (if only temporarily).

Just a note to other readers that AdvFn posts a notice that the most recent quarterly financials are not updating correctly and to use their beta site for that. See this page for an example warning:
http://www.advfn.com/exchanges/NYSE/MCD/financials?btn=quarterly_reports&mode=company_data

The one data error I saw on their most recent quarterly is the quarter indicator is "Q" when it is supposed to be 1,2,3, or 4. This threw off my spreadsheets that derive a TTM figure from the most recent quarterlies so it was quite obvious something was amiss.

Thanks Randy.

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

3a

Re: Beta version of add-in updated to work for AdvFN URL changes

Thu Oct 17, 2013 6:52 am (PDT) . Posted by:

rb_luther

Thank you Randy!!! This is critical to my personal, and more importantly, professional work. Thanks for getting ADVFN back on track. I really appreciate it.

---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:

Thanks Randy I really miss the ADVFn data. I've been getting by with the Gurufocus data but it just isn't the same.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I just uploaded beta version 2.1.2013.10.16 of the add-in to the "Works in Progress" folder of the FILES area of the group.

I made changes to the smfGetAdvFNElement() routine that should allow data to be retrieved, using their new URL scheme. That means RCHGetElementNumber() functions for AdvFN elements should also work.

It appears to work for both general templates in the FILES area.

However, I can only test changes using their "www" prefix. I don't know if other regional prefixes will work or not. Or whether you even NEED to use other regional prefixes any more.

And, of course, when they do go their new beta format, all bets are off until THAT gets stabilized.

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

3b

Re: Beta version of add-in updated to work for AdvFN URL changes

Thu Oct 17, 2013 7:54 am (PDT) . Posted by:

alliedvalue

Thanks Randy for working on updating this. There are a lot of people that prefer to use the AdvFN data.

Just as an FYI, I can only get this beta version to work for companies listed on the NYSE. Companies listed on the NASDAQ all return errors.

---In smf_addin@yahoogroups.com, <rb_luther@...> wrote:

Thank you Randy!!! This is critical to my personal, and more importantly, professional work. Thanks for getting ADVFN back on track. I really appreciate it.

---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:

Thanks Randy I really miss the ADVFn data. I've been getting by with the Gurufocus data but it just isn't the same.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I just uploaded beta version 2.1.2013.10.16 of the add-in to the "Works in Progress" folder of the FILES area of the group.

I made changes to the smfGetAdvFNElement() routine that should allow data to be retrieved, using their new URL scheme. That means RCHGetElementNumber() functions for AdvFN elements should also work.

It appears to work for both general templates in the FILES area.

However, I can only test changes using their "www" prefix. I don't know if other regional prefixes will work or not. Or whether you even NEED to use other regional prefixes any more.

And, of course, when they do go their new beta format, all bets are off until THAT gets stabilized.

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

3c

Re: Beta version of add-in updated to work for AdvFN URL changes

Thu Oct 17, 2013 8:07 am (PDT) . Posted by:

rb_luther

same issue here. NYSE stocks work with ADVFN, other exchanges do not.

Also, the MSN site for stock price ("Last price" in the element definitions sheet #25) returns "Obsolete"; now. my formula looks like this: =RCHGetElementNumber(Q1,25), where Q1 points to a ticker.

Thoughts? Help?

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

Thanks Randy for working on updating this. There are a lot of people that prefer to use the AdvFN data.

Just as an FYI, I can only get this beta version to work for companies listed on the NYSE. Companies listed on the NASDAQ all return errors.

---In smf_addin@yahoogroups.com, <rb_luther@...> wrote:

Thank you Randy!!! This is critical to my personal, and more importantly, professional work. Thanks for getting ADVFN back on track. I really appreciate it.

---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:

Thanks Randy I really miss the ADVFn data. I've been getting by with the Gurufocus data but it just isn't the same.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I just uploaded beta version 2.1.2013.10.16 of the add-in to the "Works in Progress" folder of the FILES area of the group.

I made changes to the smfGetAdvFNElement() routine that should allow data to be retrieved, using their new URL scheme. That means RCHGetElementNumber() functions for AdvFN elements should also work.

It appears to work for both general templates in the FILES area.

However, I can only test changes using their "www" prefix. I don't know if other regional prefixes will work or not. Or whether you even NEED to use other regional prefixes any more.

And, of course, when they do go their new beta format, all bets are off until THAT gets stabilized.

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

3d

Re: Beta version of add-in updated to work for AdvFN URL changes

Thu Oct 17, 2013 8:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Ahhh. I'm an idiot. New update:

RCH_Stock_Market_Functions-2.1.2013.10.17.zip

I had hard-coded "MMM" as the ticker symbol when looking up the stock
exchange (needed for the URL), so anything outside of NYSE wouldn't work.
Now fixed.

My apologies.

BTW, I tried a few AMEX companies and noted that AdvFN had *no* financials
for them.

On Thu, Oct 17, 2013 at 7:37 AM, <derekrwerner@gmail.com> wrote:

> Just as an FYI, I can only get this beta version to work for companies
> listed on the NYSE. Companies listed on the NASDAQ all return errors.
>

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

3e

Re: Beta version of add-in updated to work for AdvFN URL changes

Thu Oct 17, 2013 8:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I obsoleted element #25. Ever since MSN did their redesign of the print
page last year, they've been posting the previous day's closing price as
"Last Price". You should use RCHGetYahooQuotes() for current quotes.

On Thu, Oct 17, 2013 at 8:07 AM, <rb_luther@yahoo.com> wrote:

> Also, the MSN site for stock price ("Last price" in the element
> definitions sheet #25) returns "Obsolete"; now. my formula looks like this:
> =RCHGetElementNumber(Q1,25), where Q1 points to a ticker.
>

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

3f

Re: Beta version of add-in updated to work for AdvFN URL changes

Thu Oct 17, 2013 8:13 am (PDT) . Posted by:

mksmith64

Thanks Randy. Unfortunately it appears to work for NYSE listings and not NASDAQ. Any ideas?

Mark

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I just uploaded beta version 2.1.2013.10.16 of the add-in to the "Works in Progress" folder of the FILES area of the group.

I made changes to the smfGetAdvFNElement() routine that should allow data to be retrieved, using their new URL scheme. That means RCHGetElementNumber() functions for AdvFN elements should also work.

It appears to work for both general templates in the FILES area.

However, I can only test changes using their "www" prefix. I don't know if other regional prefixes will work or not. Or whether you even NEED to use other regional prefixes any more.

And, of course, when they do go their new beta format, all bets are off until THAT gets stabilized.

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

3g

Re: Beta version of add-in updated to work for AdvFN URL changes

Thu Oct 17, 2013 9:45 am (PDT) . Posted by:

mksmith64

Thanks Randy.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Ahhh. I'm an idiot. New update:

RCH_Stock_Market_Functions-2.1.2013.10.17.zip

I had hard-coded "MMM" as the ticker symbol when looking up the stock exchange (needed for the URL), so anything outside of NYSE wouldn't work. Now fixed.

My apologies.

BTW, I tried a few AMEX companies and noted that AdvFN had *no* financials for them.

On Thu, Oct 17, 2013 at 7:37 AM, <derekrwerner@... mailto:derekrwerner@...> wrote:
Just as an FYI, I can only get this beta version to work for companies listed on the NYSE. Companies listed on the NASDAQ all return errors.

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

4a

Re: Piotroski F-Scores / Altman Z-Scores

Thu Oct 17, 2013 7:49 am (PDT) . Posted by:

puuteknikko

Hi,

I'm trying to use the spreadsheet but for some reason, cells G24, G26-28, G30-31 and K5 only show "Error". The cell K14 (and K24 as a result) shows "#VALUE!", but is that due to a different decimal separator?

Thanks!

---In smf_addin@yahoogroups.com, <petekoch@...> wrote:

BTW, since this sheet does NOT use 10-year financial data, it works just fine without having to login to Morningstar, i.e., there is no requirement for a Morningstar subscription.

---In smf_addin@yahoogroups.com, <petekoch@...> wrote:

I have uploaded a fresh copy of Altman_Piotroski.xlsx to the files area.

I chose to use Morningstar as the data source via the smfGetCSVFile function. While I attempted to duplicate the previous version of this workbook, I don't completely trust the Z-Scores, but then I never really used them; I created the sheet in the first place largely for the Piotroski numbers, since I felt that the sites which provide them give scores which are generally too high.

Please note that the metrics Morningstar generates move around, i.e., one cannot trust that a particular metric will be in a specific row in an array. I overcame that (I think) with the additional cells at the top of the 'MStar' tab. These cells search the arrays for the metrics desired.

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

4b

Re: Piotroski F-Scores / Altman Z-Scores

Thu Oct 17, 2013 8:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Those cells all contain information coming from AdvFN. You'll get errors on
those unless you are using the new beta version of the add-in from the
"Works in Progress" folder from the FILES area of the group. That's because
AdvFN is messing around with the their URL structure.

On Thu, Oct 17, 2013 at 5:39 AM, <boulder08@gmail.com> wrote:

> I'm trying to use the spreadsheet but for some reason, cells G24,
> G26-28, G30-31 and K5 only show "Error". The cell K14 (and K24 as a result)
> shows "#VALUE!", but is that due to a different decimal separator?
>

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

5a

Close price by Date for S&P500 stocks

Thu Oct 17, 2013 8:00 am (PDT) . Posted by:

schlange.meister

Hi All,

I have the S&P500 stocks in the columns and dates in the rows. I would like to capture the close price for each stock for each day. I was looking through the RCHGetElementNumber Element Definition xls list, but did not see anything about close price.

Can anyone give me some code ideas on how to efficiently do this? Typically I would only need to collect 1 week of close prices for 500 securities.

Cheers

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

5b

Re: Close price by Date for S&P500 stocks

Thu Oct 17, 2013 8:13 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You would need to use the RCHGetYahooHistory() function to get closing
prices for the last week.

However, that is going to be a slow data retrieval, because you'll need to
access the Internet 500 times.

On Thu, Oct 17, 2013 at 8:00 AM, <schlange.meister@yahoo.com> wrote:

>
> I have the S&P500 stocks in the columns and dates in the rows. I would
> like to capture the close price for each stock for each day. I was looking
> through the RCHGetElementNumber Element Definition xls list, but did not
> see anything about close price.
>
> Can anyone give me some code ideas on how to efficiently do this?
> Typically I would only need to collect 1 week of close prices for 500
> securities.
>
>