Minggu, 10 Juni 2012

[smf_addin] Digest Number 2242

Messages In This Digest (25 Messages)

1a.
implied volatility From: grabthecashanddash
1b.
Re: implied volatility From: Randy Harmelink
2a.
SCTR scores From: smithjhhic
2b.
Re: SCTR scores From: Randy Harmelink
2c.
Re: SCTR scores From: smithjhhic
2d.
Re: SCTR scores From: Randy Harmelink
2e.
Re: SCTR scores From: smithjhhic
2f.
Re: SCTR scores From: Randy Harmelink
2g.
Re: SCTR scores From: smithjhhic
2h.
Re: SCTR scores From: Randy Harmelink
3a.
Re: MSN data working? From: Kermit W. Prather
4a.
Re: New element file From: NicholasDavid
4b.
Re: New element file From: Randy Harmelink
4c.
Re: New element file From: wpclarkiv
4d.
Re: New element file From: Randy Harmelink
4e.
Re: New element file From: Ashish Mukerji
4f.
Re: New element file From: wpclarkiv
4g.
Re: New element file From: wpclarkiv
4h.
Re: New element file From: ufdn16
4i.
Re: New element file From: Randy Harmelink
4j.
Re: New element file From: Randy Harmelink
4k.
Re: New element file From: wpclarkiv
4l.
Re: New element file From: Randy Harmelink
5a.
ADVFN Element Numbers From: Ron Spruell
5b.
Re: ADVFN Element Numbers From: Randy Harmelink

Messages

1a.

implied volatility

Posted by: "grabthecashanddash" drjay001@gmail.com   grabthecashanddash

Sun Jun 10, 2012 5:54 am (PDT)



Randy,
Is there a source for downloading current and past implied volatility of stocks?
If so, can your addins support this?

Thanx.
Jay

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

Re: implied volatility

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

Sun Jun 10, 2012 8:20 am (PDT)



The beta version of the add-in in the "Works In Progress" folder can get
that from 888options.com.

On Sun, Jun 10, 2012 at 5:51 AM, grabthecashanddash <drjay001@gmail.com>wrote:

> Is there a source for downloading current and past implied volatility of
> stocks?
> If so, can your addins support this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

SCTR scores

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Sun Jun 10, 2012 6:33 am (PDT)



Hello,
I was wondering if anyone is using SCTR scores on site below. It splits stock population into separate large, mid and small cap pages. Is there a way to combine the 3 caps into one formula? Eitherway, I'm having difficulty creating the formula for aapl on the link below. Any help would be appreciated.
v/r,
Jeff

http://stockcharts.com/freecharts/sctr.html?&V=L&I=N

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

Re: SCTR scores

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

Sun Jun 10, 2012 8:27 am (PDT)



Sorry, but the web page is generated dynamically, so there is nothing in
the source code of the web page for the add-in to extract as data.

On Sun, Jun 10, 2012 at 6:33 AM, smithjhhic <smithjhhic@yahoo.com> wrote:

> I was wondering if anyone is using SCTR scores on site below. It splits
> stock population into separate large, mid and small cap pages. Is there a
> way to combine the 3 caps into one formula? Eitherway, I'm having
> difficulty creating the formula for aapl on the link below. Any help would
> be appreciated.
> v/r,
> Jeff
>
> http://stockcharts.com/freecharts/sctr.html?&V=L&I=N
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2c.

Re: SCTR scores

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Sun Jun 10, 2012 11:41 am (PDT)



Randy,
Thank. Thanks. Would it work if I saved the page to my computer with location
file:///C:/Data/Stocks/SCTR_S&P500.htm

Using the code below would be looking for symbol EXPE and extract SCTR = 99.9 and Change = 0.0. I appreciate your help.

