Messages In This Digest (25 Messages)
- 1a.
- Latest Version From: rjemery7
- 1b.
- Re: Latest Version From: Randy Harmelink
- 1c.
- Re: Latest Version From: rjemery7
- 1d.
- Re: Latest Version From: Mike McQuaid
- 1e.
- Re: Latest 2.1 Documentation From: rjemery7
- 1f.
- Re: Latest 2.1 Documentation From: Randy Harmelink
- 2a.
- Retrieving S&P Information From: rjemery7
- 2b.
- Re: Retrieving S&P Information From: Randy Harmelink
- 2c.
- Re: Retrieving S&P Information From: rjemery7
- 2d.
- Re: Retrieving S&P Information From: Martin Topper
- 3a.
- More Retrieval Questions From: rjemery7
- 3b.
- Re: More Retrieval Questions From: Randy Harmelink
- 3c.
- Re: More Retrieval Questions From: rjemery7
- 3d.
- Re: More Retrieval Questions From: Randy Harmelink
- 4a.
- Bloomberg From: bushpilote@yahoo.ca
- 4b.
- Re: Bloomberg From: Mike McQuaid
- 4c.
- Re: Bloomberg From: Randy Harmelink
- 4d.
- RCH_Stock_Market_Functions.xla From: umesh parab
- 4e.
- Re: RCH_Stock_Market_Functions.xla From: Randy Harmelink
- 4f.
- Re: RCH_Stock_Market_Functions.xla From: umesh parab
- 4g.
- Re: RCH_Stock_Market_Functions.xla From: Randy Harmelink
- 5a.
- Re: Google Docs version of Company Overview From: Pete A
- 5b.
- Re: Google Docs version of Company Overview From: Mike McQuaid
- 5c.
- Re: Google Docs version of Company Overview From: ronmac17
- 6a.
- Re: Getting Dates for the 52-Week High and Low From: rjemery7
Messages
- 1a.
-
Latest Version
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 4:34 am (PST)
I've been away from SMF for two years. Have there been updates within that time that I should know about? If so, how and where do I obtain the latest version for inclusion into Excel 2007?
- 1b.
-
Re: Latest Version
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 5:38 am (PST)
The latest version was just released earlier this month. It's in the
"Add-in Files" folder of the files area. Exit EXCEL, extract all the files
from the ZIP archive into your add-in folder, replacing all files as
needed, and then restart EXCEL. You should have the new version loaded at
that point. You can check the version you have loaded with:
=RCHGetElementNumber("Version" )
On Wed, Feb 15, 2012 at 5:34 AM, rjemery7 <rjemery@gmail.com > wrote:
> I've been away from SMF for two years. Have there been updates within
> that time that I should know about? If so, how and where do I obtain the
> latest version for inclusion into Excel 2007?
>
- 1c.
-
Re: Latest Version
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 7:51 am (PST)
1) Is there a corresponding PDF document package for that update?
2) A list of what's new in version 2.1?
If yes, for where obtainable? Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The latest version was just released earlier this month. It's in the
> "Add-in Files" folder of the files area. Exit EXCEL, extract all the files
> from the ZIP archive into your add-in folder, replacing all files as
> needed, and then restart EXCEL. You should have the new version loaded at
> that point. You can check the version you have loaded with:
>
> =RCHGetElementNumber("Version" )
>
> On Wed, Feb 15, 2012 at 5:34 AM, rjemery7 <rjemery@...> wrote:
>
> > I've been away from SMF for two years. Have there been updates within
> > that time that I should know about? If so, how and where do I obtain the
> > latest version for inclusion into Excel 2007?
> >
>
- 1d.
-
Re: Latest Version
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Wed Feb 15, 2012 7:55 am (PST)
Docs are in:
http://finance.groups.yahoo. com/group/ smf_addin/ files/Documentat ion/
If you just looked around the Yahoo group a bit you'd likely find what you
need:
http://finance.groups.yahoo. com/group/ smf_addin/
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of rjemery7
Sent: Wednesday, February 15, 2012 10:51 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Latest Version
1) Is there a corresponding PDF document package for that update?
2) A list of what's new in version 2.1?
If yes, for where obtainable? Thanks.
--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> The latest version was just released earlier this month. It's in the
> "Add-in Files" folder of the files area. Exit EXCEL, extract all the files
> from the ZIP archive into your add-in folder, replacing all files as
> needed, and then restart EXCEL. You should have the new version loaded at
> that point. You can check the version you have loaded with:
>
> =RCHGetElementNumber("Version" )
>
> On Wed, Feb 15, 2012 at 5:34 AM, rjemery7 <rjemery@...> wrote:
>
> > I've been away from SMF for two years. Have there been updates within
> > that time that I should know about? If so, how and where do I obtain the
> > latest version for inclusion into Excel 2007?
> >
>
- 1e.
-
Re: Latest 2.1 Documentation
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 8:49 am (PST)
Does the following link correspond to the latest documentation for 2.1? I note that it predates the release of 2.1 by about one month:
http://f1.grp.yahoofs.com/ v1/gNY7T9a9JiXai 5WHI8YKGjO_ Xsrmi3z_3Fg_ n_ElrW0AXC78TzZG amwDdPdxOiQ42G8J ym56Ov-dk7C3a40X hGlcnS7gqmc/ Documentation/ SMF-Addin- Combined- Documentation- 010212_N. pdf
--- In smf_addin@yahoogroups.com , "Mike McQuaid" <mikemcq802@...> wrote:
>
> Docs are in:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ files/Documentat ion/
>
- 1f.
-
Re: Latest 2.1 Documentation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 10:13 am (PST)
No. I don't create that. I only maintain the individual HTML files.
On Wed, Feb 15, 2012 at 9:49 AM, rjemery7 <rjemery@gmail.com > wrote:
> Does the following link correspond to the latest documentation for 2.1? I
> note that it predates the release of 2.1 by about one month:
>
>
> http://f1.grp.yahoofs.com/ v1/gNY7T9a9JiXai 5WHI8YKGjO_ Xsrmi3z_3Fg_ n_ElrW0AXC78TzZG amwDdPdxOiQ42G8J ym56Ov-dk7C3a40X hGlcnS7gqmc/ Documentation/ SMF-Addin- Combined- Documentation- 010212_N. pdf
>
- 2a.
-
Retrieving S&P Information
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 5:10 am (PST)
For a given ticker symbol, how would I obtain the following S&P information, if at all possible:
S&P Sector
S&P Industry
S&P Sub-Industry
S&P STARS Rating
S&P Earnings & Dividend Ranking (a letter grade, sometimes with a +/- suffix, such as A, B+, C- or NR)
Additionally, how would I retrieve
Beta
- 2b.
-
Re: Retrieving S&P Information
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 5:40 am (PST)
First, you'd need a source of the data items. Those are proprietary, so I
don't have a source that I can use.
And you'd need to define Beta -- different data sources compute different
values of Beta.
On Wed, Feb 15, 2012 at 6:10 AM, rjemery7 <rjemery@gmail.com > wrote:
> For a given ticker symbol, how would I obtain the following S&P
> information, if at all possible:
>
> S&P Sector
> S&P Industry
> S&P Sub-Industry
> S&P STARS Rating
> S&P Earnings & Dividend Ranking (a letter grade, sometimes with a +/-
> suffix, such as A, B+, C- or NR)
>
> Additionally, how would I retrieve
> Beta
>
- 2c.
-
Re: Retrieving S&P Information
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 11:50 am (PST)
I can obtain that information behind password protected brokerage accounts, then export it as a CSV file. From there I think I can use the smfGetCSVFile function to retrieve the necessary data.
If there is a easier way, please advise.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> First, you'd need a source of the data items. Those are proprietary, so I
> don't have a source that I can use.
>
> And you'd need to define Beta -- different data sources compute different
> values of Beta.
>
> On Wed, Feb 15, 2012 at 6:10 AM, rjemery7 <rjemery@...> wrote:
>
> > For a given ticker symbol, how would I obtain the following S&P
> > information, if at all possible:
> >
> > S&P Sector
> > S&P Industry
> > S&P Sub-Industry
> > S&P STARS Rating
> > S&P Earnings & Dividend Ranking (a letter grade, sometimes with a +/-
> > suffix, such as A, B+, C- or NR)
> >
> > Additionally, how would I retrieve
> > Beta
> >
>
- 2d.
-
Re: Retrieving S&P Information
Posted by: "Martin Topper" mtopper@yahoo.com mtopper
Wed Feb 15, 2012 11:53 am (PST)
If you already have a CSV file what would you use the addin to do?
_____________________ _________ __
From: rjemery7 <rjemery@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 15, 2012 2:50 PM
Subject: [smf_addin] Re: Retrieving S&P Information
I can obtain that information behind password protected brokerage accounts, then export it as a CSV file. From there I think I can use the smfGetCSVFile function to retrieve the necessary data.
If there is a easier way, please advise.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> First, you'd need a source of the data items. Those are proprietary, so I
> don't have a source that I can use.
>
> And you'd need to define Beta -- different data sources compute different
> values of Beta.
>
> On Wed, Feb 15, 2012 at 6:10 AM, rjemery7 <rjemery@...> wrote:
>
> > For a given ticker symbol, how would I obtain the following S&P
> > information, if at all possible:
> >
> > S&P Sector
> > S&P Industry
> > S&P Sub-Industry
> > S&P STARS Rating
> > S&P Earnings & Dividend Ranking (a letter grade, sometimes with a +/-
> > suffix, such as A, B+, C- or NR)
> >
> > Additionally, how would I retrieve
> > Beta
> >
>
- 3a.
-
More Retrieval Questions
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 5:34 am (PST)
For a given ticker symbol, how would I obtain the Dividend Payout Ratio (MRQ)?
Also, how do I retrieve the date of the last 52-Week High and Low?
Note: SMF is a great product. Glad you created it and continue to support it.
- 3b.
-
Re: More Retrieval Questions
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 5:43 am (PST)
Check the element list for payout ratio -- I think there are a few.
52-week high and low can be retrieved from barchart.com -- check a few of
the templates. FinViz might be a good source -- check the "Links" area of
the group.
On Wed, Feb 15, 2012 at 6:34 AM, rjemery7 <rjemery@gmail.com > wrote:
> For a given ticker symbol, how would I obtain the Dividend Payout Ratio
> (MRQ)?
>
> Also, how do I retrieve the date of the last 52-Week High and Low?
>
- 3c.
-
Re: More Retrieval Questions
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 11:47 am (PST)
Where do I find the element list and its contents? A search of the documentation uncovered nothing with the keyword 'payout'.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Check the element list for payout ratio -- I think there are a few.
>
- 3d.
-
Re: More Retrieval Questions
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 11:54 am (PST)
It's the XLS file that is in the ZIP archives that contained the add-in.
On Wed, Feb 15, 2012 at 12:47 PM, rjemery7 <rjemery@gmail.com > wrote:
> Where do I find the element list and its contents? A search of the
> documentation uncovered nothing with the keyword 'payout'.
>
- 4a.
-
Bloomberg
Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca bushpilote
Wed Feb 15, 2012 8:44 am (PST)
Hi Randy,
I'm stuck in extracting ">Year To Date:<" and ">1-Year:<" data from the following site: http://www.bloomberg.com/quote/ CRY:IND.
I've tried getting the data by using variations of the formulas listed below, which I found on your message board, with no success.
"=smfStrExtr("|"&smfGetTagCon tent("http://www.bloomber g.com/apps/ ","h1",1,"id=quote?ticker= CRY:IND ""company_ info"""), "|","<");
"=RCHGetTableCell("http://www.bloomber g.com/apps/ ",1,">open"quote?ticker= CRY:IND
Any suggestions on how to resove this?
Thanks and Regards.
- 4b.
-
Re: Bloomberg
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Wed Feb 15, 2012 8:57 am (PST)
the GetTagContent you show below is no longer valid for that page.
For Year to Date use:
=smfGetTagContent("http://www.bloomber g.com/quote/ ","TD",1,"CRY:IND
<http://www.bloomberg.com/quote/ > >Year to Date:")CRY:IND
For 1-year use:
=smfGetTagContent("http://www.bloomber g.com/quote/ ","TD",1,"CRY:IND
<http://www.bloomberg.com/quote/ > >1-Year:")CRY:IND
If you view the html source for the webpage the search terms should be
readily visible.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of bushpilote@yahoo.ca
Sent: Wednesday, February 15, 2012 11:44 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Bloomberg
Hi Randy,
I'm stuck in extracting ">Year To Date:<" and ">1-Year:<" data from the
following site: http://www.bloomberg.com/quote/ CRY:IND.
I've tried getting the data by using variations of the formulas listed
below, which I found on your message board, with no success.
"=smfStrExtr("|"&smfGetTagCon tent("http://www.bloomber g.com/apps/ quote?ticke
r=CRY:IND","h1",1,"id= ""company_ info"""), "|","<");
"=RCHGetTableCell("http://www.bloomber g.com/apps/ ",1,">oquote?ticker= CRY:IND
pen"
Any suggestions on how to resove this?
Thanks and Regards.
- 4c.
-
Re: Bloomberg
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 10:16 am (PST)
Try:
=RCHGetTableCell("http://www.bloomber g.com/quote/ ",1,"Year to date:")CRY:IND
=RCHGetTableCell("http://www.bloomber g.com/quote/ ",1,"1-Year:CRY:IND ")
Usually, the semi-colon is sufficient to make it unique. The ">" and "<"
strings were not abutted to the descriptions, so they wouldn't have worked
in this case. You really do need to look at the source code to verify what
it has...
On Wed, Feb 15, 2012 at 9:44 AM, <bushpilote@yahoo.ca > wrote:
> Hi Randy,
> I'm stuck in extracting ">Year To Date:<" and ">1-Year:<" data from the
> following site: http://www.bloomberg.com/quote/ CRY:IND.
>
> I've tried getting the data by using variations of the formulas listed
> below, which I found on your message board, with no success.
>
> "=smfStrExtr("|"&smfGetTagCon tent("
> http://www.bloomberg.com/apps/ quote?ticker= CRY:IND
> ","h1",1,"id=""company_ info"""), "|","<");
>
> "=RCHGetTableCell("http://www.bloomber g.com/apps/ quote?ticker= CRY:IND
> ",1,">open"
>
> Any suggestions on how to resove this?
>
- 4d.
-
RCH_Stock_Market_Functions.xla
Posted by: "umesh parab" umeshlp@yahoo.com umeshlp
Wed Feb 15, 2012 11:04 am (PST)
I am trying to get 'RCH_Stock_Market_Functions. xla' in excel add-in. How to do it?
I maintained this file in folder 'C:\Program Files\SMF Add-In', also in 'C:\SMF' folder but I can not see in excel option - Add-in (not in Active application nor in In-active application add-in.)
- 4e.
-
Re: RCH_Stock_Market_Functions.xla
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 11:05 am (PST)
You need to install it via the add-in manager, as per the documentation.
On Wed, Feb 15, 2012 at 12:03 PM, umesh parab <umeshlp@yahoo.com > wrote:
>
> I am trying to get 'RCH_Stock_Market_Functions. xla' in excel add-in. How
> to do it?
>
> I maintained this file in folder 'C:\Program Files\SMF Add-In', also in
> 'C:\SMF' folder but I can not see in excel option - Add-in (not in Active
> application nor in In-active application add-in.)
>
- 4f.
-
Re: RCH_Stock_Market_Functions.xla
Posted by: "umesh parab" umeshlp@yahoo.com umeshlp
Wed Feb 15, 2012 11:10 am (PST)
If you don't mind, can you please tell me which documentation?
--- On Wed, 2/15/12, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] RCH_Stock_Market_Functions. xla
To: smf_addin@yahoogroups.com
Date: Wednesday, February 15, 2012, 7:05 PM
You need to install it via the add-in manager, as per the documentation.
On Wed, Feb 15, 2012 at 12:03 PM, umesh parab <umeshlp@yahoo.com > wrote:
I am trying to get 'RCH_Stock_Market_Functions. xla' in excel add-in. How to do it?
I maintained this file in folder 'C:\Program Files\SMF Add-In', also in 'C:\SMF' folder but I can not see in excel option - Add-in (not in Active application nor in In-active application add-in.)
- 4g.
-
Re: RCH_Stock_Market_Functions.xla
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Feb 15, 2012 11:12 am (PST)
The very first item in the "Documentation" folder:
1.0 - Overview.html
Installation notes and an overview of major functions available in the
add-in
On Wed, Feb 15, 2012 at 12:09 PM, umesh parab <umeshlp@yahoo.com > wrote:
>
> If you don't mind, can you please tell me which documentation?
>
- 5a.
-
Re: Google Docs version of Company Overview
Posted by: "Pete A" optionzz@gmail.com option2z
Wed Feb 15, 2012 9:00 am (PST)
Thanks for a fascinating experiment and nice blog post.
That said, I personally would NOT put my serious data in the hands of Google (or anyone who claims the right to use my data as they please). "Free" might feel that way, but they must make their money somehow. I'd rather pay for quality software from which I control access. Google has recently announced major changes to their privacy rules...not so good in my view. My own paranoia I'm sure. Thanks for sharing your experience. Fascinating.
When i ran the google sheet, it was all in cuniform...didn't get far enough to do the setup sheet thing you discussed in your blog post.
Pete A
--- In smf_addin@yahoogroups.com , "bobsledproductions" <JPeters3515@ ...> wrote:
>
> Previously I created a Company Overview worksheet leveraging the addin, that is in the "files" section, but recently I was curious to know how far Google Docs has come, and whether the same type of workbook could be created in the Spreadsheet app. So I spent about 3-4 hours the other day, and got pretty close. If you are interested, take a look at the Company Overview spreadsheet that I created and published here:
>
> https://docs.google.com/ templates? q=company+ overview& category= 2&type=spreadshe ets&sort= rating&view= public
>
> I also put together a blog that detailed the steps here and how it was done (a little rough, but hopefully you get the point):
>
> http://justspreadsheets.blogspot. com/2012/ 02/company- overview- google-docs- version.html
>
> I know this doesn't exactly fit within Randy's group, so apologies if you view this as spam, not my intention. But, from my perspective if something similar to the addin could be built and delivered through a fully hosted solution like google docs, with nothing required to be installed on your desktop, and work on say mobile devices, and be localized, it could be quite powerful and useful.
>
> At this point in time, I'm far from convinced that I would ever replace Excel with Google docs, but....there is something compelling about a no cost, no download, device independent solution.
>
> Anyways, let me know your thoughts.....
>
- 5b.
-
Re: Google Docs version of Company Overview
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Wed Feb 15, 2012 9:11 am (PST)
I share the same concerns as Pete A about privacy.
Regarding the language I had a similar problem as Pete. Initially all the
characters were Asian (double-byte) characters.
I clicked on the Setup tab on the bottom of the page and saw the Language
was set to Zhongwen. I'm not fluent in that so selected English and all was
well. Just click cell C2 and you'll get a dropdown list of supported
languages.
I agree it was a very interesting exercise - thanks J Peters.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Pete A
Sent: Wednesday, February 15, 2012 12:01 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Google Docs version of Company Overview
Thanks for a fascinating experiment and nice blog post.
That said, I personally would NOT put my serious data in the hands of Google
(or anyone who claims the right to use my data as they please). "Free" might
feel that way, but they must make their money somehow. I'd rather pay for
quality software from which I control access. Google has recently announced
major changes to their privacy rules...not so good in my view. My own
paranoia I'm sure. Thanks for sharing your experience. Fascinating.
When i ran the google sheet, it was all in cuniform...didn't get far enough
to do the setup sheet thing you discussed in your blog post.
Pete A
--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ,
"bobsledproductions" <JPeters3515@ ...> wrote:
>
> Previously I created a Company Overview worksheet leveraging the addin,
that is in the "files" section, but recently I was curious to know how far
Google Docs has come, and whether the same type of workbook could be created
in the Spreadsheet app. So I spent about 3-4 hours the other day, and got
pretty close. If you are interested, take a look at the Company Overview
spreadsheet that I created and published here:
>
> https://docs.google.com/ templates? q=company+ overview
<https://docs.google.com/ templates? q=company+ overview& category= 2&type=spread
sheets&sort=rating&view= public>
&category=2&type=spreadsheet s&sort=rating& view=public
>
> I also put together a blog that detailed the steps here and how it was
done (a little rough, but hopefully you get the point):
>
>
http://justspreadsheets.blogspot. com/2012/ 02/company- overview- google-docs- ve
rsion.html
>
> I know this doesn't exactly fit within Randy's group, so apologies if you
view this as spam, not my intention. But, from my perspective if something
similar to the addin could be built and delivered through a fully hosted
solution like google docs, with nothing required to be installed on your
desktop, and work on say mobile devices, and be localized, it could be quite
powerful and useful.
>
> At this point in time, I'm far from convinced that I would ever replace
Excel with Google docs, but....there is something compelling about a no
cost, no download, device independent solution.
>
> Anyways, let me know your thoughts.....
>
- 5c.
-
Re: Google Docs version of Company Overview
Posted by: "ronmac17" ronmac17@yahoo.com ronmac17
Wed Feb 15, 2012 10:10 am (PST)
This guy put his addins in DropBox. Haven't tried this myself but it looks interesting.
http://excelmonkeys.com/a/28
"Dropbox can't currently sync different folders, only items in your "My Dropbox" folder. Since I can't have Dropbox sync my addins folder I'll just have to move my addins folder. Excel won't let you set a different folder to be your addins folder so I had to resort to some VBA."
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> At one point, my "Internet version" vision was to have a URL that could
> create the equivalent of an SSG file. Then, no matter which spreadsheet
> tool was used, all of the data would be available in a fixed location.
>
> The problem is coming up with a file definition that has all data elements
> defined.
>
> Another option would be to create some form of XML file. Then, the tags can
> be defined as needed, and the data is available to anything that wants to
> use it.
>
> In any case, the point would be to separate the tool from the data -- make
> the data easily available independently of what is using the data.
>
> On Tue, Feb 14, 2012 at 7:44 PM, bobsledproductions <JPeters3515@...>wrote:
>
> > Previously I created a Company Overview worksheet leveraging the addin,
> > that is in the "files" section, but recently I was curious to know how far
> > Google Docs has come, and whether the same type of workbook could be
> > created in the Spreadsheet app. So I spent about 3-4 hours the other day,
> > and got pretty close. If you are interested, take a look at the Company
> > Overview spreadsheet that I created and published here:
> >
> >
> > https://docs.google.com/ templates? q=company+ overview& category= 2&type=spreadshe ets&sort= rating&view= public
> >
> > I also put together a blog that detailed the steps here and how it was
> > done (a little rough, but hopefully you get the point):
> >
> >
> > http://justspreadsheets.blogspot. com/2012/ 02/company- overview- google-docs- version.html
> >
> > I know this doesn't exactly fit within Randy's group, so apologies if you
> > view this as spam, not my intention. But, from my perspective if something
> > similar to the addin could be built and delivered through a fully hosted
> > solution like google docs, with nothing required to be installed on your
> > desktop, and work on say mobile devices, and be localized, it could be
> > quite powerful and useful.
> >
> > At this point in time, I'm far from convinced that I would ever replace
> > Excel with Google docs, but....there is something compelling about a no
> > cost, no download, device independent solution.
> >
> > Anyways, let me know your thoughts.....
> >
>
- 6a.
-
Re: Getting Dates for the 52-Week High and Low
Posted by: "rjemery7" rjemery@gmail.com rjemery7
Wed Feb 15, 2012 11:41 am (PST)
Works for me. Thanks. I'm beginning to get the hang of SMF again.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> However, you could use the smfPricesBetween() function to get the 52-week
> high and low -- both dates and values.
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar