6 New Messages
Digest #2845
Messages
Thu Nov 7, 2013 1:36 am (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
Thanks for the effort Randy !!
Looking forward to it !
Is there any other way I could extract ? Like with url ?
If yes could you please help with syntax ?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Unfortunately, not an easy extraction. The data isn't in a table, but located in JavaScript code and put onto the web page dynamically. That means extracting it out of that JavaScript code.
I'm looking at replacing the earnings.com http://earnings.com quarterly earnings items with data from this page. Stay tuned.
On Tue, Nov 5, 2013 at 9:50 AM, <johkouf@... mailto:johkouf@...> wrote:
There is this Url that has past quarterly Eps
http://www.zacks.com/stock/research/IBM/earnings-announcements http://www.zacks.com/stock/research/IBM/earnings-announcements
How can I ask Randy to get element number ?
Looking forward to it !
Is there any other way I could extract ? Like with url ?
If yes could you please help with syntax ?
---In smf_addin@yahoogrou
Unfortunately, not an easy extraction. The data isn't in a table, but located in JavaScript code and put onto the web page dynamically. That means extracting it out of that JavaScript code.
I'm looking at replacing the earnings.com http://earnings.
On Tue, Nov 5, 2013 at 9:50 AM, <johkouf@
There is this Url that has past quarterly Eps
http://www.zacks.
How can I ask Randy to get element number ?
Thu Nov 7, 2013 3:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I updated the element definitions a few days ago -- see:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24316
I posted an example of one of the extractions. :)
On Thu, Nov 7, 2013 at 2:36 AM, <johkouf@hotmail.com> wrote:
> Looking forward to it !
>
> Is there any other way I could extract ? Like with url ?
> If yes could you please help with syntax ?
>
http://groups.
I posted an example of one of the extractions. :)
On Thu, Nov 7, 2013 at 2:36 AM, <johkouf@hotmail.
> Looking forward to it !
>
> Is there any other way I could extract ? Like with url ?
> If yes could you please help with syntax ?
>
Thu Nov 7, 2013 5:53 am (PST) . Posted by:
bushpilote
Thanks Danny.
---In smf_addin@yahoogroups.com, <dannyrussell53@...> wrote:
Hi,
For some reason my name in the group is an extraordinarily long number. Anyways, the data was partially restructured so I fixed the code and now it should work. Hopefully this is helpful as FX data is hard to come by.
Best,
Danny Russell
OsoCapitalResearch.Com
---In smf_addin@yahoogrou
Hi,
For some reason my name in the group is an extraordinarily long number. Anyways, the data was partially restructured so I fixed the code and now it should work. Hopefully this is helpful as FX data is hard to come by.
Best,
Danny Russell
OsoCapitalResearch.
Thu Nov 7, 2013 5:12 pm (PST) . Posted by:
"Yahoo!" lewglenn
Randy,
In the example you provided to compute the 50-day SMA:
=AVERAGE(RCHGetYahooHistory("FBIOX";,,,,,,,,"a",0,,,50,1))
the last 2 entries in the function are not described in the online documentation. Is there a newer version of the documentation for RCHGetYahooHistory or is this the normal way AVERAGE & RCHGetYahooHistory are combined? What is the significance of the '1" after the '50'?
Thanks.
On Tuesday, October 22, 2013 9:19 AM, "lewglenn@yahoo.com" <lewglenn@yahoo.com> wrote:
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@...> 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 the example you provided to compute the 50-day SMA:
=AVERAGE(RCHGetYaho
the last 2 entries in the function are not described in the online documentation. Is there a newer version of the documentation for RCHGetYahooHistory or is this the normal way AVERAGE & RCHGetYahooHistory are combined? What is the significance of the '1" after the '50'
Thanks.
On Tuesday, October 22, 2013 9:19 AM, "lewglenn@yahoo.
Thanks, Randy.
---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&#
>>
>
Thu Nov 7, 2013 6:31 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Those are undocumented parameters that I originally added for my own use,
so I could use the function in VBA. I didn't really want to document them
because I didn't want people using them -- in case I wanted to add more
parameters to the function. If so, I would want them in FRONT of those two
parameters, which is a problem if people are using them in worksheet
invocations.
The "pDim1" and "pDim2" parameters in any function that returns an array of
data define the number of rows and columns of data that the function should
return. In general, those dimensions are usually set when you array-enter
those functions.
So, in this case, those parameters are telling RCHGetYahooHistory() to
return 50 rows of data within a single column. It's the same result you
would get if you array-entered the formula without those parameters, in a
50-row by 1-column worksheet range.
On Thu, Nov 7, 2013 at 6:12 PM, Yahoo! <lewglenn@yahoo.com> wrote:
>
> In the example you provided to compute the 50-day SMA:
>
> =AVERAGE(RCHGetYahooHistory("FBIOX";,,,,,,,,"a",0,,,50,1))
>
> the last 2 entries in the function are not described in the online
> documentation. Is there a newer version of the documentation for
> RCHGetYahooHistory or is this the normal way AVERAGE & RCHGetYahooHistory
> are combined? What is the significance of the '1" after the '50'?
>
>
so I could use the function in VBA. I didn't really want to document them
because I didn't want people using them -- in case I wanted to add more
parameters to the function. If so, I would want them in FRONT of those two
parameters, which is a problem if people are using them in worksheet
invocations.
The "pDim1" and "pDim2" parameters in any function that returns an array of
data define the number of rows and columns of data that the function should
return. In general, those dimensions are usually set when you array-enter
those functions.
So, in this case, those parameters are telling RCHGetYahooHistory(
return 50 rows of data within a single column. It's the same result you
would get if you array-entered the formula without those parameters, in a
50-row by 1-column worksheet range.
On Thu, Nov 7, 2013 at 6:12 PM, Yahoo! <lewglenn@yahoo.
>
> In the example you provided to compute the 50-day SMA:
>
> =AVERAGE(RCHGetYaho
>
> the last 2 entries in the function are not described in the online
> documentation. Is there a newer version of the documentation for
> RCHGetYahooHistory or is this the normal way AVERAGE & RCHGetYahooHistory
> are combined? What is the significance of the '1" after the '50'
>
>
Thu Nov 7, 2013 8:36 pm (PST) . Posted by:
dcharlotte99
Errors for symbol XOM, comparing spreadsheet vs website:
Cash Flow Statement:
Dec 2003- Net Income does not match
On the website oddly - Change in Deferred Tax is listed twice on the Cash Flow Statement, and has different data in the columns.
I haven't checked a lot the above was just from a pretty quick skim of the data.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
The latest one is in the "Uploads by forum members" folder in the FILES area of the group, dated Nov 3.
On Thu, Nov 7, 2013 at 1:24 AM, <dennismontegnies@... mailto:dennismontegnies@...> wrote:
Where to find the current updated model?
Cash Flow Statement:
Dec 2003- Net Income does not match
On the website oddly - Change in Deferred Tax is listed twice on the Cash Flow Statement, and has different data in the columns.
I haven't checked a lot the above was just from a pretty quick skim of the data.
---In smf_addin@yahoogrou
The latest one is in the "Uploads by forum members" folder in the FILES area of the group, dated Nov 3.
On Thu, Nov 7, 2013 at 1:24 AM, <dennismontegnie
Where to find the current updated model?
Tidak ada komentar:
Posting Komentar