hi randy,

there is a problem when i tried to extract wall street journal
data such as income statement and balance sheet
there seems to be an apache problem stated
something wrong with wall street journal?
thanks

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

1b

Re: problem with wall street journal

Sat Sep 28, 2013 8:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I have no idea. I don't use the site.

URL? Sample formula?

On Sat, Sep 28, 2013 at 5:51 AM, <weekeewawa@yahoo.com> wrote:

> there is a problem when i tried to extract wall street journal data such
> as income statement and balance sheet
>
> there seems to be an apache problem stated
>
> something wrong with wall street journal?
>
>

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

1c

Re: problem with wall street journal

Sat Sep 28, 2013 10:15 am (PDT) . Posted by:

weekeewawa

hi randy
=RCHGetTableCell("http://quotes.wsj.com/IBM/financials/annual/inc\
ome-statement",3,"Sales/Revenue")
the error message is #VALUE# which it cant extract the info
when i visit wall street journal to manually extract the data,
the website gives me this error
HTTP Status 404 - /jsp/utils/page_error.jsp
type Status report

message /jsp/utils/page_error.jsp

description The requested resource (/jsp/utils/page_error.jsp) is
not available.
Apache Tomcat/5.5.20thanks

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

1d

Re: problem with wall street journal

Sat Sep 28, 2013 11:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yeah. That web page no longer exists.

I'm getting a lot of missing pages from their web site right now. Probably
a temporary glitch.

On Sat, Sep 28, 2013 at 10:15 AM, <weekeewawa@yahoo.com> wrote:

>
> =RCHGetTableCell("
> http://quotes.wsj.com/IBM/financials/annual/income-statement
> ",3,"Sales/Revenue")
>
> the error message is #VALUE# which it cant extract the info
>
> when i visit wall street journal to manually extract the data, the website
> gives me this error
>
> HTTP Status 404 - /jsp/utils/page_error.jsp
> ------------------------------
>
> *type* Status report
>
> *message* */jsp/utils/page_error.jsp*
>
> *description* *The requested resource (/jsp/utils/page_error.jsp) is not
> available.*
> ------------------------------
> Apache Tomcat/5.5.20
>

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

2a

Re: Yahoo codes

Sat Sep 28, 2013 6:48 am (PDT) . Posted by:

mikemcq802

Nasdaq is a great site for looking up dividend related dates.
Ex-Div, Announcement, Payment are all there - the next one and
past ones. Example for next or most recent ex-div for IBM:

=DATEVALUE(RCHGetTableCell("http://www.nasdaq.com/symbol/IBM/divi\
dend-history",1,"dividendhistoryGrid",,,,2))

Same, but it's Payment date (note just change the 1 to a 6 for
the 6th column):

=DATEVALUE(RCHGetTableCell("http://www.nasdaq.com/symbol/IBM/divi\
dend-history",6,"dividendhistoryGrid",,,,2))

I lookup next earnings date on WallStreetJournal:

=smfGetTagContent("http://quotes.wsj.com/IBM/financials","span",1\
,">Next Earnings Report")

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

I used the smfGetTagContent() formula to pull Ex-Dividend Date
from MarketWatch. Here's that formula:

=smfGetTagContent("http://www.marketwatch.com/investing/Stock/GOO\
G","p",1,"Ex dividend date")

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

The documentation for the RCHGetYahooQuotes() function is in the
DOCUMENTATION folder in the FILES area of the group. It contains
a list of the Yahoo codes.

Unfortunately, neither "Next Earnings Date" nor "Ex-Dividend
Date" are things that Yahoo provides on their current quotes CSV
interface.

On Tue, Jun 25, 2013 at 5:25 AM, ssztaba <ssjurik@...
<mailto:ssjurik@...> > wrote:
I'm using =RCHGetYahooQuotes(B7:B207,C6:D6,,NOW()) as my array
formula.

In C6 I have 'n' and in D6 I have 'l1' which gets me the Name and
last price of the stock in Column A. I think the 'n' and 'l1'
are called the Yahoo codes.

I've looked in the Files section, but I am not finding, a list of
other available Yahoo codes. I'm specifically looking for the
Yahoo codes for 'Next Earnings Date" and for "Next Ex Date"

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

