Minggu, 04 Maret 2012

[smf_addin] Digest Number 2136

Messages In This Digest (7 Messages)

Messages

1a.

RCHGetYahooHistory() Question

Posted by: "tenenbaum88" kenneth.dooley@gmail.com   tenenbaum88

Sat Mar 3, 2012 4:41 am (PST)



Hi,

I've been using this add-in for a while now and absolutely love it! My question, though, is regarding the timing of the data updates for the RCHGetYahooHistory function. The function is currently returning the most recent data as of 3/1 when it is approximately 13 hours after the 3/2 market close. Yahoo has also updated its historical price feeds on the Yahoo Finance website. I'm just wondering if this is an issue on my end or Yahoo's?

Also, when I use the same function to return a closing price specifically for 3/2, I get the correct value ... so the information is definitely at Yahoo, just not being returned to me. Here is my usage of the function:

RCHGetYahooHistory("XYZ",,,,,,,"d",,,1,1,6,6)

for fetching the most recent 5 days of data on security "XYZ".

Thanks!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.

Re: RCHGetYahooHistory() Question

Posted by: "Randy H" rharmelink@gmail.com   rharmelink

Sat Mar 3, 2012 4:46 am (PST)



Check out item 9.4.2 in the "Links" area of the Yahoo group.

BTW -- if you're array-entering the formula over a 6x6 range, the pDim1
and pDim2 are unnecessary. Those default to the number of rows and
columns that the array-entered formula is entered over.

On Sat, Mar 3, 2012 at 4:54 AM, tenenbaum88 <kenneth.dooley@gmail.com>
wrote:
I've been using this add-in for a while now and absolutely love it! My
question, though, is regarding the timing of the data updates for the
RCHGetYahooHistory function. The function is currently returning the
most recent data as of 3/1 when it is approximately 13 hours after the
3/2 market close. Yahoo has also updated its historical price feeds on
the Yahoo Finance website. I'm just wondering if this is an issue on my
end or Yahoo's?

Also, when I use the same function to return a closing price
specifically for 3/2, I get the correct value ... so the information is
definitely at Yahoo, just not being returned to me. Here is my usage of
the function:

RCHGetYahooHistory("XYZ",,,,,,,"d",,,1,1,6,6)

for fetching the most recent 5 days of data on security "XYZ".

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

anyway to get energy information from EIA website using SMF addin to

Posted by: "tangela266" signalhill1998@gmail.com   tangela266

Sat Mar 3, 2012 11:06 am (PST)



