Messages In This Digest (15 Messages)
- 1a.
- what's the best way? From: grabthecashanddash
- 1b.
- Re: what's the best way? From: Randy Harmelink
- 2a.
- Re: Call/Put Spreadsheet From: bobc94595
- 2b.
- Re: Call/Put Spreadsheet From: Sudhir Agarwal
- 2c.
- Re: Call/Put Spreadsheet From: Randy Harmelink
- 2d.
- Re: Call/Put Spreadsheet From: Randy Harmelink
- 3a.
- Re: SMFLite decimal separator issue for Non-US equities From: nuno.nogueira
- 4a.
- Pausing program execution to allow for SMF to fully load From: thomas91112
- 4b.
- Re: Pausing program execution to allow for SMF to fully load From: dguillett1
- 5.
- FWD: From: Pat McConigley
- 6a.
- MSN elements not working anymore From: MikeM
- 6b.
- Re: MSN elements not working anymore From: bleushin19
- 6c.
- Re: MSN elements not working anymore From: Randy Harmelink
- 6d.
- Re: MSN elements not working anymore From: Frank
- 7.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
Messages
- 1a.
-
what's the best way?
Posted by: "grabthecashanddash" drjay001@gmail.com grabthecashanddash
Thu Apr 26, 2012 7:10 am (PDT)
I'd like to download for each stock in the S&P 500 its 5 year history; just date & adjusted close. There might also be an equally sized list of other equities.
Thanx,
Jay
- 1b.
-
Re: what's the best way?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Apr 26, 2012 7:22 am (PDT)
I would say you should use a scanning tool like StockFetcher or AAII's
Stock Investor Pro.
On Thu, Apr 26, 2012 at 7:10 AM, grabthecashanddash <drjay001@gmail.com >wrote:
> I'd like to download for each stock in the S&P 500 its 5 year history;
> just date & adjusted close. There might also be an equally sized list of
> other equities.
>
- 2a.
-
Re: Call/Put Spreadsheet
Posted by: "bobc94595" conlonrc@comcast.net bobc94595
Thu Apr 26, 2012 11:32 am (PDT)
Thanks, Randy.
That seems to work for the the closest month, but it does not seem to work for the months thereafter.
Bob
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just type in the full name: smfForceRecalculation
>
> At that point, the buttons should activate.
>
> On Wed, Apr 25, 2012 at 10:54 PM, bobc94595 <conlonrc@...> wrote:
>
> >
> > Under 9.5, where do I get, or how do I determine the macro name to type
> > into the macro dialog window?
> >
>
- 2b.
-
Re: Call/Put Spreadsheet
Posted by: "Sudhir Agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1
Thu Apr 26, 2012 11:45 am (PDT)
Does someone have a sheet to get Call and Puts for multiple Stocks for
multiple months.
Sudhir
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of bobc94595
Sent: Thursday, April 26, 2012 2:32 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Call/Put Spreadsheet
Thanks, Randy.
That seems to work for the the closest month, but it does not seem to work
for the months thereafter.
Bob
--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> Just type in the full name: smfForceRecalculation
>
> At that point, the buttons should activate.
>
> On Wed, Apr 25, 2012 at 10:54 PM, bobc94595 <conlonrc@...> wrote:
>
> >
> > Under 9.5, where do I get, or how do I determine the macro name to type
> > into the macro dialog window?
> >
>
- 2c.
-
Re: Call/Put Spreadsheet
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Apr 26, 2012 11:58 am (PDT)
It should reset everything. Unless you have IE caching web pages...
On Thu, Apr 26, 2012 at 11:31 AM, bobc94595 <conlonrc@comcast.net > wrote:
>
> That seems to work for the the closest month, but it does not seem to work
> for the months thereafter.
>
> Bob
>
- 2d.
-
Re: Call/Put Spreadsheet
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Apr 26, 2012 11:59 am (PDT)
That type of retrieval is going to be very dependent on what you plan to
use the data for.
Offhand, I would just say to use the smfGetOptionQuotes() function as
needed.
On Thu, Apr 26, 2012 at 11:45 AM, Sudhir Agarwal
<Agarwal.sudhir@gmail.com >wrote:
>
> Does someone have a sheet to get Call and Puts for multiple Stocks for
> multiple months…****
>
> Sudhir
>
- 3a.
-
Re: SMFLite decimal separator issue for Non-US equities
Posted by: "nuno.nogueira" nuno.nogueira35@gmail.com nuno.nogueira
Thu Apr 26, 2012 1:42 pm (PDT)
Thanks, I've checked it but the question is how to change the regional
settings automatically whenever you use SMFLite.
I tried to include a piece of VBA code that works very well in Excel
2007 but in Excel 2010, the decimal separator is kept at "." even after
Excel is closed... I have no idea why it is like this.
If anyone knows how to change the decimal and thousands separator as an
excel event (open) and get it back to normal (close), I'd really
appreciate an explanation.
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> Check out the related items in the "Links" area of the group.
>
> On Sun, Apr 22, 2012 at 10:10 AM, nuno.nogueira
> nuno.nogueira35@...wrote:
>
> >
> > Does anyone know how to fix the problem of the decimal separator of
Non-US
> > Stocks using SMFLite?
> >
> > For example: 36,45 is returning 3645 using function
RCHGetYahooQuotes in
> > SMFLite.
> >
> > I could change the regional settings but then I would need to do it
in
> > every PC.
> >
> > Maybe we could add some code to the existing VBA to fix it?
> >
> > Thanks in advance for any help.
> >
>
- 4a.
-
Pausing program execution to allow for SMF to fully load
Posted by: "thomas91112" thomas91112@yahoo.com thomas91112
Thu Apr 26, 2012 2:29 pm (PDT)
Have a list of stock tickers that a VBA runs down and creates a print table of various stock related data e.g. Ticker, Open, High, Low, etc. Find that the VBA is moving faster than SMF and am getting incorrect data in the print table about 15% of the time. If I go through manually and not utilize the VBA everything is fine. Another reason I think the VBA is moving too fast is when the last entry is done, notice that the pricing data for the last item is still refreshing for a few more seconds.
Is there any way for the VBA to wait or be forced to wait until SMF is done updating each time before moving ahead? Tried using SLEEP but I understand that suspends Excel functioning which is what I don't want because once the updated data posts, want Excel to automatically recalculate the fields.
Thanks
Mike
- 4b.
-
Re: Pausing program execution to allow for SMF to fully load
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Thu Apr 26, 2012 3:11 pm (PDT)
application.enableevents= false
code
reset to true
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@gmail.com
From: thomas91112
Sent: Thursday, April 26, 2012 4:29 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Pausing program execution to allow for SMF to fully load
Have a list of stock tickers that a VBA runs down and creates a print table of various stock related data e.g. Ticker, Open, High, Low, etc. Find that the VBA is moving faster than SMF and am getting incorrect data in the print table about 15% of the time. If I go through manually and not utilize the VBA everything is fine. Another reason I think the VBA is moving too fast is when the last entry is done, notice that the pricing data for the last item is still refreshing for a few more seconds.
Is there any way for the VBA to wait or be forced to wait until SMF is done updating each time before moving ahead? Tried using SLEEP but I understand that suspends Excel functioning which is what I don't want because once the updated data posts, want Excel to automatically recalculate the fields.
Thanks
Mike
- 5.
-
FWD:
Posted by: "Pat McConigley" patmcconigley@yahoo.com patmcconigley
Thu Apr 26, 2012 4:24 pm (PDT)
you should definitely check this thing out http://www.pa15news.net/biz/ ?page=5251808
~*Advertisement
- 6a.
-
MSN elements not working anymore
Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802
Thu Apr 26, 2012 7:18 pm (PDT)
It seems MSN may have reconfigured their site. The element numbers 25 and 46 are not working for any ticker (the only two I tried). If I type the url from the smf-elements-txt file it shows a web page for creating a report but you must select the items you want.
This is the version I am using:
Stock Market Functions add-in, Version 2.1.2012.02.17
This is a sample retrieval that is not working (gets "error").
=RCHGetElementNumber("VFC",25, ,)
Here's the url from the elements file:
http://moneycentral.msn.com/ investor/ research/ sreport.asp? CR=1&AF=1& IH=1&AIE= 1&AIR=1&FRH= 1&FRK=1&ISA= 1&ISQ=1&BSA= 1&BSQ=1&CFA= 1&CFQ=1&TYS= 1&ITT=1&ITP= 1&Type=Equity& Symbol=VFC
Interestingly, this page shows info:
http://investing.money.msn. com/investments/ stock-price? Symbol=vfc& ocid=qbeb
I tried the beta version 2012.04.07 too but that gave same results.
- 6b.
-
Re: MSN elements not working anymore
Posted by: "bleushin19" bleushin19@yahoo.com bleushin19
Thu Apr 26, 2012 10:56 pm (PDT)
--- In smf_addin@yahoogroups.com , "MikeM" <mikemcq802@...> wrote:
>
> It seems MSN may have reconfigured their site. The element numbers 25 and 46 are not working for any ticker (the only two I tried). If I type the url from the smf-elements-txt file it shows a web page for creating a report but you must select the items you want.
>
> This is the version I am using:
> Stock Market Functions add-in, Version 2.1.2012.02.17
>
> This is a sample retrieval that is not working (gets "error").
> =RCHGetElementNumber("VFC",25, ,)
>
> Here's the url from the elements file:
> http://moneycentral.msn.com/ investor/ research/ sreport.asp? CR=1&AF=1& IH=1&AIE= 1&AIR=1&FRH= 1&FRK=1&ISA= 1&ISQ=1&BSA= 1&BSQ=1&CFA= 1&CFQ=1&TYS= 1&ITT=1&ITP= 1&Type=Equity& Symbol=VFC
>
> Interestingly, this page shows info:
> http://investing.money.msn. com/investments/ stock-price? Symbol=vfc& ocid=qbeb
>
> I tried the beta version 2012.04.07 too but that gave same results.
>
Are there any updates for the MSN elements? same problem for me.
- 6c.
-
Re: MSN elements not working anymore
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Apr 26, 2012 11:16 pm (PDT)
Thanks for the heads up.
Doing a "Find and Replace All" on the definitions file from:
http://moneycentral.msn.com/ investor/ research/ sreport.asp?
...to:
http://investing.money.msn. com/investments/ stock-report?
...appears to fix most of the errors, but I still have a number of elements
still coming up error. They may have changed the content or layout of the
page for those elements, or obsoleted them altogether.
I won't release a new definitions file until more of the errors are gone.
This is the fourth time in three years that MSN has changed the URLs of
their website.
On Thu, Apr 26, 2012 at 7:18 PM, MikeM <mikemcq802@yahoo.com > wrote:
> It seems MSN may have reconfigured their site. The element numbers 25 and
> 46 are not working for any ticker (the only two I tried). If I type the
> url from the smf-elements-txt file it shows a web page for creating a
> report but you must select the items you want.
>
> This is the version I am using:
> Stock Market Functions add-in, Version 2.1.2012.02.17
>
> This is a sample retrieval that is not working (gets "error").
> =RCHGetElementNumber("VFC",25, ,)
>
> Here's the url from the elements file:
>
> http://moneycentral.msn.com/ investor/ research/ sreport.asp? CR=1&AF=1& IH=1&AIE= 1&AIR=1&FRH= 1&FRK=1&ISA= 1&ISQ=1&BSA= 1&BSQ=1&CFA= 1&CFQ=1&TYS= 1&ITT=1&ITP= 1&Type=Equity& Symbol=VFC
>
> Interestingly, this page shows info:
> http://investing.money.msn. com/investments/ stock-price? Symbol=vfc& ocid=qbeb
>
> I tried the beta version 2012.04.07 too but that gave same results.
>
- 6d.
-
Re: MSN elements not working anymore
Posted by: "Frank" fwkirk@gmail.com nautilustech
Thu Apr 26, 2012 11:43 pm (PDT)
> This is the fourth time in three years that MSN has changed the
> URLs of their website.
Does anyone know of a rational, logical reason WHY they do this?
- 7.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Fri Apr 27, 2012 12:22 am (PDT)
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 : /Works-In-Progress/smf-elements- 1.txt
Uploaded by : rharmelink <rharmelink@gmail.com >
Description : Contains updates to MSN data element definitions, which had to be redefined because of URL and page layout changes made by MSN. These definitions are used by the RCHGetElementNumber() function.
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Works-In- Progress/ smf-elements- 1.txt
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 >
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