</tr><tr><td class="first"><span class="minichart-links"><a href="http://stockcharts.com/h-sc/ui?s=EXPE"><img src="./StockCharts Technical Rankings - Free Charts - StockCharts.com_files/ico_candle_on.gif" alt="SharpChart EXPE"></a><a href="http://stockcharts.com/freecharts/gallery.html?EXPE"><img src="./StockCharts Technical Rankings - Free Charts - StockCharts.com_files/ico_trendline_on.gif" alt="Gallery EXPE"></a><a href="http://stockcharts.com/def/servlet/SC.pnf?c=EXPE,P"><img src="./StockCharts Technical Rankings - Free Charts - StockCharts.com_files/ico_pnf_on.gif" alt="P&amp;F EXPE"></a></span></td><td class="SCTR-close">EXPE</td><td class="SCTR-sym"><a href="http://stockcharts.com/h-sc/ui?s=EXPE">Expedia, Inc</a></td><td class="SCTR-sector">Consumer Discretionary</td><td class="SCTR-industry">Travel &amp; Tourism</td><td class="SCTR">99.9</td><td class="SCTR changeup">0.0</td></tr><tr><td class="first"><span class="minichart-links"><a href="http://stockcharts.com/h-sc/ui?s=DF"><img src="./StockCharts Technical Rankings - Free Charts - StockCharts.com_files/ico_candle_on.gif" alt="SharpChart DF"></a><a

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, but the web page is generated dynamically, so there is nothing in
> the source code of the web page for the add-in to extract as data.
>
> On Sun, Jun 10, 2012 at 6:33 AM, smithjhhic <smithjhhic@...> wrote:
>
> > I was wondering if anyone is using SCTR scores on site below. It splits
> > stock population into separate large, mid and small cap pages. Is there a
> > way to combine the 3 caps into one formula? Eitherway, I'm having
> > difficulty creating the formula for aapl on the link below. Any help would
> > be appreciated.
> > v/r,
> > Jeff
> >
> > http://stockcharts.com/freecharts/sctr.html?&V=L&I=N
> >
>

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

Re: SCTR scores

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

Sun Jun 10, 2012 12:03 pm (PDT)



Interesting idea -- appears to work here, when I saved it:

=RCHGetTableCell("file:///C:/Users/Randy/Documents/Temp/sctr.html",4,">EXPE")

You have me wondering if the add-in can automate the saving so that
dynamically generated pages can be accessed easily.

On Sun, Jun 10, 2012 at 11:41 AM, smithjhhic <smithjhhic@yahoo.com> wrote:

> Would it work if I saved the page to my computer with location
> file:///C:/Data/Stocks/SCTR_S&P500.htm
>
> Using the code below would be looking for symbol EXPE and extract SCTR =
> 99.9 and Change = 0.0. I appreciate your help.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2e.

Re: SCTR scores

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Sun Jun 10, 2012 1:12 pm (PDT)



Randy,
Thanks for your help. I do find a couple of problems with my data set. The data for AT&T "T" comes over as "Sector" vs the rating. Also, expected to get an error for my "DG" symbol, but gives me a rating for symbol "DGX".
v/r,
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Interesting idea -- appears to work here, when I saved it:
>
> =RCHGetTableCell("file:///C:/Users/Randy/Documents/Temp/sctr.html",4,">EXPE")
>
> You have me wondering if the add-in can automate the saving so that
> dynamically generated pages can be accessed easily.
>
> On Sun, Jun 10, 2012 at 11:41 AM, smithjhhic <smithjhhic@...> wrote:
>
> > Would it work if I saved the page to my computer with location
> > file:///C:/Data/Stocks/SCTR_S&P500.htm
> >
> > Using the code below would be looking for symbol EXPE and extract SCTR =
> > 99.9 and Change = 0.0. I appreciate your help.
> >
>

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

Re: SCTR scores

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

Sun Jun 10, 2012 1:50 pm (PDT)



A different search string would make them more unique. For example:

