15 New Messages
Digest #2823
Messages
Tue Oct 22, 2013 6:46 am (PDT) . Posted by:
"Liyang Chen" lchen257
nice and simple solution, much appreciated it!
Regards,
LY
On Tuesday, October 22, 2013 3:22 AM, "lchen257@yahoo.ca" <lchen257@yahoo.ca> wrote:
Thank you for the quick reply.
Do you suggest any way to retrieve share price?
I tried to use RCHGetElementNumber("Ticker", 25) with no luck.
The first ticker worked, but all subsequent tickers showed "error" as its value.
Thanks again,
LY
LY
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Unfortunately, I don't think Yahoo is gets ECN data any more. So I'm not sure how accurate or reliable the ECN data codes are..?
But it looks like they are putting HTML tags for a web page display of the data, instead of returning raw data. Note that "k1" is supposed to return time and last price, so the "N/A" is probably the time they put in when the market is closed.
On Mon, Oct 21, 2013 at 11:33 PM, <lchen257@...> wrote:
>
>
>>
>>First just want to say thank you for providing this superb tool for the public to use!
>>
>>
>>I just started using SMF and am having difficulties getting data from the datacodelist k1.
>>
>>
>>For example, instead of showing 522 as the share price, it shows this:
>>
>>
>>N/A - <b>522.00</b>
>>
>
Regards,
LY
On Tuesday, October 22, 2013 3:22 AM, "lchen257@yahoo.
Thank you for the quick reply.
Do you suggest any way to retrieve share price?
I tried to use RCHGetElementNumber
The first ticker worked, but all subsequent tickers showed "error" as its value.
Thanks again,
LY
LY
---In smf_addin@yahoogrou
Unfortunately, I don't think Yahoo is gets ECN data any more. So I'm not sure how accurate or reliable the ECN data codes are..?
But it looks like they are putting HTML tags for a web page display of the data, instead of returning raw data. Note that "k1" is supposed to return time and last price, so the "N/A" is probably the time they put in when the market is closed.
On Mon, Oct 21, 2013 at 11:33 PM, <lchen257@
>
>
>>
>>First just want to say thank you for providing this superb tool for the public to use!
>>
>>
>>I just started using SMF and am having difficulties getting data from the datacodelist k1.
>>
>>
>>For example, instead of showing 522 as the share price, it shows this:
>>
>>
>>N/A - <b>522.
>>
>
Tue Oct 22, 2013 7:05 am (PDT) . Posted by:
clayspurgeon
I tried the workaround you posted in the links section for AdvFN - still getting error message. Should I use an earlier version of the add-in? Or is there an easier site to get 10 yr financials from?
Thanks again,
C
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Do you need a prefix other than "www"? I don't know if those work with the new code.
On Mon, Oct 21, 2013 at 6:14 PM, <clayspurgeon@... mailto:clayspurgeon@...> wrote:
First of all, many thanks for all your work and for making this available. I'm new so apologies in advance, but I'm getting errors on the AdvFN elements. All other data elements seem to work fine for me. I'm using the 10.17 version.
Thanks again,
C
---In smf_addin@yahoogrou
Do you need a prefix other than "www"
On Mon, Oct 21, 2013 at 6:14 PM, <clayspurgeon@
First of all, many thanks for all your work and for making this available. I'm new so apologies in advance, but I'm getting errors on the AdvFN elements. All other data elements seem to work fine for me. I'm using the 10.17 version.
Tue Oct 22, 2013 8:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
An earlier version of the add-in won't help with AdvFN. They've since
changed their URL structure.
Easiest is probably the CSV file from MorningStar. Check the LINKS area of
the group for more information.
On Tue, Oct 22, 2013 at 7:05 AM, <clayspurgeon@gmail.com> wrote:
> I tried the workaround you posted in the links section for AdvFN - still
> getting error message. Should I use an earlier version of the add-in? Or
> is there an easier site to get 10 yr financials from?
>
changed their URL structure.
Easiest is probably the CSV file from MorningStar. Check the LINKS area of
the group for more information.
On Tue, Oct 22, 2013 at 7:05 AM, <clayspurgeon@
> I tried the workaround you posted in the links section for AdvFN - still
> getting error message. Should I use an earlier version of the add-in? Or
> is there an easier site to get 10 yr financials from?
>
Tue Oct 22, 2013 8:48 am (PDT) . Posted by:
lchen257
Hello Randy,
I've been trying out a lot of the balance sheet/income statement/cashflow related elements, and resulting in "error" messages.
Wondering if this is common or it's something with my computer/software.
Regards,
LY
I've been trying out a lot of the balance sheet/income statement/cashflow related elements, and resulting in "error" messages.
Wondering if this is common or it's something with my computer/software.
Regards,
LY
Tue Oct 22, 2013 9:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Since you didn't provide details, I'll have to take a guess about what the
problem might be...
If they are AdvFN elements, you need the beta version of the add-in from
the "Works in Progress" folder from the FILES area of the group to access
them. Over the past few months, AdvFN has been messing around with their
website, so changes to the add-in were necessary.
Unfortunately, website changes are not an uncommon problem. MSN seems to
like to do it once a year.
On Tue, Oct 22, 2013 at 8:48 AM, <lchen257@yahoo.ca> wrote:
>
> I've been trying out a lot of the balance sheet/income statement/cashflow
> related elements, and resulting in "error" messages.
>
> Wondering if this is common or it's something with my computer/software.
>
>
problem might be...
If they are AdvFN elements, you need the beta version of the add-in from
the "Works in Progress" folder from the FILES area of the group to access
them. Over the past few months, AdvFN has been messing around with their
website, so changes to the add-in were necessary.
Unfortunately, website changes are not an uncommon problem. MSN seems to
like to do it once a year.
On Tue, Oct 22, 2013 at 8:48 AM, <lchen257@yahoo.
>
> I've been trying out a lot of the balance sheet/income statement/cashflow
> related elements, and resulting in "error" messages.
>
> Wondering if this is common or it's something with my computer/software.
>
>
Tue Oct 22, 2013 10:26 am (PDT) . Posted by:
lchen257
Thank you for the reply.
Is there anyway for me to help keep the elements up to date?
Or is it more of an reactive thing whenever one of the websites make changes.
Regards,
LY
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Since you didn't provide details, I'll have to take a guess about what the problem might be...
If they are AdvFN elements, you need the beta version of the add-in from the "Works in Progress" folder from the FILES area of the group to access them. Over the past few months, AdvFN has been messing around with their website, so changes to the add-in were necessary.
Unfortunately, website changes are not an uncommon problem. MSN seems to like to do it once a year.
On Tue, Oct 22, 2013 at 8:48 AM, <lchen257@... mailto:lchen257@...> wrote:
I've been trying out a lot of the balance sheet/income statement/cashflow related elements, and resulting in "error" messages.
Wondering if this is common or it's something with my computer/software.
Is there anyway for me to help keep the elements up to date?
Or is it more of an reactive thing whenever one of the websites make changes.
Regards,
LY
---In smf_addin@yahoogrou
Since you didn't provide details, I'll have to take a guess about what the problem might be...
If they are AdvFN elements, you need the beta version of the add-in from the "Works in Progress" folder from the FILES area of the group to access them. Over the past few months, AdvFN has been messing around with their website, so changes to the add-in were necessary.
Unfortunately, website changes are not an uncommon problem. MSN seems to like to do it once a year.
On Tue, Oct 22, 2013 at 8:48 AM, <lchen257@
I've been trying out a lot of the balance sheet/income statement/cashflow related elements, and resulting in "error" messages.
Wondering if this is common or it's something with my computer/software.
Tue Oct 22, 2013 12:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I usually post new element definitions to the "Works in Progress" folder
when I make them -- they are the smf-elements-*.txt files. However, this
last change for AdvFN also required a coding change to the add-in itself,
which is why a new version was posted to the "Works in Progress" folder.
But it's definitely a reactive progress. None of the data providers have me
in on their prospective changes. :)
I usually find out when someone tells me that something isn't working any
more. Because I personally only use a small subset of what the add-in can
do.
And, actually, the vast majority of element definitions are just saved
versions of an RCHGetTableCell() function. So you could even do the
extractions yourself, independent of the element definitions.
On Tue, Oct 22, 2013 at 10:26 AM, <lchen257@yahoo.ca> wrote:
> Is there anyway for me to help keep the elements up to date?
>
> Or is it more of an reactive thing whenever one of the websites make
> changes.
>
>
when I make them -- they are the smf-elements-
last change for AdvFN also required a coding change to the add-in itself,
which is why a new version was posted to the "Works in Progress" folder.
But it's definitely a reactive progress. None of the data providers have me
in on their prospective changes. :)
I usually find out when someone tells me that something isn't working any
more. Because I personally only use a small subset of what the add-in can
do.
And, actually, the vast majority of element definitions are just saved
versions of an RCHGetTableCell(
extractions yourself, independent of the element definitions.
On Tue, Oct 22, 2013 at 10:26 AM, <lchen257@yahoo.
> Is there anyway for me to help keep the elements up to date?
>
> Or is it more of an reactive thing whenever one of the websites make
> changes.
>
>
Tue Oct 22, 2013 9:18 am (PDT) . Posted by:
lewglenn
Thanks, Randy.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
They probably calculate them on the fly, since you can specify any period you want for the moving averages. Just because they calculate them there doesn't mean they would provide them on the CSV file feed, or state the average on any of their web pages.
You could always calculate it yourself from their historical quotes, but it would be a slow process if you need it for a number of funds. For example:
=AVERAGE(RCHGetYahooHistory("FBIOX";,,,,,,,,"a",0,,,50,1))
By the way, this would give you a different answer for stocks and ETFs than what Yahoo provides. Because, for some reason, Yahoo's 50-day (and 200-day) moving average values are based on the number of calendar days instead of trading days.
On Mon, Oct 21, 2013 at 4:58 PM, <lewglenn@... mailto:lewglenn@...> wrote:
When I go to Yahoo! Finance and pull up FBIOX, then go to 'Charts > Interactive' I can display the price of this fund over any period I choose, and also (under Technical Indicators) the SMA over any period I choose. So Yahoo most certainly computes the 50-day moving average. The question then, is where does it store this info.
---In smf_addin@yahoogrou
They probably calculate them on the fly, since you can specify any period you want for the moving averages. Just because they calculate them there doesn't mean they would provide them on the CSV file feed, or state the average on any of their web pages.
You could always calculate it yourself from their historical quotes, but it would be a slow process if you need it for a number of funds. For example:
=AVERAGE(RCHGetYaho
By the way, this would give you a different answer for stocks and ETFs than what Yahoo provides. Because, for some reason, Yahoo's 50-day (and 200-day) moving average values are based on the number of calendar days instead of trading days.
On Mon, Oct 21, 2013 at 4:58 PM, <lewglenn@
When I go to Yahoo! Finance and pull up FBIOX, then go to 'Charts > Interactive&#
Tue Oct 22, 2013 12:04 pm (PDT) . Posted by:
"Kai Friedrichs" kai_friedrichs
Hi everybody,
is there a possibility to get not only the price history but also the history of Earnings or Price/Earnings-Ratios with the help of RCHGetYahooHistory() ?
If not, is there any other possibility to get the history of these numbers beside the history of stock prices in an Excel-Sheet?
Would be great to get some information on these question!
Best wishes,
Kai
is there a possibility to get not only the price history but also the history of Earnings or Price/Earnings-
If not, is there any other possibility to get the history of these numbers beside the history of stock prices in an Excel-Sheet?
Would be great to get some information on these question!
Best wishes,
Kai
Tue Oct 22, 2013 12:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not with RCHGetYahooHistory(). That isn't something Yahoo provides.
The best source is AdvFN. However, they've recently been updating their
website, so you'll need the beta version of the add-in from the "Works in
Progress" folder to access the elements defined for their site.
Or you could access them directly:
http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=quarterly_reports&mode=company_data
Someone recently noted that Zacks has a page on earnings as well:
http://www.zacks.com/stock/research/IBM/earnings-announcements
On Tue, Oct 22, 2013 at 11:31 AM, Kai Friedrichs <kai_friedrichs@yahoo.de>wrote:
>
> is there a possibility to get not only the price history but also the
> history of Earnings or Price/Earnings-Ratios with the help of
> RCHGetYahooHistory() ?
> If not, is there any other possibility to get the history of these numbers
> beside the history of stock prices in an Excel-Sheet?
> Would be great to get some information on these question!
>
>
The best source is AdvFN. However, they've recently been updating their
website, so you'll need the beta version of the add-in from the "Works in
Progress" folder to access the elements defined for their site.
Or you could access them directly:
http://www.advfn.
Someone recently noted that Zacks has a page on earnings as well:
http://www.zacks.
On Tue, Oct 22, 2013 at 11:31 AM, Kai Friedrichs <kai_friedrichs@
>
> is there a possibility to get not only the price history but also the
> history of Earnings or Price/Earnings-
> RCHGetYahooHistory(
> If not, is there any other possibility to get the history of these numbers
> beside the history of stock prices in an Excel-Sheet?
> Would be great to get some information on these question!
>
>
Tue Oct 22, 2013 12:18 pm (PDT) . Posted by:
jsmithman1083
When I open the10 Year Model - ADVFN-New Format template in the User Submitted templates section of the forum and try to enable data and link connections I get an error message that says "This workbook contains one or more links that cannot be updated." When I go to edit links the source RCH_Stock_Functions.xla has a status that is "unknown."
How do I get get a connection that will update the worksheet?
How do I get get a connection that will update the worksheet?
Tue Oct 22, 2013 12:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See the "Location Errors" item in the LINKS area of the group.
On Tue, Oct 22, 2013 at 12:15 PM, <jsmithman1083@yahoo.com> wrote:
>
> When I open the10 Year Model - ADVFN-New Format template in the User
> Submitted templates section of the forum and try to enable data and link
> connections I get an error message that says "This workbook contains one or
> more links that cannot be updated." When I go to edit links the source
> RCH_Stock_Functions.xla has a status that is "unknown."
>
> How do I get get a connection that will update the worksheet?
>
On Tue, Oct 22, 2013 at 12:15 PM, <jsmithman1083@
>
> When I open the10 Year Model - ADVFN-New Format template in the User
> Submitted templates section of the forum and try to enable data and link
> connections I get an error message that says "This workbook contains one or
> more links that cannot be updated." When I go to edit links the source
> RCH_Stock_Functions
>
> How do I get get a connection that will update the worksheet?
>
Tue Oct 22, 2013 12:34 pm (PDT) . Posted by:
lchen257
Hello Randy,
Searched through the conversations and couldn't find the answer.
all the data was working fine until I closed Excel2010 and reopened it.
The cells for RCHGetYahooQuotes still works but all the other cells using RCHGetElementNumber are returning "error".
I was so happy while it was working....
Regards,
Liyang
Searched through the conversations and couldn't find the answer.
all the data was working fine until I closed Excel2010 and reopened it.
The cells for RCHGetYahooQuotes still works but all the other cells using RCHGetElementNumber are returning "error"
I was so happy while it was working....
Regards,
Liyang
Tue Oct 22, 2013 12:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Give me some examples. Otherwise, I have nothing to look at. But your
symptoms certainly sound strange.
On Tue, Oct 22, 2013 at 12:34 PM, <lchen257@yahoo.ca> wrote:
>
> Searched through the conversations and couldn't find the answer.
>
> all the data was working fine until I closed Excel2010 and reopened it.
>
> The cells for RCHGetYahooQuotes still works but all the other cells using
> RCHGetElementNumber are returning "error".
>
> I was so happy while it was working....
>
>
symptoms certainly sound strange.
On Tue, Oct 22, 2013 at 12:34 PM, <lchen257@yahoo.
>
> Searched through the conversations and couldn't find the answer.
>
> all the data was working fine until I closed Excel2010 and reopened it.
>
> The cells for RCHGetYahooQuotes still works but all the other cells using
> RCHGetElementNumber are returning "error"
>
> I was so happy while it was working....
>
>
Tue Oct 22, 2013 1:00 pm (PDT) . Posted by:
"Liyang Chen" lchen257
The first 5 columns are hard coded so no problem there, 6th column is =RCHGetElementNumber(A3,941) and it worked for the entire column before closing and now it shows all errors. the "P/E" column still works though, and it is using =RCHGetYahooQuotes(A3,"r",,"NOW()")
Regards,
LY
On Tuesday, October 22, 2013 3:43 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
Give me some examples. Otherwise, I have nothing to look at. But your symptoms certainly sound strange.
On Tue, Oct 22, 2013 at 12:34 PM, <lchen257@yahoo.ca> wrote:
>
>Searched through the conversations and couldn't find the answer.
>
>
>all the data was working fine until I closed Excel2010 and reopened it.
>
>
>The cells for RCHGetYahooQuotes still works but all the other cells using RCHGetElementNumber are returning "error".
>
>
>I was so happy while it was working....
>
Regards,
LY
On Tuesday, October 22, 2013 3:43 PM, Randy Harmelink <rharmelink@gmail.
Give me some examples. Otherwise, I have nothing to look at. But your symptoms certainly sound strange.
On Tue, Oct 22, 2013 at 12:34 PM, <lchen257@yahoo.
>
>Searched through the conversations and couldn't find the answer.
>
>
>all the data was working fine until I closed Excel2010 and reopened it.
>
>
>The cells for RCHGetYahooQuotes still works but all the other cells using RCHGetElementNumber are returning "error"
>
>
>I was so happy while it was working....
>
Attachments with this message:
1 of 1 Photo(s)
Tidak ada komentar:
Posting Komentar