7 Messages
Digest #3090
Messages
Wed Jun 11, 2014 2:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The data is in JavaScript. You can get each company's data with:
=smfWord(RCHGetWebData("https://www.google.com/finance?q=NKE
","rows:",5000),3,"[")
...varying the 3 from 3 to 13. For example, for me, that formula returns:
"NKE","Nike
Inc","NYSE","USD","76.31","-0.36","-0.47","","2.96","25.75","67.23B","0.24","7.45","15.43","24.45","9.83","13.44","chr","25670","NKE"]},{id:"5005244",values:
However, you'll need to extract it out of there. Which data is in each
column is dependent on how you customized the display of data. For me,
ticker symbol and market cap (in thousands) would be:
=SUBSTITUTE(smfWord(smfWord(RCHGetWebData("
https://www.google.com/finance?q=NKE","rows:",5000),4,"["),1,","),"""","")
=smfConvertData(SUBSTITUTE(smfWord(smfWord(RCHGetWebData("
https://www.google.com/finance?q=NKE","rows:",5000),4,"["),11,","),"""",""))
On Wed, Jun 11, 2014 at 1:56 AM, अनन्त: 1998chemie@...wrote:
> How can I get competitors data from this website
> https://www.google.com/finance?q=NKE
> I need ticker and market cap from here
>
=smfWord(RCHGetWebData("https://www.google.com/finance?q=NKE
","rows:",5000),3,"[")
...varying the 3 from 3 to 13. For example, for me, that formula returns:
"NKE","Nike
Inc","NYSE","USD","76.31","-0.36","-0.47","","2.96","25.75","67.23B","0.24","7.45","15.43","24.45","9.83","13.44","chr","25670","NKE"]},{id:"5005244",values:
However, you'll need to extract it out of there. Which data is in each
column is dependent on how you customized the display of data. For me,
ticker symbol and market cap (in thousands) would be:
=SUBSTITUTE(smfWord(smfWord(RCHGetWebData("
https://www.google.com/finance?q=NKE","rows:",5000),4,"["),1,","),"""","")
=smfConvertData(SUBSTITUTE(smfWord(smfWord(RCHGetWebData("
https://www.google.com/finance?q=NKE","rows:",5000),4,"["),11,","),"""",""))
On Wed, Jun 11, 2014 at 1:56 AM, अनन्त: 1998chemie@...wrote:
> How can I get competitors data from this website
> https://www.google.com/finance?q=NKE
> I need ticker and market cap from here
>
Wed Jun 11, 2014 7:14 am (PDT) . Posted by:
"अनन्त:" ritchemie
Hello Randy,
Since I tried the spam spreadsheet BTMA from the group which you now
removed. excel is looking for SMF at different location I am attaching the
error message.
Can you please tell me how to fix this, I did not want to redirect every
time I open excel file.
I really appreciate your help
Aku
Since I tried the spam spreadsheet BTMA from the group which you now
removed. excel is looking for SMF at different location I am attaching the
error message.
Can you please tell me how to fix this, I did not want to redirect every
time I open excel file.
I really appreciate your help
Aku
Attachment(s) from अनन्त:
1 of 1 Photo(s)
Wed Jun 11, 2014 7:23 am (PDT) . Posted by:
"अनन्त:" ritchemie
I removed the add from the computer verified that it gone and added SMF
addin again but whenever I open it, it still looks for the add at
C:\SMF\...
and none of the spreadsheets work now, they show #Name in all the fields.
Man that B\&)(&_(&)( really screwed up my computer with his stupid program
On Wed, Jun 11, 2014 at 10:14 AM, अनन्त: 1998chemie@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> [Attachment(s) <#1468b485453ff098_TopText> from
> =?UTF-8?B?4KSF4KSo4KSo4KWN4KSkOg==?= included below]
>
> Hello Randy,
> Since I tried the spam spreadsheet BTMA from the group which you now
> removed. excel is looking for SMF at different location I am attaching the
> error message.
> Can you please tell me how to fix this, I did not want to redirect every
> time I open excel file.
> I really appreciate your help
> Aku
>
>
>
addin again but whenever I open it, it still looks for the add at
C:\SMF\...
and none of the spreadsheets work now, they show #Name in all the fields.
Man that B\&)(&_(&)( really screwed up my computer with his stupid program
On Wed, Jun 11, 2014 at 10:14 AM, अनन्त: 1998chemie@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> [Attachment(
> =?UTF-8?B?4KSF4KSo4
>
> Hello Randy,
> Since I tried the spam spreadsheet BTMA from the group which you now
> removed. excel is looking for SMF at different location I am attaching the
> error message.
> Can you please tell me how to fix this, I did not want to redirect every
> time I open excel file.
> I really appreciate your help
> Aku
>
>
>
Wed Jun 11, 2014 7:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Any file you saved with the add-in in a different location will need to be
fixed -- once. Then saved.
That's because when you save a workbook, it hard-codes the location of the
add-in.
But once you fix the location and save it, it should be fine the next time
you open it. As long as the add-in location hasn't been saved again.
That's probably why the product moved the add-in -- so you didn't get
errors opening THEIR workbooks, which had been saved with the add-in in the
C:\SMF\ location. As long as they moved the add-in there, their workbooks
would work fine. But everything else you had would need to be "fixed".
On Wed, Jun 11, 2014 at 7:23 AM, अनन्त: 1998chemie... wrote:
>
> I removed the add from the computer verified that it gone and added SMF
> addin again but whenever I open it, it still looks for the add at
> C:\SMF\...
> and none of the spreadsheets work now, they show #Name in all the fields.
> Man that B\&)(&_(&)( really screwed up my computer with his stupid program
>
fixed -- once. Then saved.
That's because when you save a workbook, it hard-codes the location of the
add-in.
But once you fix the location and save it, it should be fine the next time
you open it. As long as the add-in location hasn't been saved again.
That's probably why the product moved the add-in -- so you didn't get
errors opening THEIR workbooks, which had been saved with the add-in in the
C:\SMF&#
would work fine. But everything else you had would need to be "fixed"
On Wed, Jun 11, 2014 at 7:23 AM, अनन्त: 1998chemie..
>
> I removed the add from the computer verified that it gone and added SMF
> addin again but whenever I open it, it still looks for the add at
> C:\SMF&#
> and none of the spreadsheets work now, they show #Name in all the fields.
> Man that B\&)(&_(
>
Wed Jun 11, 2014 12:29 pm (PDT) . Posted by:
friedman_steve
Thanks.. the suggestion does seem to work..... frees up Word.
Although, I do still seem to have some issues. Other version of Excel occasionally can freeze up (waiting for OLE action) when trying to do copy & paste.
Starting to think about installing Office 2007 & using that (I believe the issue came about with the Office version, not the Windows version)?
Although, I do still seem to have some issues. Other version of Excel occasionally can freeze up (waiting for OLE action) when trying to do copy & paste.
Starting to think about installing Office 2007 & using that (I believe the issue came about with the Office version, not the Windows version)?
Wed Jun 11, 2014 1:25 pm (PDT) . Posted by:
"John McCorkle" johnmccorkle13
I am new to using the smf_addin but my 'error' message has stumped a frequent smf_addin user. Details are below. Any help would be greatly appreciated.
-The specific function(s) or template(s) you are having problems with:
=RCHGetElementNumber("MMM",13863) receives 'error' message
-The version of EXCEL you use:
Office 2013 Suite
-The operating system you're running EXCEL under:
Windows 8.1 Pro
Formulas:
1 =RCHGetElementNumber("MMM",13863)
2 =RCHGetElementNumber("Version")
3 =smfGetAParms(13863)
4 =smfstrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title"),"Summary for ","-")
5 =smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title")
Results:
1 Error
2 Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Program Files\SMF Add-In; ; 1)
3 YahooKS;Company Name;http://finance.yahoo.com/q/ks?s=~~~~~;?;;;;;;;;0
4 3M Company Common Stock
5 MMM: Summary for 3M Company Common Stock- Yahoo! Finance
Thanks,
-John
-The specific function(s) or template(s) you are having problems with:
=RCHGetElementNumber("MMM",13863) receives 'error' message
-The version of EXCEL you use:
Office 2013 Suite
-The operating system you're running EXCEL under:
Windows 8.1 Pro
Formulas:
1 =RCHGetElementNumber("MMM",13863)
2 =RCHGetElementNumber("Version")
3 =smfGetAParms(13863)
4 =smfstrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title"),"Summary for ","-")
5 =smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title")
Results:
1 Error
2 Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Program Files\SMF Add-In; ; 1)
3 YahooKS;Company Name;http://finance.yahoo.com/q/ks?s=~~~~~;?;;;;;;;;0
4 3M Company Common Stock
5 MMM: Summary for 3M Company Common Stock- Yahoo! Finance
Thanks,
-John
Wed Jun 11, 2014 1:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You just need to update your element definitions, if not the add-in itself.
When I do:
=smfGetAParms(13863)
...I get the current definition of:
Yahoo;Company Name;=smfStrExtr(smfGetTagContent("
http://finance.yahoo.com/q?s=~~~~~","title"),"Summary for ","-")
The "?" in yours used to invoke special VBA code to do the extraction. It
was necessary before I could use formulas like the above in an element
definition. So, last time an update was needed, I used the new element
definition instead of updating the VBA code. Actually, I think the VBA code
is now gone.
On Wed, Jun 11, 2014 at 12:32 PM, John McCorkle johnmccorkle13@... wrote:
>
> I am new to using the smf_addin but my 'error' message has stumped a
> frequent smf_addin user. Details are below. Any help would be greatly
> appreciated.
>
> -The specific function(s) or template(s) you are having problems with:
> =RCHGetElementNumber("MMM",13863) receives 'error' message
> -The version of EXCEL you use:
> Office 2013 Suite
> -The operating system you're running EXCEL under:
> Windows 8.1 Pro
>
> Formulas:
> 1 =RCHGetElementNumber("MMM",13863)
> 2 =RCHGetElementNumber("Version")
> 3 =smfGetAParms(13863)
> 4 =smfstrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title"),"Summary
> for ","-")
> 5 =smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title")
>
> Results:
> 1 Error
> 2 Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Program
> Files\SMF Add-In; ; 1)
> 3 YahooKS;Company Name;http://finance.yahoo.com/q/ks?s=~~~~~;?;;;;;;;;0
> 4 3M Company Common Stock
> 5 MMM: Summary for 3M Company Common Stock- Yahoo! Finance
>
>
When I do:
=smfGetAParms(13863)
...I get the current definition of:
Yahoo;Company Name;=smfStrExtr(smfGetTagContent("
http://finance.yahoo.com/q?s=~~~~~","title"),"Summary for ","-")
The "?" in yours used to invoke special VBA code to do the extraction. It
was necessary before I could use formulas like the above in an element
definition. So, last time an update was needed, I used the new element
definition instead of updating the VBA code. Actually, I think the VBA code
is now gone.
On Wed, Jun 11, 2014 at 12:32 PM, John McCorkle johnmccorkle13@... wrote:
>
> I am new to using the smf_addin but my 'error' message has stumped a
> frequent smf_addin user. Details are below. Any help would be greatly
> appreciated.
>
> -The specific function(s) or template(s) you are having problems with:
> =RCHGetElementNumber("MMM",13863) receives 'error' message
> -The version of EXCEL you use:
> Office 2013 Suite
> -The operating system you're running EXCEL under:
> Windows 8.1 Pro
>
> Formulas:
> 1 =RCHGetElementNumber("MMM",13863)
> 2 =RCHGetElementNumber("Version")
> 3 =smfGetAParms(13863)
> 4 =smfstrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title"),"Summary
> for ","-")
> 5 =smfGetTagContent("http://finance.yahoo.com/q?s=MMM","title")
>
> Results:
> 1 Error
> 2 Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\Program
> Files\SMF Add-In; ; 1)
> 3 YahooKS;Company Name;http://finance.yahoo.com/q/ks?s=~~~~~;?;;;;;;;;0
> 4 3M Company Common Stock
> 5 MMM: Summary for 3M Company Common Stock- Yahoo! Finance
>
>
Tidak ada komentar:
Posting Komentar