=RCHGetTableCell("file:///C:/Users/Randy/Documents/Temp/sctr.html",5,"?c=T,")

On Sun, Jun 10, 2012 at 1:09 PM, smithjhhic <smithjhhic@yahoo.com> wrote:

> Randy,
> Thanks for your help. I do find a couple of problems with my data set.
> The data for AT&T "T" comes over as "Sector" vs the rating. Also,
> expected to get an error for my "DG" symbol, but gives me a rating for
> symbol "DGX".
> v/r,
> Jeff
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2g.

Re: SCTR scores

Posted by: "smithjhhic" smithjhhic@yahoo.com   smithjhhic

Sun Jun 10, 2012 3:26 pm (PDT)



Randy,
Thanks, I am having trouble replacing symbol "T" with obtaining symbol from cell C3 similar to my other formulas. I must have a typo, but can't seem to find it.
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> A different search string would make them more unique. For example:
>
> =RCHGetTableCell("file:///C:/Users/Randy/Documents/Temp/sctr.html",5,"?c=T,")
>
> On Sun, Jun 10, 2012 at 1:09 PM, smithjhhic <smithjhhic@...> wrote:
>
> > Randy,
> > Thanks for your help. I do find a couple of problems with my data set.
> > The data for AT&T "T" comes over as "Sector" vs the rating. Also,
> > expected to get an error for my "DG" symbol, but gives me a rating for
> > symbol "DGX".
> > v/r,
> > Jeff
> >
>

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

Re: SCTR scores

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

Sun Jun 10, 2012 4:06 pm (PDT)



It's hard for me to see what's wrong without you showing the formula? :)

This works for me:

=RCHGetTableCell("file:///C:/Users/Randy/Documents/Temp/sctr.html",5,"?c="&C3&",")

On Sun, Jun 10, 2012 at 3:24 PM, smithjhhic <smithjhhic@yahoo.com> wrote:

>
> Thanks, I am having trouble replacing symbol "T" with obtaining symbol
> from cell C3 similar to my other formulas. I must have a typo, but can't
> seem to find it.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
3a.

Re: MSN data working?

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Sun Jun 10, 2012 6:36 am (PDT)



I downloaded the file and appreciate your efforts.

However, I have a request of you and everyone that uploads files. Can you
please include an instruction page with a short explanation of the purpose
of the spreadsheet and how to best use it.

Sorry, if this seems to sound ungrateful. It is not meant to be but rather a
request to assist those downloading the spreadsheet.

This one is fairly straight forward but short description would be helpful
to those of us not familiar with the subject.

Thanks again,
Kermit

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of supernaut570
Sent: Saturday, June 09, 2012 4:39 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: MSN data working?

Thanks so much. I used to be a big fan of the Motley Fool's Foolish 8
Scorecard available on Quicken.com, until they took it down about 5 years
ago (maybe longer now...). Anyway, I tried to re-create it using your
add-in. It's a big time saver for my screening process.

I uploaded it to the group. Maybe someone will have suggestions for
improving it - and hopefully someone else will find it as useful a screening
tool as I have.

http://finance.groups.yahoo.com/group/smf_addin/message/18930

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You guess is right -- see:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> On Sat, Jun 9, 2012 at 7:21 AM, supernaut570 <steve@...> wrote:
>
> > Hi Randy. I just unearthed an old file that uses the SMF addin (all
> > or almost all data drawn from MSN) and it wasn't displaying any data
> > - not even simple stuff like last price (element 25). So I
> > downloaded and installed the latest addin version, but with the same
results - nothing.
> >
> > I'm wondering if maybe MSN changed their page since the last
> > definitions document? Any ideas? Is it working for others?
> >
> > Thanks for any help you can offer. Much appreciated.
> >
>

------------------------------------

Yahoo! Groups Links

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

Re: New element file

Posted by: "NicholasDavid" nicholasdavid@comcast.net   davidnicholas738

Sun Jun 10, 2012 7:58 am (PDT)



