7 New Messages
Digest #2879
Messages
Fri Nov 29, 2013 12:58 am (PST) . Posted by:
"Imran Naqvi" naqviimran1514
Hi Randy,
How would I download the data for open for both BSE and NSE in the following link:
http://www.marketonmobile.com/companies/sesa-sterlite/500295
Thanks in advance.
How would I download the data for open for both BSE and NSE in the following link:
http://www.marketon
Thanks in advance.
Fri Nov 29, 2013 1:02 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Looks like:
=smfConvertData(smfGetTagContent("
http://www.marketonmobile.com/companies/sesa-sterlite/500295
","li",1,">Open"))
=smfConvertData(smfGetTagContent("
http://www.marketonmobile.com/companies/sesa-sterlite/500295
","li",2,">Open"))
On Fri, Nov 29, 2013 at 12:00 AM, Imran Naqvi <naqviimran1514@yahoo.com>wrote:
>
> How would I download the data for open for both BSE and NSE in the
> following link:
>
> http://www.marketonmobile.com/companies/sesa-sterlite/500295
>
>
>
=smfConvertData(
http://www.marketon
","
=smfConvertData(
http://www.marketon
","
On Fri, Nov 29, 2013 at 12:00 AM, Imran Naqvi <naqviimran1514@
>
> How would I download the data for open for both BSE and NSE in the
> following link:
>
> http://www.marketon
>
>
>
Fri Nov 29, 2013 2:00 am (PST) . Posted by:
"Imran Naqvi" naqviimran1514
Thanks buddy. One more help please.
When I try to modify your formula to get the "As on" value, it gives me this error
<a href='/Sensex' title="Sensex">SENSEX</a>
I modified the formula as:
=smfConvertData(smfGetTagContent("http://www.marketonmobile.com/companies/sesa-sterlite/500295,"li",1,">As on"))
On Friday, November 29, 2013 2:32 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
Looks like:
=smfConvertData(smfGetTagContent("http://www.marketonmobile.com/companies/sesa-sterlite/500295","li",1,">Open"))
=smfConvertData(smfGetTagContent("http://www.marketonmobile.com/companies/sesa-sterlite/500295","li",2,">Open"))
On Fri, Nov 29, 2013 at 12:00 AM, Imran Naqvi <naqviimran1514@yahoo.com> wrote:
>
>How would I download the data for open for both BSE and NSE in the following link:
>
>
>http://www.marketonmobile.com/companies/sesa-sterlite/500295
>
>
>
>
When I try to modify your formula to get the "As on" value, it gives me this error
<a href='/Sensex&#
I modified the formula as:
=smfConvertData(
On Friday, November 29, 2013 2:32 PM, Randy Harmelink <rharmelink@gmail.
Looks like:
=smfConvertData(
=smfConvertData(
On Fri, Nov 29, 2013 at 12:00 AM, Imran Naqvi <naqviimran1514@
>
>How would I download the data for open for both BSE and NSE in the following link:
>
>
>http://www.marketon
>
>
>
>
Fri Nov 29, 2013 3:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That's because the first ">As on" string on the web page is above the
SENSEX and NIFTY quotes. For those on the BSE and NSE quotes, try:
=smfGetTagContent("
http://www.marketonmobile.com/companies/sesa-sterlite/500295","li",1,">As
on",">As on")
=smfGetTagContent("
http://www.marketonmobile.com/companies/sesa-sterlite/500295","li",2,">As
on",">As on")
I dropped the smfConvertData() function because there's it doesn't need to
convert the data.
On Fri, Nov 29, 2013 at 3:00 AM, Imran Naqvi <naqviimran1514@yahoo.com>wrote:
>
> When I try to modify your formula to get the "As on" value, it gives me
> this error
>
> <a href='/Sensex' title="Sensex">SENSEX</a>
>
> I modified the formula as:
>
> =smfConvertData(smfGetTagContent("
> http://www.marketonmobile.com/companies/sesa-sterlite/500295,"li",1,">As
> on"))
>
SENSEX and NIFTY quotes. For those on the BSE and NSE quotes, try:
=smfGetTagContent(
http://www.marketon
on","
=smfGetTagContent(
http://www.marketon
on","
I dropped the smfConvertData(
convert the data.
On Fri, Nov 29, 2013 at 3:00 AM, Imran Naqvi <naqviimran1514@
>
> When I try to modify your formula to get the "As on" value, it gives me
> this error
>
> <a href='/Sensex&#
>
> I modified the formula as:
>
> =smfConvertData(
> http://www.marketon
> on"))
>
Fri Nov 29, 2013 6:46 am (PST) . Posted by:
"rtexican" rtexican
Sorry, the info I posted previously is certainly not clear.
In particular, the workbook I was trying to work from is the MOTLEY FOOL'S FOOLISH 8 ONE-CLICK SCORECARD in the files section by supernaut570.
One of the formulae is:" RCHGetElementNumber($B$4, 38)/1000000" while another is: "RCHGetElementNumber($B$4, 40)"
In the above formulae, the elements 38 and 40 are not working for me. Also, elements 25 works… but 37 does not.
An interesting thing about this is that when I first download the worksheet/book, the formulae contain the "'C:\~Steve Documents\~Downloads\SMF_Addin\RCH_Stock_Market_Functions.xla'!", which I do delete. Before I enable editing, all the cells have valid data. As soon as I delete the above, the cells either show "VALUE" or "Error". I can place the "RCHGetElementNumber …. " in a separate workbook and they do not work either.
I update my workbook and have checked to be sure the path to the add in is correct.
I can certainly use another method to get this info, but I did like the simple methods used in this example.
Thanks
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'll need more info, since what you're telling me doesn't make sense to me.
>
> The smf-elements-1.txt file contains element definitions for data from MSN
> web pages. And I don't know which Motley Fool spreadsheets you are talking
> about. In any case, the two would be unrelated. If the files are from the
> "Uploads by Forum Members" folder, I don't support those workbooks.
> However, if you would cite a few particular formula examples that are
> having problems, I would be happy to look at those.
>
> I will note that there was some talk several months ago on the TMF
> discussion boards that TMF had bought some software that would prevent
> automated web page retrieval from their web site. I've not tested that.
>
> On Wed, Nov 27, 2013 at 8:50 AM, rtexican <RHerb505@...> wrote:
>
> > For quite some time now I have been unable to get smf-element-1 to work.
> > When I load the Motley Fool spreadsheets, I get "error" and "value"
> > messages in the fields. This has gone on for over a year and I do have all
> > the latest files loaded.
> >
> > I am using Windows 7, Excel 2010 and it shows using 4 processors when I
> > first load. I have tried the force calculation method as well.
> >
> > I can live without it for sure, but, I do like the worksheets that have
> > been uploaded and they would be nice additions to my larger research
> > workbook.
> >
>
In particular, the workbook I was trying to work from is the MOTLEY FOOL'S FOOLISH 8 ONE-CLICK SCORECARD in the files section by supernaut570.
One of the formulae is:" RCHGetElementNumber
In the above formulae, the elements 38 and 40 are not working for me. Also, elements 25 works… but 37 does not.
An interesting thing about this is that when I first download the worksheet/book, the formulae contain the "'C:
I update my workbook and have checked to be sure the path to the add in is correct.
I can certainly use another method to get this info, but I did like the simple methods used in this example.
Thanks
--- In smf_addin@yahoogrou
>
> I'll need more info, since what you're telling me doesn't make sense to me.
>
> The smf-elements-
> web pages. And I don't know which Motley Fool spreadsheets you are talking
> about. In any case, the two would be unrelated. If the files are from the
> "Uploads by Forum Members" folder, I don't support those workbooks.
> However, if you would cite a few particular formula examples that are
> having problems, I would be happy to look at those.
>
> I will note that there was some talk several months ago on the TMF
> discussion boards that TMF had bought some software that would prevent
> automated web page retrieval from their web site. I've not tested that.
>
> On Wed, Nov 27, 2013 at 8:50 AM, rtexican <RHerb505@
>
> > For quite some time now I have been unable to get smf-element-
> > When I load the Motley Fool spreadsheets, I get "error" and "value"
> > messages in the fields. This has gone on for over a year and I do have all
> > the latest files loaded.
> >
> > I am using Windows 7, Excel 2010 and it shows using 4 processors when I
> > first load. I have tried the force calculation method as well.
> >
> > I can live without it for sure, but, I do like the worksheets that have
> > been uploaded and they would be nice additions to my larger research
> > workbook.
> >
>
Fri Nov 29, 2013 6:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
If element #25 is working, you have an outdated smf-elements-1.txt file,
since I obsoleted that element. You can get a new copy of those element
definitions from the "Works in Progress" folder.
When you have a path in front of a formula, don't change the path, delete
it. See the "Location Errors" item in the LINKS area of the group. I
usually just use the smfFixLinks macro to remove such paths. The reason you
get a path is because EXCEL saves the hard-coded location of the add-in
whenever a file is saved. If the opener of the file doesn't have the file
in the same location, those links are left unresolved and as-is.
On Fri, Nov 29, 2013 at 7:46 AM, rtexican <RHerb505@charter.net> wrote:
> Sorry, the info I posted previously is certainly not clear.
> In particular, the workbook I was trying to work from is the MOTLEY
> FOOL'S FOOLISH 8 ONE-CLICK SCORECARD in the files section by supernaut570.
> One of the formulae is:" RCHGetElementNumber($B$4, 38)/1000000" while
> another is: "RCHGetElementNumber($B$4, 40)"
> In the above formulae, the elements 38 and 40 are not working for me.
> Also, elements 25 works… but 37 does not.
> An interesting thing about this is that when I first download the
> worksheet/book, the formulae contain the "'C:\~Steve
> Documents\~Downloads\SMF_Addin\RCH_Stock_Market_Functions.xla'!", which I
> do delete. Before I enable editing, all the cells have valid data. As
> soon as I delete the above, the cells either show "VALUE" or "Error". I
> can place the "RCHGetElementNumber …. " in a separate workbook and they do
> not work either.
> I update my workbook and have checked to be sure the path to the add in is
> correct.
> I can certainly use another method to get this info, but I did like the
> simple methods used in this example.
>
since I obsoleted that element. You can get a new copy of those element
definitions from the "Works in Progress" folder.
When you have a path in front of a formula, don't change the path, delete
it. See the "Location Errors" item in the LINKS area of the group. I
usually just use the smfFixLinks macro to remove such paths. The reason you
get a path is because EXCEL saves the hard-coded location of the add-in
whenever a file is saved. If the opener of the file doesn't have the file
in the same location, those links are left unresolved and as-is.
On Fri, Nov 29, 2013 at 7:46 AM, rtexican <RHerb505@charter.
> Sorry, the info I posted previously is certainly not clear.
> In particular, the workbook I was trying to work from is the MOTLEY
> FOOL'S FOOLISH 8 ONE-CLICK SCORECARD in the files section by supernaut570.
> One of the formulae is:" RCHGetElementNumber
> another is: "RCHGetElement
> In the above formulae, the elements 38 and 40 are not working for me.
> Also, elements 25 works… but 37 does not.
> An interesting thing about this is that when I first download the
> worksheet/book, the formulae contain the "'C:
> Documents\
> do delete. Before I enable editing, all the cells have valid data. As
> soon as I delete the above, the cells either show "VALUE" or "Error"
> can place the "RCHGetElement
> not work either.
> I update my workbook and have checked to be sure the path to the add in is
> correct.
> I can certainly use another method to get this info, but I did like the
> simple methods used in this example.
>
Fri Nov 29, 2013 8:14 am (PST) . Posted by:
"rtexican" rtexican
When I stated element#25 works, it does say "obsolete";, sorry. I do happen to have the recent update, however. It appears that I may just need to not use smf-element-1. All the rest seem to work properly.
I do delete the path in front of the formula.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If element #25 is working, you have an outdated smf-elements-1.txt file,
> since I obsoleted that element. You can get a new copy of those element
> definitions from the "Works in Progress" folder.
>
> When you have a path in front of a formula, don't change the path, delete
> it. See the "Location Errors" item in the LINKS area of the group. I
> usually just use the smfFixLinks macro to remove such paths. The reason you
> get a path is because EXCEL saves the hard-coded location of the add-in
> whenever a file is saved. If the opener of the file doesn't have the file
> in the same location, those links are left unresolved and as-is.
>
> On Fri, Nov 29, 2013 at 7:46 AM, rtexican <RHerb505@...> wrote:
>
> > Sorry, the info I posted previously is certainly not clear.
> > In particular, the workbook I was trying to work from is the MOTLEY
> > FOOL'S FOOLISH 8 ONE-CLICK SCORECARD in the files section by supernaut570.
> > One of the formulae is:" RCHGetElementNumber($B$4, 38)/1000000" while
> > another is: "RCHGetElementNumber($B$4, 40)"
> > In the above formulae, the elements 38 and 40 are not working for me.
> > Also, elements 25 works… but 37 does not.
> > An interesting thing about this is that when I first download the
> > worksheet/book, the formulae contain the "'C:\~Steve
> > Documents\~Downloads\SMF_Addin\RCH_Stock_Market_Functions.xla'!", which I
> > do delete. Before I enable editing, all the cells have valid data. As
> > soon as I delete the above, the cells either show "VALUE" or "Error". I
> > can place the "RCHGetElementNumber …. " in a separate workbook and they do
> > not work either.
> > I update my workbook and have checked to be sure the path to the add in is
> > correct.
> > I can certainly use another method to get this info, but I did like the
> > simple methods used in this example.
> >
>
I do delete the path in front of the formula.
--- In smf_addin@yahoogrou
>
> If element #25 is working, you have an outdated smf-elements-
> since I obsoleted that element. You can get a new copy of those element
> definitions from the "Works in Progress" folder.
>
> When you have a path in front of a formula, don't change the path, delete
> it. See the "Location Errors" item in the LINKS area of the group. I
> usually just use the smfFixLinks macro to remove such paths. The reason you
> get a path is because EXCEL saves the hard-coded location of the add-in
> whenever a file is saved. If the opener of the file doesn't have the file
> in the same location, those links are left unresolved and as-is.
>
> On Fri, Nov 29, 2013 at 7:46 AM, rtexican <RHerb505@
>
> > Sorry, the info I posted previously is certainly not clear.
> > In particular, the workbook I was trying to work from is the MOTLEY
> > FOOL'S FOOLISH 8 ONE-CLICK SCORECARD in the files section by supernaut570.
> > One of the formulae is:" RCHGetElementNumber
> > another is: "RCHGetElement
> > In the above formulae, the elements 38 and 40 are not working for me.
> > Also, elements 25 works… but 37 does not.
> > An interesting thing about this is that when I first download the
> > worksheet/book, the formulae contain the "'C:
> > Documents\
> > do delete. Before I enable editing, all the cells have valid data. As
> > soon as I delete the above, the cells either show "VALUE" or "Error"
> > can place the "RCHGetElement
> > not work either.
> > I update my workbook and have checked to be sure the path to the add in is
> > correct.
> > I can certainly use another method to get this info, but I did like the
> > simple methods used in this example.
> >
>
Tidak ada komentar:
Posting Komentar