3a

Re: Stock & Commodity Futures

Sat Sep 28, 2013 12:30 pm (PDT) . Posted by:

"Michael Thomas" thomas91112

Thank you. Regarding "individual price" formulation, how could I retrieve High and Low prices for the day?

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, September 27, 2013 1:02 PM
Subject: Re: [smf_addin] Stock & Commodity Futures

Note -- the data is actually put onto the page by an external JavaScript, so it's from there that the data needs to be extracted.

To get an individual price:

=RCHGetTableCell("http://vfm.websol.barchart.com/default.php?&domain=vfm&display_ice=&tz=0&ed=0",5," as of ",">EURO FX")

To get the whole table:

=RCHGetHTMLTable("http://vfm.websol.barchart.com/default.php?&domain=vfm&display_ice=&tz=0&ed=0","",2,"",2)

On Fri, Sep 27, 2013 at 12:49 PM, Michael Thomas <thomas91112@yahoo.com> wrote:

>
>Let's use http://www.visionfinancialmarkets.com/futures/tools/quotes/
>

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

3b

Re: Stock & Commodity Futures

Sat Sep 28, 2013 1:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just change the "5" in that first formula. Check the documentation for the
function to see what the various parameters do.

On Sat, Sep 28, 2013 at 12:30 PM, Michael Thomas <thomas91112@yahoo.com>wrote:

>
> Thank you. Regarding "individual price" formulation, how could I retrieve
> High and Low prices for the day?
>
> ------------------------------
> *From:* Randy Harmelink <rharmelink@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Friday, September 27, 2013 1:02 PM
> *Subject:* Re: [smf_addin] Stock & Commodity Futures
>
>
> Note -- the data is actually put onto the page by an external JavaScript,
> so it's from there that the data needs to be extracted.
>
> To get an individual price:
>
> =RCHGetTableCell("
> http://vfm.websol.barchart.com/default.php?&domain=vfm&display_ice=&tz=0&ed=0",5,"
> as of ",">EURO FX")
>

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

3c

Re: Stock & Commodity Futures

Sat Sep 28, 2013 1:49 pm (PDT) . Posted by:

"Michael Thomas" thomas91112

Did both things recommended. Put in "6", takes me to Change, however, "7" skips Open, High and Low and goes to Time.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, September 28, 2013 1:43 PM
Subject: Re: [smf_addin] Stock & Commodity Futures

Just change the "5" in that first formula. Check the documentation for the function to see what the various parameters do.

On Sat, Sep 28, 2013 at 12:30 PM, Michael Thomas <thomas91112@yahoo.com> wrote:

>
>Thank you. Regarding "individual price" formulation, how could I retrieve High and Low prices for the day?
>
>
>
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, September 27, 2013 1:02 PM
>Subject: Re: [smf_addin] Stock & Commodity Futures
>
>
>
>
>Note -- the data is actually put onto the page by an external JavaScript, so it's from there that the data needs to be extracted.
>
>
>To get an individual price:
>
>=RCHGetTableCell("http://vfm.websol.barchart.com/default.php?&domain=vfm&display_ice=&tz=0&ed=0",5," as of ",">EURO FX")
>

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

3d

Re: Stock & Commodity Futures

Sat Sep 28, 2013 2:56 pm (PDT) . Posted by:

"Michael Thomas" thomas91112

Have it working after playing around with the numbers (they were non-sequential), however, two of the data elements listed aat http://www.barchart.com/commodityfutures/All?mode=I&view= for the U.S. Dollar Index and Russell 2000 Mini do not appear in the extract file at

http://vfm.websol.barchart.com/default.php?&domain=vfm , any idea why?

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, September 28, 2013 1:43 PM
Subject: Re: [smf_addin] Stock & Commodity Futures

Just change the "5" in that first formula. Check the documentation for the function to see what the various parameters do.

On Sat, Sep 28, 2013 at 12:30 PM, Michael Thomas <thomas91112@yahoo.com> wrote:

>
>Thank you. Regarding "individual price" formulation, how could I retrieve High and Low prices for the day?
>
>
>
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, September 27, 2013 1:02 PM
>Subject: Re: [smf_addin] Stock & Commodity Futures
>
>
>
>
>Note -- the data is actually put onto the page by an external JavaScript, so it's from there that the data needs to be extracted.
>
>
>To get an individual price:
>
>=RCHGetTableCell("http://vfm.websol.barchart.com/default.php?&domain=vfm&display_ice=&tz=0&ed=0",5," as of ",">EURO FX")
>

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

3e

Re: Stock & Commodity Futures

Sat Sep 28, 2013 3:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not a clue. Maybe because http://www.visionfinancialmarkets.com didn't
license them or request them?

Any reason why they SHOULD match?

On Sat, Sep 28, 2013 at 2:56 PM, Michael Thomas <thomas91112@yahoo.com>wrote:

>
> Have it working after playing around with the numbers (they were
> non-sequential), however, two of the data elements listed aat
> http://www.barchart.com/commodityfutures/All?mode=I&view= for the U.S.
> Dollar Index and Russell 2000 Mini do not appear in the extract file at
> http://vfm.websol.barchart.com/default.php?&domain=vfm , any idea why?
>
>

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

3f

Re: Stock & Commodity Futures

Sat Sep 28, 2013 3:14 pm (PDT) . Posted by:

"Michael Thomas" thomas91112

Sorry, but I am not talking about the visionfinancialmarkets.com website, but rather barchart.com. Barchart displays the values for viewing but apparently not in the extract/download file.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, September 28, 2013 3:08 PM
Subject: Re: [smf_addin] Stock & Commodity Futures

Not a clue. Maybe because http://www.visionfinancialmarkets.com didn't license them or request them?

Any reason why they SHOULD match?

On Sat, Sep 28, 2013 at 2:56 PM, Michael Thomas <thomas91112@yahoo.com> wrote:

>
>Have it working after playing around with the numbers (they were non-sequential), however, two of the data elements listed aat http://www.barchart.com/commodityfutures/All?mode=I&view= for the U.S. Dollar Index and Russell 2000 Mini do not appear in the extract file at
>
>http://vfm.websol.barchart.com/default.php?&domain=vfm , any idea why?
>
>

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

3g

Re: Stock & Commodity Futures

Sat Sep 28, 2013 4:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

"U.S. Dollar Index" and "Russell 2000 Mini" are in the CSV file from
barchart.com...

=smfGetCSVFile("
http://www.barchart.com/export.php?mode=I&symbols=DX*0,B6*0,D6*0,J6*0,S6*0,E6*0,A6*0,M6*0,N6*0,CL*0,HO*0,RB*0,NG*0,CB*0,ZK*0,ZB*0,UD*0,ZN*0,ZF*0,ZT*0,ZQ*0,GE*0,ZW*0,ZC*0,ZS*0,ZM*0,ZL*0,ZO*0,ZR*0,KE*0,MW*0,RS*0,ES*0,NQ*0,YM*0,RJ*0,EW*0,SP*0,ND*0,DJ*0,
"&"VI*0,LE*0,GF*0,HE*0,DL*0,GC*0,SI*0,HG*0,PL*0,PA*0,YG*0,YI*0,CT*0,OJ*0,KC*0,SB*0,CC*0,SD*0,KT*0,KA*0,CJ*0,KG*0,LS*0&fields=
fp.name
,futures.contract,last,change,open,high,low,displaytime&title=Futures+Prices&extension=.csv")

It looks like you could just pick up the items you want:

=smfGetCSVFile("
http://www.barchart.com/export.php?mode=I&symbols=DX*0,B6*0,D6*0,J6*0,S6*0,E6*0,A6*0,M6*0,N6*0&fields=fp.name,futures.contract,last,change,open,high,low,displaytime&title=Futures+Prices&extension=.csv
")

On Sat, Sep 28, 2013 at 3:14 PM, Michael Thomas <thomas91112@yahoo.com>wrote:

>
>
> Sorry, but I am not talking about the visionfinancialmarkets.com website,
> but rather barchart.com. Barchart displays the values for viewing but
> apparently not in the extract/download file.
>

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

3h

Re: Stock & Commodity Futures

Sat Sep 28, 2013 4:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I see these as documented fields that can be put onto the CSV file:

fp.name
futures.contract
last
change
open
high
low
displaytime
opinion.op
relstr_20d
hisvol_20d
avgvol_20d
inf_52w_low_price
inf_52w_high_price
weighted_alpha
pctchg_ytd
inf_20d_ago_percent
inf_65d_ago_percent
inf_260d_ago_percent

For example, this:

=smfGetCSVFile("
http://www.barchart.com/export.php?mode=I&symbols=DX*0,B6*0,D6*0,J6*0,S6*0,E6*0,A6*0,M6*0,N6*0&fields=fp.name,last,opinion.op&title=Futures+Prices&extension=.csv
")

...produces:

Futures Prices 09_28_2013 *NAME* *LAST* *TODAY'S OPINION* U.S. Dollar
Index 80.377 88% Sell British Pound 1.6125 96% Buy Canadian Dollar 0.9689 40%
Buy Japanese Yen 1.0178 32% Buy Swiss Franc 1.1047 96% Buy Euro FX
1.3521 96%
Buy Australian Dollar 0.9272 24% Buy Mexican Peso 0.07545 72% Sell New
Zealand Dollar 0.8233 72% Buy

On Sat, Sep 28, 2013 at 4:46 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> "U.S. Dollar Index" and "Russell 2000 Mini" are in the CSV file from
> barchart.com...
>
> =smfGetCSVFile("
> http://www.barchart.com/export.php?mode=I&symbols=DX*0,B6*0,D6*0,J6*0,S6*0,E6*0,A6*0,M6*0,N6*0,CL*0,HO*0,RB*0,NG*0,CB*0,ZK*0,ZB*0,UD*0,ZN*0,ZF*0,ZT*0,ZQ*0,GE*0,ZW*0,ZC*0,ZS*0,ZM*0,ZL*0,ZO*0,ZR*0,KE*0,MW*0,RS*0,ES*0,NQ*0,YM*0,RJ*0,EW*0,SP*0,ND*0,DJ*0,
> "&"VI*0,LE*0,GF*0,HE*0,DL*0,GC*0,SI*0,HG*0,PL*0,PA*0,YG*0,YI*0,CT*0,OJ*0,KC*0,SB*0,CC*0,SD*0,KT*0,KA*0,CJ*0,KG*0,LS*0&fields=
> fp.name
> ,futures.contract,last,change,open,high,low,displaytime&title=Futures+Prices&extension=.csv")
>
> It looks like you could just pick up the items you want:
>
> =smfGetCSVFile("
> http://www.barchart.com/export.php?mode=I&symbols=DX*0,B6*0,D6*0,J6*0,S6*0,E6*0,A6*0,M6*0,N6*0&fields=fp.name,futures.contract,last,change,open,high,low,displaytime&title=Futures+Prices&extension=.csv
> ")
>

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

3i

Re: Stock & Commodity Futures

Sat Sep 28, 2013 5:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can also get the other contract months. For example, this:

=smfGetCSVFile("
http://www.barchart.com/export.php?mode=I&symbols=DX*1,DX*2,DX*3,DX*4&fields=fp.name,futures.contract,last,opinion.op&title=Futures+Prices&extension=.csv
")

...gets this:

Futures Prices 09_28_2013 *NAME* *CONTRACT* *LAST* *TODAY'S
OPINION* U.S.
Dollar Index DXZ13 (Dec '13) 80.377 88% Sell U.S. Dollar Index DXH14 (Mar
'14) 80.602 96% Sell U.S. Dollar Index DXM14 (Jun '14) 80.817 N/A U.S.
Dollar Index DXU14 (Sep '14) 81.022 N/A

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

4 Morningstar Financials

Sat Sep 28, 2013 2:11 pm (PDT) . Posted by:

petekoch

I uploaded Morningstar_Financials_Example.xlsx to the members
file area. This template retrieves the Key Ratios as well as the
three financial statements in one worksheet. If you have a
Morningstar subscription, it's a great substitute for AdvFN and
downloads much faster. BTW, I hardcoded the URL to retrieve
annual data; I'll have to play with some quarterly when I get the
chance/need.