15 New Messages
Digest #2302
2c
Re: solution for getting futures option quotes? like from OptionsXpr by "Randy Harmelink" rharmelink
3b
Re: Fetching Data from below the field name and not right to it Rchg by "Randy Harmelink" rharmelink
4c
MSN spreadsheet & DCF works after rebotting my Vista 64 bit system. by "Kermit W. Prather" kermitpra
Messages
Fri Aug 3, 2012 6:13 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Thanks for the response. But I don't use DCF I was just testing to see what was in it.
Can't waste any more time on it. I find it odd the submitter has yet to response to my posting. Another reason to move on.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
Sent: Thursday, August 02, 2012 8:00 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: DCF
Kermit -
You might try downloading again. Bruce has a revised version, and is working on a newer version. It should be out in a couple of days.
Maybe Randy can give some pointers.
_____
From: Kermit W. Prather <kermitp@tampabay.rr.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, August 2, 2012 3:55 PM
Subject: RE: [smf_addin] Re: DCF
I have the latest SMF Addin 7-12-12 version. I'm am on excel 2007. And all links are fine I created a tag to correct the links on each spreadsheet I download. All others work just fine. On the DCF spreadsheet Nothing happens even when I force a recalculation.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
Sent: Thursday, August 02, 2012 10:19 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: DCF
Kermit -
I didn't have any problem with it - other than I know very little about DCF.
Did you update the links? Are you running Excel 2007 or 2010?
Ron Spruell
_____
From: Kermit W. Prather <kermitp@tampabay.rr.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, August 2, 2012 8:40 AM
Subject: RE: [smf_addin] Re: DCF
I downloaded your file and it does not work. The .XLSM implies there should be a macro but none is present.
I have my Excel trust settings to allow all macros.
When I change a symbol in column A nothing happens. Am I suppose to do something?
Columns A thru G contains the values below. What are the values in row 2?
Ticker
Price
DCF EPS
d1t1
l1
e
When I create a spreadsheet I always make a worksheet name "Instructions" where I explain what the spreadsheet does and how one should use it. The reason I do this isn't so much to provide others the instructions but for me when I visit it months later.
I'd love to see folks posting their work do the same. It should save lots of question and you may find it useful when you revisit your work.
Of course, not everyone has my bad memory.
Thanks for contributing your work. We do appreciate it.
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Bruce
Sent: Wednesday, August 01, 2012 10:16 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: DCF
Sorry, my mistake, I'll upload it again without the link.
Can't waste any more time on it. I find it odd the submitter has yet to response to my posting. Another reason to move on.
Kermit
From: smf_addin@yahoogrou
Sent: Thursday, August 02, 2012 8:00 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: DCF
Kermit -
You might try downloading again. Bruce has a revised version, and is working on a newer version. It should be out in a couple of days.
Maybe Randy can give some pointers.
_____
From: Kermit W. Prather <kermitp@tampabay.
To: smf_addin@yahoogrou
Sent: Thursday, August 2, 2012 3:55 PM
Subject: RE: [smf_addin] Re: DCF
I have the latest SMF Addin 7-12-12 version. I'm am on excel 2007. And all links are fine I created a tag to correct the links on each spreadsheet I download. All others work just fine. On the DCF spreadsheet Nothing happens even when I force a recalculation.
From: smf_addin@yahoogrou
Sent: Thursday, August 02, 2012 10:19 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: DCF
Kermit -
I didn't have any problem with it - other than I know very little about DCF.
Did you update the links? Are you running Excel 2007 or 2010?
Ron Spruell
_____
From: Kermit W. Prather <kermitp@tampabay.
To: smf_addin@yahoogrou
Sent: Thursday, August 2, 2012 8:40 AM
Subject: RE: [smf_addin] Re: DCF
I downloaded your file and it does not work. The .XLSM implies there should be a macro but none is present.
I have my Excel trust settings to allow all macros.
When I change a symbol in column A nothing happens. Am I suppose to do something?
Columns A thru G contains the values below. What are the values in row 2?
Ticker
Price
DCF EPS
d1t1
l1
e
When I create a spreadsheet I always make a worksheet name "Instructions" where I explain what the spreadsheet does and how one should use it. The reason I do this isn't so much to provide others the instructions but for me when I visit it months later.
I'd love to see folks posting their work do the same. It should save lots of question and you may find it useful when you revisit your work.
Of course, not everyone has my bad memory.
Thanks for contributing your work. We do appreciate it.
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Sent: Wednesday, August 01, 2012 10:16 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: DCF
Sorry, my mistake, I'll upload it again without the link.
Fri Aug 3, 2012 7:30 am (PDT) . Posted by:
"rr76012" rr76012
Hello Bruce,
Thank you for sharing your dcf spreadsheet template, nicely done fellow Texan..
It looks great...
rr76012
--- In smf_addin@yahoogroups.com , "Bruce" <bruce@...> wrote:
>
>
>
> Sorry, my mistake, I'll upload it again without the link.
>
> --- In smf_addin@yahoogroups.com , Taral Pandya <t.pandya2689@> wrote:
> >
> > Jason,
> >
> > I downloaded it. It's asking for a file called Stock Analysis 001.xlsm. Where do I get that file from?
> > -Taral
> >
> > On Jul 31, 2012, at 8:03 PM, "Bruce" <bruce@> wrote:
> >
> > >
> > >
> > > Jason, I'm so glad you posted this request. I've long wanted to contribute something to Randy and the group as a way of saying "THANK YOU!".
> > >
> > > I'll upload a sample spreadsheet (DCF Template for smf_addin Group) to the Files area. It's pretty straightforward, and the math is documented in cell E1, but please let me know if you have any questions or need anything else. I start a new job on Monday so please ask your questions before Sunday. :)
> > >
> > > --- In smf_addin@yahoogroups.com , "Jason" <xxjaysonxx@> wrote:
> > > >
> > > > Does anyone have a good DCF template they wouldnt mind sharing?
> > > >
> > >
> > >
> >
>
Thank you for sharing your dcf spreadsheet template, nicely done fellow Texan..
It looks great...
rr76012
--- In smf_addin@yahoogrou
>
>
>
> Sorry, my mistake, I'll upload it again without the link.
>
> --- In smf_addin@yahoogrou
> >
> > Jason,
> >
> > I downloaded it. It's asking for a file called Stock Analysis 001.xlsm. Where do I get that file from?
> > -Taral
> >
> > On Jul 31, 2012, at 8:03 PM, "Bruce" <bruce@> wrote:
> >
> > >
> > >
> > > Jason, I'm so glad you posted this request. I've long wanted to contribute something to Randy and the group as a way of saying "THANK YOU!".
> > >
> > > I'll upload a sample spreadsheet (DCF Template for smf_addin Group) to the Files area. It's pretty straightforward, and the math is documented in cell E1, but please let me know if you have any questions or need anything else. I start a new job on Monday so please ask your questions before Sunday. :)
> > >
> > > --- In smf_addin@yahoogrou
> > > >
> > > > Does anyone have a good DCF template they wouldnt mind sharing?
> > > >
> > >
> > >
> >
>
Fri Aug 3, 2012 6:46 am (PDT) . Posted by:
"leontancfa" leontancfa
Thank you for the reply!
I this these two formulas return option quotes of stocks. ES is "Energy Solution", and NQ is "NQ Mobile Inc."
but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got errors.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> These appears to work fine for me:
>
> =smfGetOptionQuotes("ES 9/22 2012 $5 Call","b",,"OX")
> =smfGetOptionQuotes("NQ 9/22 2012 $5 Call","b",,"OX")
>
> Or are you asking about something else?
>
> On Thu, Aug 2, 2012 at 12:45 PM, leontancfa <leontancfa@...> wrote:
>
> >
> > I know few places quote emini futures options, like ES and NQ's options.
> > OptionsXpress is one of them.
> >
> > I wonder if there is already a proven request format to get quotes of
> > futures options?
> >
> > I made some trial and errors and got all "Error". Hope that you can share
> > your successful trials.
> >
>
I this these two formulas return option quotes of stocks. ES is "Energy Solution", and NQ is "NQ Mobile Inc."
but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got errors.
--- In smf_addin@yahoogrou
>
> These appears to work fine for me:
>
> =smfGetOptionQuotes
> =smfGetOptionQuotes
>
> Or are you asking about something else?
>
> On Thu, Aug 2, 2012 at 12:45 PM, leontancfa <leontancfa@
>
> >
> > I know few places quote emini futures options, like ES and NQ's options.
> > OptionsXpress is one of them.
> >
> > I wonder if there is already a proven request format to get quotes of
> > futures options?
> >
> > I made some trial and errors and got all "Error". Hope that you can share
> > your successful trials.
> >
>
Fri Aug 3, 2012 6:49 am (PDT) . Posted by:
"leontancfa" leontancfa
My question is really that if there is a documentation that how optionxXpress's URL link is compiled? I think the quote is available, just that we need to put in correct parameters.
--- In smf_addin@yahoogroups.com , "leontancfa" <leontancfa@...> wrote:
>
> Thank you for the reply!
>
> I this these two formulas return option quotes of stocks. ES is "Energy Solution", and NQ is "NQ Mobile Inc."
>
> but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
>
> I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got errors.
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > These appears to work fine for me:
> >
> > =smfGetOptionQuotes("ES 9/22 2012 $5 Call","b",,"OX")
> > =smfGetOptionQuotes("NQ 9/22 2012 $5 Call","b",,"OX")
> >
> > Or are you asking about something else?
> >
> > On Thu, Aug 2, 2012 at 12:45 PM, leontancfa <leontancfa@> wrote:
> >
> > >
> > > I know few places quote emini futures options, like ES and NQ's options.
> > > OptionsXpress is one of them.
> > >
> > > I wonder if there is already a proven request format to get quotes of
> > > futures options?
> > >
> > > I made some trial and errors and got all "Error". Hope that you can share
> > > your successful trials.
> > >
> >
>
--- In smf_addin@yahoogrou
>
> Thank you for the reply!
>
> I this these two formulas return option quotes of stocks. ES is "Energy Solution", and NQ is "NQ Mobile Inc."
>
> but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
>
> I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got errors.
> --- In smf_addin@yahoogrou
> >
> > These appears to work fine for me:
> >
> > =smfGetOptionQuotes
> > =smfGetOptionQuotes
> >
> > Or are you asking about something else?
> >
> > On Thu, Aug 2, 2012 at 12:45 PM, leontancfa <leontancfa@
> >
> > >
> > > I know few places quote emini futures options, like ES and NQ's options.
> > > OptionsXpress is one of them.
> > >
> > > I wonder if there is already a proven request format to get quotes of
> > > futures options?
> > >
> > > I made some trial and errors and got all "Error". Hope that you can share
> > > your successful trials.
> > >
> >
>
Fri Aug 3, 2012 9:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yes. It looks like you'll need to write your own formulas to get to the
data.
For ESU12, the URL could be:
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=ESU12
On Fri, Aug 3, 2012 at 6:49 AM, leontancfa <leontancfa@gmail.com > wrote:
>
> but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
>
> I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got
errors.
>
> My question is really that if there is a documentation that how
optionxXpress's URL
> link is compiled? I think the quote is available, just that we need to
put in correct parameters.
data.
For ESU12, the URL could be:
https://www.
On Fri, Aug 3, 2012 at 6:49 AM, leontancfa <leontancfa@gmail.
>
> but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
>
> I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got
errors.
>
> My question is really that if there is a documentation that how
optionxXpress'
> link is compiled? I think the quote is available, just that we need to
put in correct parameters.
Fri Aug 3, 2012 11:40 am (PDT) . Posted by:
"leontancfa" leontancfa
Thank you!
Further talking with OX, it turns out they only offer futures options quotes for clients who sign additional papers. So OX is not a good source for futures options...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Yes. It looks like you'll need to write your own formulas to get to the
> data.
>
> For ESU12, the URL could be:
>
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=ESU12
>
> On Fri, Aug 3, 2012 at 6:49 AM, leontancfa <leontancfa@...> wrote:
> >
> > but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
> >
> > I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got
> errors.
> >
> > My question is really that if there is a documentation that how
> optionxXpress's URL
> > link is compiled? I think the quote is available, just that we need to
> put in correct parameters.
>
Further talking with OX, it turns out they only offer futures options quotes for clients who sign additional papers. So OX is not a good source for futures options...
--- In smf_addin@yahoogrou
>
> Yes. It looks like you'll need to write your own formulas to get to the
> data.
>
> For ESU12, the URL could be:
>
> https://www.
>
> On Fri, Aug 3, 2012 at 6:49 AM, leontancfa <leontancfa@
> >
> > but in emini futures quoting, ES is emini S&P, and NQ is emini Nasdaq 100.
> >
> > I tried symbols like ESU2 for ES sep '12 futures, and so on, but all got
> errors.
> >
> > My question is really that if there is a documentation that how
> optionxXpress'
> > link is compiled? I think the quote is available, just that we need to
> put in correct parameters.
>
Fri Aug 3, 2012 8:21 am (PDT) . Posted by:
"anto_bonn" anto_bonn
Hi Randy,
First of let me thank you for this wonderful add in. This is great work!
Can you please clarify this
I understand that Rchgettablecell("xxx",1,"AA") will fetch the data in one cell right to "AA" label
is it possible to fetch data that is one cell below the label "AA"?
if example i am trying to fetch the Last Price from "http://www.indiainfoline.com/Markets/Derivatives/OPTSTK/SUNPHARMA/30-Aug-2012/PE/620 "
Antony
First of let me thank you for this wonderful add in. This is great work!
Can you please clarify this
I understand that Rchgettablecell(
is it possible to fetch data that is one cell below the label "AA"?
if example i am trying to fetch the Last Price from "http://www.indiainf
Antony
Fri Aug 3, 2012 9:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to use the pRows parameter to skip rows. For example:
=RCHGetTableCell("
http://www.indiainfoline.com/Markets/Derivatives/OPTSTK/SUNPHARMA/30-Aug-2012/PE/620 ",1,"Last
Price",,,,1)
On Fri, Aug 3, 2012 at 7:38 AM, anto_bonn <anto_bonn@yahoo.co.in > wrote:
>
> Can you please clarify this
>
> I understand that Rchgettablecell("xxx",1,"AA") will fetch the data in one
> cell right to "AA" label
>
> is it possible to fetch data that is one cell below the label "AA"?
>
> if example i am trying to fetch the Last Price from "
> http://www.indiainfoline.com/Markets/Derivatives/OPTSTK/SUNPHARMA/30-Aug-2012/PE/620
> "
>
=RCHGetTableCell(
http://www.indiainf
Price",,,,1)
On Fri, Aug 3, 2012 at 7:38 AM, anto_bonn <anto_bonn@yahoo.
>
> Can you please clarify this
>
> I understand that Rchgettablecell(
> cell right to "AA" label
>
> is it possible to fetch data that is one cell below the label "AA"?
>
> if example i am trying to fetch the Last Price from "
> http://www.indiainf
> "
>
Fri Aug 3, 2012 9:00 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Since I installed the latest beta version of 2012-07-12 none of the MSN
spreadsheets work . There were working before the install. I have tested
several other spreadsheets some with MSN formulas and some non-MSN formulas.
The non-MSN formulas work. The MSN formulas all fail.
All MSN spreadsheet fail, include one I downloaded August 2011 -
SMF-Template-MSN-10-Year-Summaries.xls
I follow the exact procedure I use each time I make as version change, I
create a folder and move the previous version into it, then I copy the new
version into the SMF Add-in folder in the program files folder.
Each time I download a new spreadsheet I run the smffixlinks macro.
I searched messages in the yahoo group but did not see any problem with the
new version. So I suspect I may be doing something wrong.
I am open to any suggestions anyone might have to resolve the problem.
Kermit
__________________________________________________________
________
Below is examples from one of the MSN spreadsheets:
For example: RCHGetHTMLTable-Template-MSN-Annual-Financials.xls every cell
contains blanks. I have the latest spreadsheet from the yahoo group.
For example: Cell B6 has this formula content"
=IF(Ticker="None","
",RCHGetHTMLTable("http://investing.money.msn.com/investments/stock-income-s
tatement/?symbol="&Ticker,"Stmt Source",-1,"",1))
It results in blanks in the cell as does every formula.
When I add =RCHGetElementNumber("Version") to cell E2 I get:
Stock Market Functions add-in, Version 2.1.2012.07.12 (C:\Program Files\SMF
Add-in; 1)
So I have the latest version install.
spreadsheets work . There were working before the install. I have tested
several other spreadsheets some with MSN formulas and some non-MSN formulas.
The non-MSN formulas work. The MSN formulas all fail.
All MSN spreadsheet fail, include one I downloaded August 2011 -
SMF-Template-
I follow the exact procedure I use each time I make as version change, I
create a folder and move the previous version into it, then I copy the new
version into the SMF Add-in folder in the program files folder.
Each time I download a new spreadsheet I run the smffixlinks macro.
I searched messages in the yahoo group but did not see any problem with the
new version. So I suspect I may be doing something wrong.
I am open to any suggestions anyone might have to resolve the problem.
Kermit
____________
________
Below is examples from one of the MSN spreadsheets:
For example: RCHGetHTMLTable-
contains blanks. I have the latest spreadsheet from the yahoo group.
For example: Cell B6 has this formula content"
=IF(Ticker="
",RCHGetHTMLTable(
tatement/?symbol=
It results in blanks in the cell as does every formula.
When I add =RCHGetElementNumbe
Stock Market Functions add-in, Version 2.1.2012.07.
Add-in; 1)
So I have the latest version install.
Fri Aug 3, 2012 9:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What happens if you use this URL in EXCEL's Web Query dialog:
http://investing.money.msn.com/investments/stock-income-statement/?symbol=MMM
All of the workbooks you mention are working fine for me, and the
2012-07-12 release should be an exact copy of what I'm running.
On Fri, Aug 3, 2012 at 9:00 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Since I installed the latest beta version of 2012-07-12 none of the MSN
> spreadsheets work . There were working before the install. I have tested
> several other spreadsheets some with MSN formulas and some non-MSN
> formulas. The non-MSN formulas work. The MSN formulas all fail. ****
>
> ** **
>
> All MSN spreadsheet fail, include one I downloaded August 2011 -
> SMF-Template-MSN-10-Year-Summaries.xls****
>
> ** **
>
> I follow the exact procedure I use each time I make as version change, I
> create a folder and move the previous version into it, then I copy the new
> version into the SMF Add-in folder in the program files folder. ****
>
> ** **
>
> Each time I download a new spreadsheet I run the smffixlinks macro. ****
>
> ** **
>
> I searched messages in the yahoo group but did not see any problem with
> the new version. So I suspect I may be doing something wrong. ****
>
> ** **
>
> I am open to any suggestions anyone might have to resolve the problem. ***
> *
>
> ** **
>
> Kermit****
>
> ** **
>
>
> __________________________________________________________
> ****
>
> Below is examples from one of the MSN spreadsheets:****
>
> ** **
>
> For example: RCHGetHTMLTable-Template-MSN-Annual-Financials.xls every cell
> contains blanks. I have the latest spreadsheet from the yahoo group. ****
>
> ** **
>
> For example: Cell B6 has this formula content"****
>
> ** **
>
> =IF(Ticker="None"," ",RCHGetHTMLTable("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol= "&Ticker,"Stmt
> Source",-1,"",1))****
>
> ** **
>
> It results in blanks in the cell as does every formula. ****
>
> ** **
>
> When I add =RCHGetElementNumber("Version") to cell E2 I get:****
>
> Stock Market Functions add-in, Version 2.1.2012.07.12 (C:\Program
> Files\SMF Add-in; 1)****
>
> ** **
>
> So I have the latest version install.
>
http://investing.
All of the workbooks you mention are working fine for me, and the
2012-07-12 release should be an exact copy of what I'm running.
On Fri, Aug 3, 2012 at 9:00 AM, Kermit W. Prather
<kermitp@tampabay.
>
> Since I installed the latest beta version of 2012-07-12 none of the MSN
> spreadsheets work . There were working before the install. I have tested
> several other spreadsheets some with MSN formulas and some non-MSN
> formulas. The non-MSN formulas work. The MSN formulas all fail. ****
>
> ** **
>
> All MSN spreadsheet fail, include one I downloaded August 2011 -
> SMF-Template-
>
> ** **
>
> I follow the exact procedure I use each time I make as version change, I
> create a folder and move the previous version into it, then I copy the new
> version into the SMF Add-in folder in the program files folder. ****
>
> ** **
>
> Each time I download a new spreadsheet I run the smffixlinks macro. ****
>
> ** **
>
> I searched messages in the yahoo group but did not see any problem with
> the new version. So I suspect I may be doing something wrong. ****
>
> ** **
>
> I am open to any suggestions anyone might have to resolve the problem. ***
> *
>
> ** **
>
> Kermit****
>
> ** **
>
>
> ____________
> ****
>
> Below is examples from one of the MSN spreadsheets:
>
> ** **
>
> For example: RCHGetHTMLTable-
> contains blanks. I have the latest spreadsheet from the yahoo group. ****
>
> ** **
>
> For example: Cell B6 has this formula content"****
>
> ** **
>
> =IF(Ticker="
> http://investing.
> Source",-1,"
>
> ** **
>
> It results in blanks in the cell as does every formula. ****
>
> ** **
>
> When I add =RCHGetElementNumbe
>
> Stock Market Functions add-in, Version 2.1.2012.07.
> Files\SMF Add-in; 1)****
>
> ** **
>
> So I have the latest version install.
>
Fri Aug 3, 2012 4:09 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, thanks for the response.
I did ask you requested and when I click on the link you provided I get the proper web page for MMM.
2011
2010
2009
2008
2007
Period End Date
12/31/2011
12/31/2010
12/31/2009
12/31/2008
12/31/2007
Period Length
12 Months
12 Months
12 Months
12 Months
12 Months
Stmt Source
10-K
10-K
10-K
10-K
10-K
I tested the MSN spreadsheets I mention in the previous email and they still failed.
So I decided that I would reboot my VISTA 64 machine since it had been 12 days. .
When I tried both spreadsheets after the reboot they both worked great.
I then re-downloaded the DCF template spreadsheet and tried it. It also worked just fine.
Sorry, to be a pain. Guess I'll make it a habit to reboot my machines at least once a week.
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, August 03, 2012 12:18 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] No MSN spreadsheet works after installing latest version
What happens if you use this URL in EXCEL's Web Query dialog:
http://investing.money.msn.com/investments/stock-income-statement/?symbol=MMM
All of the workbooks you mention are working fine for me, and the 2012-07-12 release should be an exact copy of what I'm running.
On Fri, Aug 3, 2012 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
Since I installed the latest beta version of 2012-07-12 none of the MSN spreadsheets work . There were working before the install. I have tested several other spreadsheets some with MSN formulas and some non-MSN formulas. The non-MSN formulas work. The MSN formulas all fail.
All MSN spreadsheet fail, include one I downloaded August 2011 - SMF-Template-MSN-10-Year-Summaries.xls
I follow the exact procedure I use each time I make as version change, I create a folder and move the previous version into it, then I copy the new version into the SMF Add-in folder in the program files folder.
Each time I download a new spreadsheet I run the smffixlinks macro.
I searched messages in the yahoo group but did not see any problem with the new version. So I suspect I may be doing something wrong.
I am open to any suggestions anyone might have to resolve the problem.
Kermit
__________________________________________________________
Below is examples from one of the MSN spreadsheets:
For example: RCHGetHTMLTable-Template-MSN-Annual-Financials.xls every cell contains blanks. I have the latest spreadsheet from the yahoo group.
For example: Cell B6 has this formula content"
=IF(Ticker="None"," ",RCHGetHTMLTable("http://investing.money.msn.com/investments/stock-income-statement/?symbol= "&Ticker,"Stmt Source",-1,"",1))
It results in blanks in the cell as does every formula.
When I add =RCHGetElementNumber("Version") to cell E2 I get:
Stock Market Functions add-in, Version 2.1.2012.07.12 (C:\Program Files\SMF Add-in; 1)
So I have the latest version install.
I did ask you requested and when I click on the link you provided I get the proper web page for MMM.
2011
2010
2009
2008
2007
Period End Date
12/31/2011
12/31/2010
12/31/2009
12/31/2008
12/31/2007
Period Length
12 Months
12 Months
12 Months
12 Months
12 Months
Stmt Source
10-K
10-K
10-K
10-K
10-K
I tested the MSN spreadsheets I mention in the previous email and they still failed.
So I decided that I would reboot my VISTA 64 machine since it had been 12 days. .
When I tried both spreadsheets after the reboot they both worked great.
I then re-downloaded the DCF template spreadsheet and tried it. It also worked just fine.
Sorry, to be a pain. Guess I'll make it a habit to reboot my machines at least once a week.
Thanks
From: smf_addin@yahoogrou
Sent: Friday, August 03, 2012 12:18 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] No MSN spreadsheet works after installing latest version
What happens if you use this URL in EXCEL's Web Query dialog:
http://investing.
All of the workbooks you mention are working fine for me, and the 2012-07-12 release should be an exact copy of what I'm running.
On Fri, Aug 3, 2012 at 9:00 AM, Kermit W. Prather <kermitp@tampabay.
Since I installed the latest beta version of 2012-07-12 none of the MSN spreadsheets work . There were working before the install. I have tested several other spreadsheets some with MSN formulas and some non-MSN formulas. The non-MSN formulas work. The MSN formulas all fail.
All MSN spreadsheet fail, include one I downloaded August 2011 - SMF-Template-
I follow the exact procedure I use each time I make as version change, I create a folder and move the previous version into it, then I copy the new version into the SMF Add-in folder in the program files folder.
Each time I download a new spreadsheet I run the smffixlinks macro.
I searched messages in the yahoo group but did not see any problem with the new version. So I suspect I may be doing something wrong.
I am open to any suggestions anyone might have to resolve the problem.
Kermit
____________
Below is examples from one of the MSN spreadsheets:
For example: RCHGetHTMLTable-
For example: Cell B6 has this formula content"
=IF(Ticker="
It results in blanks in the cell as does every formula.
When I add =RCHGetElementNumbe
Stock Market Functions add-in, Version 2.1.2012.07.
So I have the latest version install.
Fri Aug 3, 2012 2:37 pm (PDT) . Posted by:
"dice962" dice962
Okay thanks Randy that is very helpful. Looks like Teddi uses various settings, depending on the time frame. I am going to try using some of the indicators on Barcharts for now as a starting point and see how that goes, maybe it is a better option, before moving on to the other indicators. Most of the indicators that she uses are there.
I started just with getting Support, Price, Pivot Point, and Resistance, so here are my formulas. This is the first time I have pulled data directly from a web page into your add-on, so has been a good learning experience.
I had used different reference points to get it to locate, through trial and error to get the data (in case anyone wonders why all the Find strings and Row and Cell #'s are inconsistent with each other):
SUPPORT
=RCHGetTableCell(
PRICE
=RCHGetTableCell(
PIVOT POINT
=RCHGetTableCell(
RESISTANCE
=RCHGetTableCell(
--- In smf_addin@yahoogrou
>
> Where are you seeing the numbers you want to extract from StockCharts?
>
> Do you know the settings that Teddi uses for the market indicators?
>
> Barchart has a several pages of various indicators that are easily
> extractable:
>
> http://www.barchart
> http://www.barchart
>
>
Fri Aug 3, 2012 3:28 pm (PDT) . Posted by:
"dice962" dice962
A few more.
Any feedback/criticism on a more consistent way for me to map these, let me know, I'm just sort of winging it until I get the right combination that matches the data on the webpage:
PercentR(20-
=RCHGetTableCell(
Stochastic %D (20-day)
=RCHGetTableCell(
Relative Strength (20-day)
=RCHGetTableCell(
MACD Oscillator (20-day)
=RCHGetTableCell(
--- In smf_addin@yahoogrou
>
>
>
> Okay thanks Randy that is very helpful. Looks like Teddi uses various settings, depending on the time frame. I am going to try using some of the indicators on Barcharts for now as a starting point and see how that goes, maybe it is a better option, before moving on to the other indicators. Most of the indicators that she uses are there.
>
> I started just with getting Support, Price, Pivot Point, and Resistance, so here are my formulas. This is the first time I have pulled data directly from a web page into your add-on, so has been a good learning experience.
>
> I had used different reference points to get it to locate, through trial and error to get the data (in case anyone wonders why all the Find strings and Row and Cell #'s are inconsistent with each other):
>
> SUPPORT
> =RCHGetTableCell(
>
> PRICE
> =RCHGetTableCell(
>
> PIVOT POINT
> =RCHGetTableCell(
>
> RESISTANCE
> =RCHGetTableCell(
>
> --- In smf_addin@yahoogrou
> >
> > Where are you seeing the numbers you want to extract from StockCharts?
> >
> > Do you know the settings that Teddi uses for the market indicators?
> >
> > Barchart has a several pages of various indicators that are easily
> > extractable:
> >
> > http://www.barchart
> > http://www.barchart
> >
> >
>
Fri Aug 3, 2012 4:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You may want to look at these two templates in the files area:
SMF-Template-Barchart-Technical-Indicators.xls
RCHGetTableCell-Template-BarChart-Technical-Signals.xls
I think they contain everything from the two pages you're looking at, plus
another.
And there was just a recent thread on getting the data from the "Cheat
Sheet" page:
http://www.barchart.com/cheatsheet.php?sym=MMM
http://finance.groups.yahoo.com/group/smf_addin/message/19230
On Fri, Aug 3, 2012 at 3:28 PM, dice962 <derekbarrett@gmail.com > wrote:
>
> A few more.
>
> Any feedback/criticism on a more consistent way for me to map these, let
> me know, I'm just sort of winging it until I get the right combination that
> matches the data on the webpage:
>
> PercentR(20-day)
>
> =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY ",0,"Percent
> R","20-Day",1)
>
> Stochastic %D (20-day)
>
> =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY ",0,"Stochastic
> %D","20-Day",6)
>
> Relative Strength (20-day)
>
> =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY ",1,"Relative
> Strength","20-Day")
>
> MACD Oscillator (20-day)
>
> =RCHGetTableCell("http://www.barchart.com/technicals/stocks/LLY ",1,"MACD
> Oscillator","20-Day",4)
>
>
> --- In smf_addin@yahoogroups.com , "dice962" <derekbarrett@...> wrote:
> >
> >
> >
> > Okay thanks Randy that is very helpful. Looks like Teddi uses various
> settings, depending on the time frame. I am going to try using some of the
> indicators on Barcharts for now as a starting point and see how that goes,
> maybe it is a better option, before moving on to the other indicators. Most
> of the indicators that she uses are there.
> >
> > I started just with getting Support, Price, Pivot Point, and Resistance,
> so here are my formulas. This is the first time I have pulled data directly
> from a web page into your add-on, so has been a good learning experience.
> >
> > I had used different reference points to get it to locate, through trial
> and error to get the data (in case anyone wonders why all the Find strings
> and Row and Cell #'s are inconsistent with each other):
> >
> > SUPPORT
> > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY ",1,"Composite
> Indicators","Support",1)
> >
> > PRICE
> > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY ",-4,"Composite
> Indicators","Overall Average",3)
> >
> > PIVOT POINT
> > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY ",-2,"Composite
> Indicators","Overall Average",3)
> >
> > RESISTANCE
> > =RCHGetTableCell("http://www.barchart.com/opinions/stocks/LLY ",1,"Composite
> Indicators","Resistance",0)
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Where are you seeing the numbers you want to extract from StockCharts?
> > >
> > > Do you know the settings that Teddi uses for the market indicators?
> > >
> > > Barchart has a several pages of various indicators that are easily
> > > extractable:
> > >
> > > http://www.barchart.com/technicals/stocks/MMM
> > > http://www.barchart.com/opinions/stocks/MMM
> > >
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
SMF-Template-
RCHGetTableCell-
I think they contain everything from the two pages you're looking at, plus
another.
And there was just a recent thread on getting the data from the "Cheat
Sheet" page:
http://www.barchart
http://finance.
On Fri, Aug 3, 2012 at 3:28 PM, dice962 <derekbarrett@
>
> A few more.
>
> Any feedback/criticism on a more consistent way for me to map these, let
> me know, I'm just sort of winging it until I get the right combination that
> matches the data on the webpage:
>
> PercentR(20-
>
> =RCHGetTableCell(
> R","20-Day",
>
> Stochastic %D (20-day)
>
> =RCHGetTableCell(
> %D","20-Day"
>
> Relative Strength (20-day)
>
> =RCHGetTableCell(
> Strength","20-
>
> MACD Oscillator (20-day)
>
> =RCHGetTableCell(
> Oscillator",
>
>
> --- In smf_addin@yahoogrou
> >
> >
> >
> > Okay thanks Randy that is very helpful. Looks like Teddi uses various
> settings, depending on the time frame. I am going to try using some of the
> indicators on Barcharts for now as a starting point and see how that goes,
> maybe it is a better option, before moving on to the other indicators. Most
> of the indicators that she uses are there.
> >
> > I started just with getting Support, Price, Pivot Point, and Resistance,
> so here are my formulas. This is the first time I have pulled data directly
> from a web page into your add-on, so has been a good learning experience.
> >
> > I had used different reference points to get it to locate, through trial
> and error to get the data (in case anyone wonders why all the Find strings
> and Row and Cell #'s are inconsistent with each other):
> >
> > SUPPORT
> > =RCHGetTableCell(
> Indicators",
> >
> > PRICE
> > =RCHGetTableCell(
> Indicators",
> >
> > PIVOT POINT
> > =RCHGetTableCell(
> Indicators",
> >
> > RESISTANCE
> > =RCHGetTableCell(
> Indicators",
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Where are you seeing the numbers you want to extract from StockCharts?
> > >
> > > Do you know the settings that Teddi uses for the market indicators?
> > >
> > > Barchart has a several pages of various indicators that are easily
> > > extractable:
> > >
> > > http://www.barchart
> > > http://www.barchart
> > >
> > >
> >
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
>
>
Fri Aug 3, 2012 11:21 pm (PDT) . Posted by:
"Larry_Hershkowitz" Larry_Hershkowitz
Currently this template runs the data in descending order as far as the year. How do you change it to go in ascending order?
Tidak ada komentar:
Posting Komentar