6 New Messages
Digest #2791
Messages
Sat Sep 28, 2013 5:30 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
If I enter the smf script below, receive back
"<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">"
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, September 28, 2013 4:59 PM
Subject: Re: [smf_addin] Stock & Commodity Futures
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")
>
"<!DOCTYPE html PUBLIC "-//W3C/
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, September 28, 2013 4:59 PM
Subject: Re: [smf_addin] Stock & Commodity Futures
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_
inf_52w_high_
weighted_alpha
pctchg_ytd
inf_20d_ago_
inf_65d_ago_
inf_260d_ago_
For example, this:
=smfGetCSVFile(
...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.
"U.S. Dollar Index" and "Russell 2000 Mini" are in the CSV file from barchart.com.
>
>=smfGetCSVFile(
>
>
>It looks like you could just pick up the items you want:
>
>=smfGetCSVFile(
>
Sat Sep 28, 2013 5:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Maybe the CSV file is only available if you're a registered member and
logged in...
If you go here:
http://www.barchart.com/commodityfutures/All
...do you have an export button (a little EXCEL icon) just to the right of
the "FlipCharts" link, at the top of the table? If so, what happens if you
click on it?
On Sat, Sep 28, 2013 at 5:30 PM, Michael Thomas <thomas91112@yahoo.com>wrote:
>
> If I enter the smf script below, receive back
> "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
> http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">"
>
logged in...
If you go here:
http://www.barchart
...do you have an export button (a little EXCEL icon) just to the right of
the "FlipCharts&qu
click on it?
On Sat, Sep 28, 2013 at 5:30 PM, Michael Thomas <thomas91112@
>
> If I enter the smf script below, receive back
> "<!DOCTYPE html PUBLIC "-//W3C/
> http://www.w3.
>
Sat Sep 28, 2013 6:36 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
Am registered with Barchart.com and logged in and it shows MyAccount as active; clicked on the Excel icon and it downloads all the screen data to Futures_Prices-09_28_2013; however, the smf script still gets the same error message.
Thanks
Mike
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, September 28, 2013 5:55 PM
Subject: Re: [smf_addin] Stock & Commodity Futures
Maybe the CSV file is only available if you're a registered member and logged in...
If you go here:
http://www.barchart.com/commodityfutures/All
...do you have an export button (a little EXCEL icon) just to the right of the "FlipCharts" link, at the top of the table? If so, what happens if you click on it?
On Sat, Sep 28, 2013 at 5:30 PM, Michael Thomas <thomas91112@yahoo.com> wrote:
>
>If I enter the smf script below, receive back
>"<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">"
>
Thanks
Mike
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, September 28, 2013 5:55 PM
Subject: Re: [smf_addin] Stock & Commodity Futures
Maybe the CSV file is only available if you're a registered member and logged in...
If you go here:
http://www.barchart
...do you have an export button (a little EXCEL icon) just to the right of the "FlipCharts&qu
On Sat, Sep 28, 2013 at 5:30 PM, Michael Thomas <thomas91112@
>
>If I enter the smf script below, receive back
>"<
>
Sat Sep 28, 2013 7:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you logged in with IE? Logging in with FireFox won't do the job.
Otherwise, I am at a loss as to why you get different results.
Hmmm. What do you get with:
=RCHGetWebData("
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
")
I get something like:
Futures Prices,09_28_2013
"NAME","CONTRACT","LAST","TODAY'S OPINION",
"U.S. Dollar Index","DXZ13 (Dec '13)", ...
On Sat, Sep 28, 2013 at 6:36 PM, Michael Thomas <thomas91112@yahoo.com>wrote:
>
> Am registered with Barchart.com and logged in and it shows MyAccount as
> active; clicked on the Excel icon and it downloads all the screen data to
> Futures_Prices-09_28_2013; however, the smf script still gets the same
> error message.
>
Otherwise, I am at a loss as to why you get different results.
Hmmm. What do you get with:
=RCHGetWebData(
http://www.barchart
")
I get something like:
Futures Prices,09_28_
"NAME"
"U.S. Dollar Index",
On Sat, Sep 28, 2013 at 6:36 PM, Michael Thomas <thomas91112@
>
> Am registered with Barchart.com and logged in and it shows MyAccount as
> active; clicked on the Excel icon and it downloads all the screen data to
> Futures_Prices-
> error message.
>
Sat Sep 28, 2013 5:58 pm (PDT) . Posted by:
ppasha1129
Hey everyone, I keep hearing there is a smffixlinks macro, can
someone advise me on how I can use this macro?
Thank you.
someone advise me on how I can use this macro?
Thank you.
Sat Sep 28, 2013 6:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just hit alt-F8 to open up the Macro dialog, type in the name, then click
the "Run" button.
I have it assigned to a button on my Quick Access Toolbar so it's easily
available.
On Sat, Sep 28, 2013 at 5:35 PM, <ppasha1129@yahoo.com> wrote:
>
> Hey everyone, I keep hearing there is a smffixlinks macro, can someone
> advise me on how I can use this macro?
>
the "Run" button.
I have it assigned to a button on my Quick Access Toolbar so it's easily
available.
On Sat, Sep 28, 2013 at 5:35 PM, <ppasha1129@yahoo.
>
> Hey everyone, I keep hearing there is a smffixlinks macro, can someone
> advise me on how I can use this macro?
>
Tidak ada komentar:
Posting Komentar