Hi Randy:
i tried to use the smfGetCSVFile function to get information from EIA website such as weekly ending crude oil stock (as contained in http://www.eia.gov/dnav/pet/hist_xls/WCESTUS1w.xls). however, there is no data returned. I don't know if it is because the EIA files ends with .xls (i can't seem to find csv files based on sourcekeys) or because each of these data files contains two sheets, a content sheet and a "Data1" sheet which has the data I need. I have a bunch of data from EIA website that needs weekly updates and it'd be hugely helpful if the addin can be used here. a sample list of data are as follows:

WGTSTUS1; WGFSTUS1; WDISTUS1; WUOSTUS1; WRPUPUS2 etc etc

thanks a lot!
Tangela

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2b.

Re: anyway to get energy information from EIA website using SMF addi

Posted by: "Randy H" rharmelink@gmail.com   rharmelink

Sat Mar 3, 2012 11:57 am (PST)



If all you need it the updates, why not just pick up the weekly update
data from the HTML table?

=RCHGetTableCell("http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PE\
T&s=WCESTUS1&f=W
<http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=WCESTUS1&f=W>
",7,"2012-Feb")
=RCHGetTableCell("http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PE\
T&s=WCESTUS1&f=W
<http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=WCESTUS1&f=W>
",8,"2012-Feb")

Otherwise, you don't even need the add-in -- you can do something like
this, array-entered:

='http://www.eia.gov/dnav/pet/hist_xls/[WCESTUS1w.xls]Data 1'!$A$4:$B$10

On Sat, Mar 3, 2012 at 11:52 AM, tangela266 <signalhill1998@gmail.com
<mailto:signalhill1998@gmail.com> > wrote:

i tried to use the smfGetCSVFile function to get information from EIA
website such as weekly ending crude oil stock (as contained in
http://www.eia.gov/dnav/pet/hist_xls/WCESTUS1w.xls
<http://www.eia.gov/dnav/pet/hist_xls/WCESTUS1w.xls> ). however, there
is no data returned. I don't know if it is because the EIA files ends
with .xls (i can't seem to find csv files based on sourcekeys) or
because each of these data files contains two sheets, a content sheet
and a "Data1" sheet which has the data I need. I have a bunch of data
from EIA website that needs weekly updates and it'd be hugely helpful
if the addin can be used here. a sample list of data are as follows:

WGTSTUS1; WGFSTUS1; WDISTUS1; WUOSTUS1; WRPUPUS2 etc etc

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2c.

Re: anyway to get energy information from EIA website using SMF addi

Posted by: "tangela266" signalhill1998@gmail.com   tangela266

Sat Mar 3, 2012 7:22 pm (PST)




That's so awesome! I didn't know that. You're the best, Randy. Thanks a lot!
--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> If all you need it the updates, why not just pick up the weekly update
> data from the HTML table?
>
> =RCHGetTableCell("http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PE\
> T&s=WCESTUS1&f=W
> <http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=WCESTUS1&f=W>
> ",7,"2012-Feb")
> =RCHGetTableCell("http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PE\
> T&s=WCESTUS1&f=W
> <http://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=WCESTUS1&f=W>
> ",8,"2012-Feb")
>
> Otherwise, you don't even need the add-in -- you can do something like
> this, array-entered:
>
> ='http://www.eia.gov/dnav/pet/hist_xls/[WCESTUS1w.xls]Data 1'!$A$4:$B$10
>
> On Sat, Mar 3, 2012 at 11:52 AM, tangela266 <signalhill1998@...
> <mailto:signalhill1998@...> > wrote:
>
> i tried to use the smfGetCSVFile function to get information from EIA
> website such as weekly ending crude oil stock (as contained in
> http://www.eia.gov/dnav/pet/hist_xls/WCESTUS1w.xls
> <http://www.eia.gov/dnav/pet/hist_xls/WCESTUS1w.xls> ). however, there
> is no data returned. I don't know if it is because the EIA files ends
> with .xls (i can't seem to find csv files based on sourcekeys) or
> because each of these data files contains two sheets, a content sheet
> and a "Data1" sheet which has the data I need. I have a bunch of data
> from EIA website that needs weekly updates and it'd be hugely helpful
> if the addin can be used here. a sample list of data are as follows:
>
> WGTSTUS1; WGFSTUS1; WDISTUS1; WUOSTUS1; WRPUPUS2 etc etc
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

RCHGetTableCell() question for particular stocks

Posted by: "T A R U N" tarunparmar@gmail.com   tarun_1457

Sat Mar 3, 2012 3:10 pm (PST)



Hi Randy,
I am using RCHGetTableCell() in excel to pull list of Small Caps filtered from Yahoo. Problem is it does not work for particular stocks. Not sure why, I am using function to pull data from morningstar and gurufocus.
=RCHGetTableCell("http://quicktake.morningstar.com/StockNet/cashflow10.aspx?Symbol="&A4,2,">Free Cash Flow",">Free Cash Flow")
OR
=RCHGetTableCell("http://www.gurufocus.com/financials.php?symbol="&A4,COLUMNS($H:H),">"&Free Cash Flow&"<")
Where tickers like ZBRA, ATK, does not pull data. But LSCC, NR, etc pull fine.
Any idea?

Thanks,
tarun

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.

Re: RCHGetTableCell() question for particular stocks

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Mar 3, 2012 3:48 pm (PST)



Not sure what to tell you. I just tried all four ticker symbols and they
all worked fine here.

On Sat, Mar 3, 2012 at 3:47 PM, T A R U N <tarunparmar@gmail.com> wrote:

>
> I am using RCHGetTableCell() in excel to pull list of Small Caps filtered
> from Yahoo. Problem is it does not work for particular stocks. Not sure
> why, I am using function to pull data from morningstar and gurufocus.
> =RCHGetTableCell("
> http://quicktake.morningstar.com/StockNet/cashflow10.aspx?Symbol="&A4,2,">Free
> Cash Flow",">Free Cash Flow")
> OR
> =RCHGetTableCell("http://www.gurufocus.com/financials.php?symbol="&A4,COLUMNS($H:H),">"&Free
> Cash Flow&"<")
> Where tickers like ZBRA, ATK, does not pull data. But LSCC, NR, etc pull
> fine.
> Any idea?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 02.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)