"VERSION" returns: Stock Market Functions add-in ,Version 2.1.2012.04.07(C:\Program Files\smf Add-in ; 1 )

"MMM,25" returns: error

=smfGetAParms(25) returns : MSN;Last Price;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH-1&AIE=1&AIR=1& ..........

Hope this leads us toward a solution for me.
Thank you, so much. David

----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Saturday, June 9, 2012 3:40:41 PM
Subject: Re: [smf_addin] New element file

What do you get with:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",25)
=smfGetAParms(25)

On Sat, Jun 9, 2012 at 1:36 PM, ufdn16 < ufdn16@yahoo.com > wrote:

Randy , I still get an error when I use the formula =rchgetelementnumber(ticker1,27)

I followed your instructions.

I deleted everything in my smf_addin directory then went to the group website in the in-process file and retrieved the new smf_add in file.
I chose the xls file not the text file which you directed me to.

I unzipped the file and it was placed in my smf_addin directory.

I find that all my other element numbers in my worksheet are being updated. But, I still can't get 27,28,29 or 25

I at a loss.

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

Re: New element file

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

Sun Jun 10, 2012 8:30 am (PDT)



This indicates you do not have the updated element definitions. It should
look like this:

MSN;Last Price;
http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;LAST
PRICE; ; ;0;0;0;0

Make sure you did replace the smf-elements-1.txt file, in the folder where
the add-in manager is pointing to the add-in (some people have the add-in
installed in multiple locations).

On Sun, Jun 10, 2012 at 7:58 AM, NicholasDavid <nicholasdavid@comcast.net>wrote:

> =smfGetAParms(25) returns : MSN;Last Price;
> http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH-1&AIE=1&AIR=1&..........
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4c.

Re: New element file

Posted by: "wpclarkiv" wpclarkiv@hotmail.com   wpclarkiv

Sun Jun 10, 2012 8:31 am (PDT)



I am having the same trouble with 99.9% of my "MSN" element numbers.

Please Help.

--- In smf_addin@yahoogroups.com, NicholasDavid <nicholasdavid@...> wrote:
>
> "VERSION" returns: Stock Market Functions add-in ,Version 2.1.2012.04.07(C:\Program Files\smf Add-in ; 1 )
>
> "MMM,25" returns: error
>
> =smfGetAParms(25) returns : MSN;Last Price;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH-1&AIE=1&AIR=1& ..........
>
>
> Hope this leads us toward a solution for me.
> Thank you, so much. David
>
>
>
> ----- Original Message -----
> From: "Randy Harmelink" <rharmelink@...>
> To: "smf addin" <smf_addin@yahoogroups.com>
> Sent: Saturday, June 9, 2012 3:40:41 PM
> Subject: Re: [smf_addin] New element file
>
>
>
>
>
>
> What do you get with:
>
> =RCHGetElementNumber("Version")
> =RCHGetElementNumber("MMM",25)
> =smfGetAParms(25)
>
>
> On Sat, Jun 9, 2012 at 1:36 PM, ufdn16 < ufdn16@... > wrote:
>
>
> Randy , I still get an error when I use the formula =rchgetelementnumber(ticker1,27)
>
> I followed your instructions.
>
> I deleted everything in my smf_addin directory then went to the group website in the in-process file and retrieved the new smf_add in file.
> I chose the xls file not the text file which you directed me to.
>
> I unzipped the file and it was placed in my smf_addin directory.
>
> I find that all my other element numbers in my worksheet are being updated. But, I still can't get 27,28,29 or 25
>
> I at a loss.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4d.

Re: New element file

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

Sun Jun 10, 2012 8:35 am (PDT)



See: http://finance.groups.yahoo.com/group/smf_addin/message/18529

On Sun, Jun 10, 2012 at 8:19 AM, wpclarkiv <wpclarkiv@hotmail.com> wrote:

> I am having the same trouble with 99.9% of my "MSN" element numbers.
>
> Please Help.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4e.

Re: New element file

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Sun Jun 10, 2012 9:04 am (PDT)



I am not an expert on Excel but here is the way I seem to have gotten over the same problem ... when I overwrote the smf-elements-1 txt file that showed up thru zip file with the same file from the work-in-progress file (smf-elements-1 is separately included) then the problem that we faced with element 25 etc went away ....  hope this helps ...

 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Sunday, June 10, 2012 11:30 AM
>Subject: Re: [smf_addin] New element file
>
>
> 
>This indicates you do not have the updated element definitions. It should look like this:
>
>MSN;Last Price;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;LAST PRICE; ; ;0;0;0;0
>
>Make sure you did replace the smf-elements-1.txt file, in the folder where the add-in manager is pointing to the add-in (some people have the add-in installed in multiple locations).
>
>
>On Sun, Jun 10, 2012 at 7:58 AM, NicholasDavid <nicholasdavid@comcast.net> wrote:
>
>=smfGetAParms(25) returns : MSN;Last Price;http://moneycentral.msn.com/investor/research/sreport.asp?CR=1&AF=1&IH-1&AIE=1&AIR=1& ..........
>>
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4f.

Re: New element file

Posted by: "wpclarkiv" wpclarkiv@hotmail.com   wpclarkiv

Sun Jun 10, 2012 9:15 am (PDT)



THANK YOU, so much!!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> On Sun, Jun 10, 2012 at 8:19 AM, wpclarkiv <wpclarkiv@...> wrote:
>
> > I am having the same trouble with 99.9% of my "MSN" element numbers.
> >
> > Please Help.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4g.

Re: New element file

Posted by: "wpclarkiv" wpclarkiv@hotmail.com   wpclarkiv

Sun Jun 10, 2012 9:52 am (PDT)



I am sorry to keep bothering you; are there any other new txt files I need to copy?

I am using the "Stock Market Functions add-in, Version 2.1.2012.04.07 (C:\Program Files\SMF Add-In; 1)" download and the txt files which came with it.

Thanks again.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> On Sun, Jun 10, 2012 at 8:19 AM, wpclarkiv <wpclarkiv@...> wrote:
>
> > I am having the same trouble with 99.9% of my "MSN" element numbers.
> >
> > Please Help.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4h.

Re: New element file

Posted by: "ufdn16" ufdn16@yahoo.com   ufdn16

Sun Jun 10, 2012 11:13 am (PDT)



Did you get my response?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What do you get with:
>
> =RCHGetElementNumber("Version")
> =RCHGetElementNumber("MMM",25)
> =smfGetAParms(25)
>
> On Sat, Jun 9, 2012 at 1:36 PM, ufdn16 <ufdn16@...> wrote:
>
> > Randy , I still get an error when I use the formula
> > =rchgetelementnumber(ticker1,27)
> >
> > I followed your instructions.
> >
> > I deleted everything in my smf_addin directory then went to the group
> > website in the in-process file and retrieved the new smf_add in file.
> > I chose the xls file not the text file which you directed me to.
> >
> > I unzipped the file and it was placed in my smf_addin directory.
> >
> > I find that all my other element numbers in my worksheet are being
> > updated. But, I still can't get 27,28,29 or 25
> >
> > I at a loss.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4i.

Re: New element file

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

Sun Jun 10, 2012 11:57 am (PDT)



Yes, you need the new smf-elements-1.txt file I pointed you to. It's an
update to what was distributed with the ZIP file.

On Sun, Jun 10, 2012 at 9:52 AM, wpclarkiv <wpclarkiv@hotmail.com> wrote:

> I am sorry to keep bothering you; are there any other new txt files I need
> to copy?
>
> I am using the "Stock Market Functions add-in, Version 2.1.2012.04.07
> (C:\Program Files\SMF Add-In; 1)" download and the txt files which came
> with it.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4j.

