14 Messages
Digest #3012
Messages
Thu Mar 20, 2014 1:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There was a problem with Yahoo this morning. I couldn't even get the
"Download" links to work from their web pages, which is what feeds
RCHGetYahooQuotes(). So whatever servers serve up the CSV files wasn't
working early in the day.
On Thu, Mar 20, 2014 at 9:11 AM, <ccoupe300@gmail.com> wrote:
>
> Same thing here. RCHGetYahooQuotes array stopped working, Can't retrieve
> any Yahoo data though their website data seems to be up. I even updated the
> add-in files and tried different computers, it made no difference.
>
> RCHGetElementNumber functions are still working.
>
> Does anyone know if there is a problem with Yahoo?
>
>
"Download" links to work from their web pages, which is what feeds
RCHGetYahooQuotes(). So whatever servers serve up the CSV files wasn't
working early in the day.
On Thu, Mar 20, 2014 at 9:11 AM, <ccoupe300@gmail.com> wrote:
>
> Same thing here. RCHGetYahooQuotes array stopped working, Can't retrieve
> any Yahoo data though their website data seems to be up. I even updated the
> add-in files and tried different computers, it made no difference.
>
> RCHGetElementNumber functions are still working.
>
> Does anyone know if there is a problem with Yahoo?
>
>
Thu Mar 20, 2014 1:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Different templates would have different items from your list.
Review the element definitions and you should find a number of sources for
historical P/E ratios and earnings. On a quarterly basis, you're probably
limited to AdvFN.
RCHGetYahooHistory() is the primary source of historical stock prices.
On Thu, Mar 20, 2014 at 8:48 AM, Christopher G. Skyba <cskyba@yahoo.com>wrote:
>
> New to this group.
>
> Was wondering if anyone has a template I can use for historical P/E
> ratios, stock prices, earnings, etc. for a quarterly basis.
>
>
Review the element definitions and you should find a number of sources for
historical P/E ratios and earnings. On a quarterly basis, you're probably
limited to AdvFN.
RCHGetYahooHistory() is the primary source of historical stock prices.
On Thu, Mar 20, 2014 at 8:48 AM, Christopher G. Skyba <cskyba@yahoo.com>wrote:
>
> New to this group.
>
> Was wondering if anyone has a template I can use for historical P/E
> ratios, stock prices, earnings, etc. for a quarterly basis.
>
>
Thu Mar 20, 2014 5:32 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I guess I was not smart enough to parse the yahoo results. For stocks with multiple splits like PCAR
Plus, it appears to me that yahoo only has split history for stock that has Key statistics. Like AAIT
I could be wrong about that part
Thanks,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, March 20, 2014 4:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] HElp with webpage http://www.splithistory.com/?symbol=pcar
The table isn't coded properly, so you can't use RCHGetHTMLTable(). This seems to work best:
=smfGetTagContent("http://www.splithistory.com/?symbol=pcar","td",1,">Ratio")
...incrementing the 1 as needed.
What problems did you run into just using Yahoo?
On Thu, Mar 20, 2014 at 8:09 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
Randy, I have played with this for a few hours without any solution. I know I'm making it much harder than it should be.
Can you tell me what is most efficient method to get the PCAR Split History into a spreadsheet.
http://www.splithistory.com/?symbol=pcar I used PCAR because it has multiple splits.
I was able to get split history from http://getsplithistory.com for other stocks but they don't support all stocks such as EGPT.
I haven't found any site that supports all stocks. So I am having to build my own list of sources for splits and dividends.
Thanks, I truly appreciate all you do for us.
Plus, it appears to me that yahoo only has split history for stock that has Key statistics. Like AAIT
I could be wrong about that part
Thanks,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, March 20, 2014 4:22 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] HElp with webpage http://www.splithistory.com/?symbol=pcar
The table isn't coded properly, so you can't use RCHGetHTMLTable(). This seems to work best:
=smfGetTagContent("http://www.splithistory.com/?symbol=pcar","td",1,">Ratio")
...incrementing the 1 as needed.
What problems did you run into just using Yahoo?
On Thu, Mar 20, 2014 at 8:09 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
Randy, I have played with this for a few hours without any solution. I know I'm making it much harder than it should be.
Can you tell me what is most efficient method to get the PCAR Split History into a spreadsheet.
http://www.splithistory.com/?symbol=pcar I used PCAR because it has multiple splits.
I was able to get split history from http://getsplithistory.com for other stocks but they don't support all stocks such as EGPT.
I haven't found any site that supports all stocks. So I am having to build my own list of sources for splits and dividends.
Thanks, I truly appreciate all you do for us.
Thu Mar 20, 2014 7:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/14400
On Thu, Mar 20, 2014 at 5:32 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> I guess I was not smart enough to parse the yahoo results. For stocks with
> multiple splits like PCAR
>
>
>
> Plus, it appears to me that yahoo only has split history for stock that
> has Key statistics. Like AAIT
>
> I could be wrong about that part
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/14400
On Thu, Mar 20, 2014 at 5:32 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> I guess I was not smart enough to parse the yahoo results. For stocks with
> multiple splits like PCAR
>
>
>
> Plus, it appears to me that yahoo only has split history for stock that
> has Key statistics. Like AAIT
>
> I could be wrong about that part
>
>
>
Thu Mar 20, 2014 6:23 pm (PDT) . Posted by:
"V. Shankar" tarakayan
I was wondering if there will be new version of smf addin for 2013. I just added my earlier version from other other computer and works just fine. Are there any new add in versions or existing should be ok?
thanks,
Shankar
thanks,
Shankar
Thu Mar 20, 2014 7:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The most recent official release is 2014.01.30:
http://ogres-crypt.com/SMF/
See the change log for features you might want:
http://ogres-crypt.com/SMF/Documentation/
On Thu, Mar 20, 2014 at 6:23 PM, V. Shankar <tarakayan@yahoo.com> wrote:
>
> I was wondering if there will be new version of smf addin for 2013. I
> just added my earlier version from other other computer and works just
> fine. Are there any new add in versions or existing should be ok?
>
>
http://ogres-crypt.com/SMF/
See the change log for features you might want:
http://ogres-crypt.com/SMF/Documentation/
On Thu, Mar 20, 2014 at 6:23 PM, V. Shankar <tarakayan@yahoo.com> wrote:
>
> I was wondering if there will be new version of smf addin for 2013. I
> just added my earlier version from other other computer and works just
> fine. Are there any new add in versions or existing should be ok?
>
>
Thu Mar 20, 2014 7:53 pm (PDT) . Posted by:
lawrence.leesh
Hi Randy When I put the stock symbol in another cell and refer the formula to it, it returns a blank. Are you able to get it to work by referring to a cell for the symbol?
thanks
LL
thanks
LL
Thu Mar 20, 2014 7:57 pm (PDT) . Posted by:
lawrence.leesh
Very strange. I find that it works if the symbol is keyed in entirely in large caps. If I use small caps, this formula returns a blank even though other formulas that use element number works.
Thu Mar 20, 2014 8:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't have a problem either way. If I used this formula:
=smfstrExtr(smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s="&D4,"p",-1,"Currency
in")," in ",".")
...I can put either "N4E.SI" or "n4e.si" or "MMM" or "mmm" in cell D4 and
it works fine.
On Thu, Mar 20, 2014 at 7:57 PM, <lawrence.leesh@yahoo.com> wrote:
>
> Very strange. I find that it works if the symbol is keyed in entirely in
> large caps. If I use small caps, this formula returns a blank even though
> other formulas that use element number works.
>
=smfstrExtr(smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s="&D4,"p",-1,"Currency
in")," in ",".")
...I can put either "N4E.SI" or "n4e.si" or "MMM" or "mmm" in cell D4 and
it works fine.
On Thu, Mar 20, 2014 at 7:57 PM, <lawrence.leesh@yahoo.com> wrote:
>
> Very strange. I find that it works if the symbol is keyed in entirely in
> large caps. If I use small caps, this formula returns a blank even though
> other formulas that use element number works.
>
Thu Mar 20, 2014 8:01 pm (PDT) . Posted by:
"Daniel Russell" udelfb92
I put a fx spreadsheet that allows you to pull an fx pair historically. This would allow you to concert financial statements using the temporal method.Anyways, the spreadsheet is in the examples folder, I don't know if it made it to the new website yet.
Cheers,
Danny
OsoCapitalResearch.com
—
Sent from Mailbox for iPhone
On Thu, Mar 20, 2014 at 10:57 PM, null <lawrence.leesh@yahoo.com> wrote:
> Very strange. I find that it works if the symbol is keyed in entirely in large caps. If I use small caps, this formula returns a blank even though other formulas that use element number works.
Cheers,
Danny
OsoCapitalResearch.com
—
Sent from Mailbox for iPhone
On Thu, Mar 20, 2014 at 10:57 PM, null <lawrence.leesh@yahoo.com> wrote:
> Very strange. I find that it works if the symbol is keyed in entirely in large caps. If I use small caps, this formula returns a blank even though other formulas that use element number works.
Thu Mar 20, 2014 8:30 pm (PDT) . Posted by:
lawrence.leesh
This is not the case in my computer. I suspect it is due to Excel 2007 version.
Thu Mar 20, 2014 8:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I use EXCEL 2007.
Yahoo's been flaky today. Did you try an smfForceRecalculation? Maybe you
timed out getting a web page from Yahoo.
On Thu, Mar 20, 2014 at 8:30 PM, <lawrence.leesh@yahoo.com> wrote:
>
> This is not the case in my computer. I suspect it is due to Excel 2007
> version.
>
Yahoo's been flaky today. Did you try an smfForceRecalculation? Maybe you
timed out getting a web page from Yahoo.
On Thu, Mar 20, 2014 at 8:30 PM, <lawrence.leesh@yahoo.com> wrote:
>
> This is not the case in my computer. I suspect it is due to Excel 2007
> version.
>
Tidak ada komentar:
Posting Komentar