Messages In This Digest (9 Messages)
- 1a.
- New SMF add-in sample From: calderadvisor
- 1b.
- Re: New SMF add-in sample From: Ashish Mukerji
- 1c.
- Re: New SMF add-in sample From: Randy Harmelink
- 1d.
- Re: New SMF add-in sample From: Randy H
- 1e.
- Re: New SMF add-in sample From: calderadvisor
- 1f.
- Re: New SMF add-in sample From: V. Shankar
- 2.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 2.2.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 3a.
- Re: Help needed on Excel 2010 and Add ins From: James Shirley
Messages
- 1a.
-
New SMF add-in sample
Posted by: "calderadvisor" calderadvisor@yahoo.com calderadvisor
Thu Mar 1, 2012 9:42 am (PST)
After banging my head against the SMF samples in "files" section for a few weeks; I finally built a simple yahoo Naz 100 template.
If anyone is interested-tell me how to upload the file and I am happy to share.
I finally figured out why Randy created this SMF Add-in; it is way faster than other query forms and much simpler to "program."
I guess you can teach an old "fart," er, "dog" new tricks.
Thanks Randy for the great work.
Sincerely,
Charles
- 1b.
-
Re: New SMF add-in sample
Posted by: "Ashish Mukerji" ashishkm@yahoo.com ashishkm
Thu Mar 1, 2012 10:01 am (PST)
appreciate your work and effort .... i certainly would like to learn from your Naz 100 template ... thx. in advance ..
Ashish
>____________________ _________ ___
> From: calderadvisor <calderadvisor@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, March 1, 2012 12:42 PM
>Subject: [smf_addin] New SMF add-in sample
>
>
>
>After banging my head against the SMF samples in "files" section for a few weeks; I finally built a simple yahoo Naz 100 template.
>
>If anyone is interested-tell me how to upload the file and I am happy to share.
>
>I finally figured out why Randy created this SMF Add-in; it is way faster than other query forms and much simpler to "program."
>
>I guess you can teach an old "fart," er, "dog" new tricks.
>
>Thanks Randy for the great work.
>
>Sincerely,
>
>Charles
>
>
>
>
> - 1c.
-
Re: New SMF add-in sample
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Mar 1, 2012 12:14 pm (PST)
Here's the Yahoo Help page on uploading files:
http://help.yahoo.com/ kb/index? locale=en_ US&page=content& y=PROD_GRPS& id=SLN2589& impressions= true
Just put it in the "Uploads by Members" folder.
I started writing the first add-in function because I was frustrated with
EXCEL Web Queries. Too much data, improperly formatted, and you still
needed a process to extract the data after it was imported. And, with EXCEL
2002, I had a lot of EXCEL crashes with queries -- I suspect memory
problems.
On Thu, Mar 1, 2012 at 10:42 AM, calderadvisor <calderadvisor@yahoo.com >wrote:
> After banging my head against the SMF samples in "files" section for a few
> weeks; I finally built a simple yahoo Naz 100 template.
>
> If anyone is interested-tell me how to upload the file and I am happy to
> share.
>
> I finally figured out why Randy created this SMF Add-in; it is way faster
> than other query forms and much simpler to "program."
>
> I guess you can teach an old "fart," er, "dog" new tricks.
>
> Thanks Randy for the great work.
>
- 1d.
-
Re: New SMF add-in sample
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Thu Mar 1, 2012 1:12 pm (PST)
Sorry, but I'm going to delete your file. Every person that opens it is
going to be accessing the Internet well over 3000 times to refresh the
data, which takes several minutes. You should be using the
RCHGetYahooHistory() function, which would only need one access per
ticker symbol.
That cuts the refresh time down to about 13 seconds.
--- In smf_addin@yahoogroups.com , "calderadvisor" <calderadvisor@...>
wrote:
>
> If anyone is interested-tell me how to upload the file and I am happy
to share.
>
> I finally figured out why Randy created this SMF Add-in; it is way
faster than other query forms and much simpler to "program."
- 1e.
-
Re: New SMF add-in sample
Posted by: "calderadvisor" calderadvisor@yahoo.com calderadvisor
Thu Mar 1, 2012 8:57 pm (PST)
Okay-
I'll keep trying to make it better.
Thanks,
Charles
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> Sorry, but I'm going to delete your file. Every person that opens it is
> going to be accessing the Internet well over 3000 times to refresh the
> data, which takes several minutes. You should be using the
> RCHGetYahooHistory() function, which would only need one access per
> ticker symbol.
>
> That cuts the refresh time down to about 13 seconds.
>
> --- In smf_addin@yahoogroups.com , "calderadvisor" <calderadvisor@>
> wrote:
> >
> > If anyone is interested-tell me how to upload the file and I am happy
> to share.
> >
> > I finally figured out why Randy created this SMF Add-in; it is way
> faster than other query forms and much simpler to "program."
>
- 1f.
-
Re: New SMF add-in sample
Posted by: "V. Shankar" tarakayan@yahoo.com tarakayan
Fri Mar 2, 2012 1:43 am (PST)
I have a simple one page dashboard showing 52w l&h graph, ms sector/style for one stock symbol at a time. I can upload if anyone would be interested. The only issue is I use Zack's 600 stock eps details as a look up reference which needs to be downloaded and saved separately.
>____________________ _________ ___
> From: Randy H <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, March 2, 2012 2:42 AM
>Subject: [smf_addin] Re: New SMF add-in sample
>
>
>
>Sorry, but I'm going to delete your file. Every person that opens it is
>going to be accessing the Internet well over 3000 times to refresh the
>data, which takes several minutes. You should be using the
>RCHGetYahooHistory() function, which would only need one access per
>ticker symbol.
>
>That cuts the refresh time down to about 13 seconds.
>
>--- In smf_addin@yahoogroups.com , "calderadvisor" <calderadvisor@...>
>wrote:
>>
>> If anyone is interested-tell me how to upload the file and I am happy
>to share.
>>
>> I finally figured out why Randy created this SMF Add-in; it is way
>faster than other query forms and much simpler to "program."
>
>
>
>
>
- 2.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Thu Mar 1, 2012 12:47 pm (PST)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Naz SMF test.xlsm
Uploaded by : calderadvisor <calderadvisor@yahoo.com >
Description : NAZ 100 SMF sample Template
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/Naz%20SMF% 20test.xlsm
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
calderadvisor <calderadvisor@yahoo.com >
- 2.2.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Thu Mar 1, 2012 1:13 pm (PST)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Naz SMF test.xls
Uploaded by : rharmelink <rharmelink@gmail.com >
Description : NAZ 100 SMF sample Template
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/Naz%20SMF% 20test.xls
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
rharmelink <rharmelink@gmail.com >
- 3a.
-
Re: Help needed on Excel 2010 and Add ins
Posted by: "James Shirley" jimbo91363@yahoo.com jimbo91363
Thu Mar 1, 2012 8:13 pm (PST)
Randy... you gonna love this.... Opened new workbook.. Your manual change advice... copied the one sheet from the old workbook created with the "SMF addins"directory to the new workbook which opened with the "SMF addin" directory.. made a few manual changes. saved. reopened and Bammm every formula fixed itself. Not even a cut and paste. Was so frustrating before ... now all is well. we will see how it opens in the morning.
whew. I am so happy. Key-- was I had to get away from that old workbook.
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Tuesday, February 28, 2012 2:38 PM
Subject: Re: [smf_addin] Help needed on Excel 2010 and Add ins
Take a look in the "Links" area of the group -- there is an item on location errors and the #NAME? problem.
When you move the add-in to a new location, ALL workbooks that used the old location are going to have to be manually fixed. Because of how EXCEL handles add-ins, your formulas will NOT automatically change to the new location you have the add-in in. As far as EXCEL is concerned, that is a different add-in, because it's in a different location.
You can try running the smfFixLinks macro -- I use it to fix location errors when I have them.
On Tue, Feb 28, 2012 at 9:40 AM, James Shirley <jimbo91363@yahoo.com > wrote:
Summary: Problem with getting (1) excel to delete permanently the old "Add in" directory; (2) excel not recognizing the functions once the "Add in" directory is correctly readded. I am having to redue this every time excel starts.
>
>I originally set up the Directory in "SMF Add_ins" then realized it should have been SMF Add_in. Installed as instucted to the Add ins via a blank Excel workbook. Problem: Excel realizes that it the files can not be found because I (deleted, rename, moved). So I have since re-added the SMF Add_in to the Add ins list of which Excel asks me to delete the prior that it cannot find "SMF Add_ins". I do. So, now it finds the functions but they do not calulate. I get the NAME error. I see the functions are in the formulas list. I am using the =smfGetOptionsQuotes() function. In the cell I can remove the "s" off =smfGetOptionsQuote s() to get =smfGetOptionsQuote (), save to cell, recalculates gives VALUE error. I add the "s" back to the function =smfGetOptionsQuote s() it produces a value. This function performs as expected..
>
>I feel like I should be able to delete forever in excel the old Add_in directory. Readd properly. Then when the spreadsheet come up it should calcuate based of the current data being read. Neither is happening. I need some guidance.
>
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