Re: New element file

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

Sun Jun 10, 2012 11:58 am (PDT)



Yes, and I said you still have the old element definitions being loaded. So
you still need to replace the smf-elements-1.txt file with the newly
updated one from the "Works in Progress" folder.

On Sun, Jun 10, 2012 at 11:12 AM, ufdn16 <ufdn16@yahoo.com> wrote:

> Did you get my response?
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > What do you get with:
> >
> > =RCHGetElementNumber("Version")
> > =RCHGetElementNumber("MMM",25)
> > =smfGetAParms(25)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4k.

Re: New element file

Posted by: "wpclarkiv" wpclarkiv@hotmail.com   wpclarkiv

Sun Jun 10, 2012 12:08 pm (PDT)



I got that one, thank you so much. Are there others?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Yes, you need the new smf-elements-1.txt file I pointed you to. It's an
> update to what was distributed with the ZIP file.
>
> On Sun, Jun 10, 2012 at 9:52 AM, wpclarkiv <wpclarkiv@...> wrote:
>
> > I am sorry to keep bothering you; are there any other new txt files I need
> > to copy?
> >
> > I am using the "Stock Market Functions add-in, Version 2.1.2012.04.07
> > (C:\Program Files\SMF Add-In; 1)" download and the txt files which came
> > with it.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
4l.

Re: New element file

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

Sun Jun 10, 2012 12:12 pm (PDT)



Not at this time. The "works in progress" folder is where I post interim
items before they get packaged into the next official release. I announced
that file at the time it was uploaded.

There is also a beta version of the add-in there. You can review the
documentation of updates and new functions in that folder to see if they
might be of value to you. For example, I've had recent requests to be able
to get greeks and volatility info options. The beta version of the add-in
has new functionality to allow it to get that data from 888options.com.

On Sun, Jun 10, 2012 at 12:08 PM, wpclarkiv <wpclarkiv@hotmail.com> wrote:

> I got that one, thank you so much. Are there others?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (14)
5a.

ADVFN Element Numbers

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Sun Jun 10, 2012 3:10 pm (PDT)



Randy -

Do you have Element Numbers for Company Data Tab on ADVFN?  I searched the .txt files and could not find them.

http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14

I want to pull Free Cash Flow pS and Dividend pS. 

I can pull these with RCHGetTableCell.

=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14",1,"Yesterday's Close","Free Cash Flow pS")
=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14",1,"Yesterday's
Close","Dividend pS")

Do you have any idea why this doesn't work with RAVN, CTWS, CTAS, and many more?

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

Re: ADVFN Element Numbers

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

Sun Jun 10, 2012 4:11 pm (PDT)



Elements were only set up for the quarterly and annual financials.

These work fine for me for RAVN:

=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=RAVN",1,">Dividend
ps")
=RCHGetTableCell("http://www.advfn.com/p.php?pid=financials&symbol=RAVN",1,">Free
Cash Flow ps")

On Sun, Jun 10, 2012 at 3:10 PM, Ron Spruell <hashky@yahoo.com> wrote:

>
> Do you have Element Numbers for Company Data Tab on ADVFN? I searched the
> .txt files and could not find them.
>
>
> http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14
>
> I want to pull Free Cash Flow pS and Dividend pS.
>
> I can pull these with RCHGetTableCell.
>
> =RCHGetTableCell("
> http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14",1,"Yesterday's
> Close","Free Cash Flow pS")
>
> =RCHGetTableCell("
> http://www.advfn.com/p.php?pid=financials&btn=company_data&mode=annual_reports&symbol=NYSE%3AMMM&start_date=14",1,"Yesterday's
> Close","Dividend pS")
>
> Do you have any idea why this doesn't work with RAVN, CTWS, CTAS, and many
> more?
>
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.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Odd News

You won't believe

it, but it's true

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 16.11

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)