11 New Messages
Digest #2542
Messages
Tue Mar 12, 2013 7:06 am (PDT) . Posted by:
"Ron Spruell" hashky
Randy -
If you were updating the documentation for Vista/Windows 7/Windows 8, what would be the recommended place to store the Add-In?
Ron Spruell
If you were updating the documentation for Vista/Windows 7/Windows 8, what would be the recommended place to store the Add-In?
Ron Spruell
Tue Mar 12, 2013 9:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ideally, I would say C:\SMF Add-in, since that is where I currently keep
it. However, I didn't change the old documentation because the library
currently has a mix of sources, and it would have required that everyone
that had it in the old location also move it to the new location.
No matter what the location, people eventually run into the location error,
so it's best that they know how to fix it. Currently, the smfFixLinks macro
should do the trick (other than protected worksheets). I use it all the
time, and have it on a toolbar button.
On Tue, Mar 12, 2013 at 7:06 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> If you were updating the documentation for Vista/Windows 7/Windows 8, what
> would be the recommended place to store the Add-In?
>
>
it. However, I didn't change the old documentation because the library
currently has a mix of sources, and it would have required that everyone
that had it in the old location also move it to the new location.
No matter what the location, people eventually run into the location error,
so it's best that they know how to fix it. Currently, the smfFixLinks macro
should do the trick (other than protected worksheets). I use it all the
time, and have it on a toolbar button.
On Tue, Mar 12, 2013 at 7:06 AM, Ron Spruell <hashky@yahoo.
>
> If you were updating the documentation for Vista/Windows 7/Windows 8, what
> would be the recommended place to store the Add-In?
>
>
Tue Mar 12, 2013 9:11 am (PDT) . Posted by:
"kraigtuber" kraigtuber
Hi Randy,
I am new to the SMF Add-in family. The macros work great. Thank you for that. Is there a way that if I want to retrieve multiple RCHGetElements on a single ticker, for example IBM, how I can do this so that it is for efficient for the computer. Currently, I am using individual function calls.
thanks for your help in advance.
Kraig
I am new to the SMF Add-in family. The macros work great. Thank you for that. Is there a way that if I want to retrieve multiple RCHGetElements on a single ticker, for example IBM, how I can do this so that it is for efficient for the computer. Currently, I am using individual function calls.
thanks for your help in advance.
Kraig
Tue Mar 12, 2013 9:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There's no advantage to doing multiple element numbers with one invocation
of the function versus doing a single function invocation in each worksheet
cell, so there was no reason to write the function in such a way.
It makes sense for something like RCHGetYahooQuotes() to be array-entered,
because the CSV file Yahoo provides can mean only one Internet access for
multiple data items for multiple ticker symbols. With something like
RCHGetElementNumber(), multiple tickers mean multiple web pages, and if you
have multiple data elements from a single page, RCHGetElementNumber() is
set up to only retrieve the web page once, because it stores it first and
then extracts the data from the stored copy of the web page.
On Tue, Mar 12, 2013 at 7:12 AM, kraigtuber <kraig.s.tuber@gmail.com > wrote:
>
> I am new to the SMF Add-in family. The macros work great. Thank you for
> that. Is there a way that if I want to retrieve multiple RCHGetElements on
> a single ticker, for example IBM, how I can do this so that it is for
> efficient for the computer. Currently, I am using individual function
> calls.
>
of the function versus doing a single function invocation in each worksheet
cell, so there was no reason to write the function in such a way.
It makes sense for something like RCHGetYahooQuotes(
because the CSV file Yahoo provides can mean only one Internet access for
multiple data items for multiple ticker symbols. With something like
RCHGetElementNumber
have multiple data elements from a single page, RCHGetElementNumber
set up to only retrieve the web page once, because it stores it first and
then extracts the data from the stored copy of the web page.
On Tue, Mar 12, 2013 at 7:12 AM, kraigtuber <kraig.s.tuber@
>
> I am new to the SMF Add-in family. The macros work great. Thank you for
> that. Is there a way that if I want to retrieve multiple RCHGetElements on
> a single ticker, for example IBM, how I can do this so that it is for
> efficient for the computer. Currently, I am using individual function
> calls.
>
Tue Mar 12, 2013 12:52 pm (PDT) . Posted by:
"Au" uanant@ymail.com
Hi,
I was wondering if I can create a summary either at the end of the day or end of a week
for 52 week low / High & current price of every stock on S&P 500.
With this request would I make too much demand on the system with respect of number of connections.
Is there anything like this already exists? I tried to find a website that can send a daily update with this info but could not find it.
Any information in this regard would be greatly appreciated. I am doing this for a school project.
Thanks for your help
Aku
I was wondering if I can create a summary either at the end of the day or end of a week
for 52 week low / High & current price of every stock on S&P 500.
With this request would I make too much demand on the system with respect of number of connections.
Is there anything like this already exists? I tried to find a website that can send a daily update with this info but could not find it.
Any information in this regard would be greatly appreciated. I am doing this for a school project.
Thanks for your help
Aku
Tue Mar 12, 2013 1:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can get the data from FinViz in one Internet access:
=smfGetCSVFile("http://finviz.com/export.ashx?v=171&f=idx_sp500 ")
...which grabs a number of technical indicators for the S&P 500 stocks.
Check out the FinViz entries in the LINKS area of the group for ways to
customize that CSV file with a number of additional fields, if desired.
Just use the "&f=" parameter to specify index components instead of "&t="
to specify a list of individual ticker symbols.
Or you could get the data with three Internet accesses from Yahoo, using
the RCHGetYahooQuotes() function. Yahoo limits that to 200 tickers per
request, so you'd need three functions.
On Tue, Mar 12, 2013 at 12:52 PM, Au <uanant@ymail.com > wrote:
> I was wondering if I can create a summary either at the end of the day or
> end of a week
> for 52 week low / High & current price of every stock on S&P 500.
> With this request would I make too much demand on the system with respect
> of number of connections.
> Is there anything like this already exists? I tried to find a website that
> can send a daily update with this info but could not find it.
> Any information in this regard would be greatly appreciated. I am doing
> this for a school project.
>
>
=smfGetCSVFile(
...which grabs a number of technical indicators for the S&P 500 stocks.
Check out the FinViz entries in the LINKS area of the group for ways to
customize that CSV file with a number of additional fields, if desired.
Just use the "&f=
to specify a list of individual ticker symbols.
Or you could get the data with three Internet accesses from Yahoo, using
the RCHGetYahooQuotes(
request, so you'd need three functions.
On Tue, Mar 12, 2013 at 12:52 PM, Au <uanant@ymail.
> I was wondering if I can create a summary either at the end of the day or
> end of a week
> for 52 week low / High & current price of every stock on S&P 500.
> With this request would I make too much demand on the system with respect
> of number of connections.
> Is there anything like this already exists? I tried to find a website that
> can send a daily update with this info but could not find it.
> Any information in this regard would be greatly appreciated. I am doing
> this for a school project.
>
>
Tue Mar 12, 2013 10:35 am (PDT) . Posted by:
"gene.farber" gene.farber
I am not able to install RCStock Market Functions 2.1.2012 correctly.
The Excell Add-In process goes well. But when I type in "RCGGetYahooHistory("MSFT")" I get repeat statemens in each cell that say "RCGGetYahooHistory("MSFT")" ehrn Contoro+Shift+Enter are pressed.
Tried this in both Excell 2007 and 2010 on machines urnning Windows 7 64 bit. I put the unzipped files into the 32 bit Programs folder on the C drives.
Can anyone help?
Thanks, Gene
The Excell Add-In process goes well. But when I type in "RCGGetYahooHi
Tried this in both Excell 2007 and 2010 on machines urnning Windows 7 64 bit. I put the unzipped files into the 32 bit Programs folder on the C drives.
Can anyone help?
Thanks, Gene
Tue Mar 12, 2013 10:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The best way to see if the add-in is installed OK is to check the version:
=RCHGetElementNumber("Version")
From what you say below, the reason it didn't work is you didn't enter a
function. You entered a text string. You want to array-enter this function:
=RCHGetYahooHistory("MSFT";)
On Tue, Mar 12, 2013 at 9:57 AM, gene.farber <genefarber@hotmail.com > wrote:
> I am not able to install RCStock Market Functions 2.1.2012 correctly.
>
> The Excell Add-In process goes well. But when I type in
> "RCGGetYahooHistory("MSFT")" I get repeat statemens in each cell that say
> "RCGGetYahooHistory("MSFT")" ehrn Contoro+Shift+Enter are pressed.
>
> Tried this in both Excell 2007 and 2010 on machines urnning Windows 7 64
> bit. I put the unzipped files into the 32 bit Programs folder on the C
> drives.
>
> Can anyone help?
>
=RCHGetElementNumbe
From what you say below, the reason it didn't work is you didn't enter a
function. You entered a text string. You want to array-enter this function:
=RCHGetYahooHistory
On Tue, Mar 12, 2013 at 9:57 AM, gene.farber <genefarber@hotmail.
> I am not able to install RCStock Market Functions 2.1.2012 correctly.
>
> The Excell Add-In process goes well. But when I type in
> "RCGGetYahooHi
> "RCGGetYahooHi
>
> Tried this in both Excell 2007 and 2010 on machines urnning Windows 7 64
> bit. I put the unzipped files into the 32 bit Programs folder on the C
> drives.
>
> Can anyone help?
>
Tue Mar 12, 2013 12:08 pm (PDT) . Posted by:
"gene.farber" gene.farber
Thank you very much. Did as you said and it works.
Can't wait to start working with it.
Gene
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The best way to see if the add-in is installed OK is to check the version:
>
> =RCHGetElementNumber("Version")
>
> From what you say below, the reason it didn't work is you didn't enter a
> function. You entered a text string. You want to array-enter this function:
>
> =RCHGetYahooHistory("MSFT";)
>
> On Tue, Mar 12, 2013 at 9:57 AM, gene.farber <genefarber@...> wrote:
>
> > I am not able to install RCStock Market Functions 2.1.2012 correctly.
> >
> > The Excell Add-In process goes well. But when I type in
> > "RCGGetYahooHistory("MSFT")" I get repeat statemens in each cell that say
> > "RCGGetYahooHistory("MSFT")" ehrn Contoro+Shift+Enter are pressed.
> >
> > Tried this in both Excell 2007 and 2010 on machines urnning Windows 7 64
> > bit. I put the unzipped files into the 32 bit Programs folder on the C
> > drives.
> >
> > Can anyone help?
> >
>
Can't wait to start working with it.
Gene
--- In smf_addin@yahoogrou
>
> The best way to see if the add-in is installed OK is to check the version:
>
> =RCHGetElementNumbe
>
> From what you say below, the reason it didn't work is you didn't enter a
> function. You entered a text string. You want to array-enter this function:
>
> =RCHGetYahooHistory
>
> On Tue, Mar 12, 2013 at 9:57 AM, gene.farber <genefarber@
>
> > I am not able to install RCStock Market Functions 2.1.2012 correctly.
> >
> > The Excell Add-In process goes well. But when I type in
> > "RCGGetYahooHi
> > "RCGGetYahooHi
> >
> > Tried this in both Excell 2007 and 2010 on machines urnning Windows 7 64
> > bit. I put the unzipped files into the 32 bit Programs folder on the C
> > drives.
> >
> > Can anyone help?
> >
>
Wed Mar 13, 2013 1:43 am (PDT) . Posted by:
"weekeewawa" weekeewawa
i have a problem while extracting 'Long Term Debt' from Yahoo Balance Sheet
It shows the same results as 'Short/Current Long Term Debt' whereby the result should defer
any solution for it?
thanks!
It shows the same results as 'Short/Current Long Term Debt' whereby the result should defer
any solution for it?
thanks!
Wed Mar 13, 2013 1:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It would have been helpful to see some formula examples. You need to
specify unique search strings, or use multiple search strings, to get to
what you need to extract.
I'll assume you're not using the formulas from the template in the files
area, since they do differentiate between the two data items. The template
uses these two formulas for the two different items:
=RCHGetTableCell("http://finance.yahoo.com/q/bs?s= "&Ticker,1,"Period
Ending","Short/Current Long Term Debt",,,,"Add to Portfolio")
=RCHGetTableCell("http://finance.yahoo.com/q/bs?s= "&Ticker,1,"Period
Ending",">Long Term Debt",,,,"Add to Portfolio")
On Wed, Mar 13, 2013 at 1:36 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
> i have a problem while extracting 'Long Term Debt' from Yahoo Balance Sheet
>
> It shows the same results as 'Short/Current Long Term Debt' whereby the
> result should defer
>
> any solution for it?
>
specify unique search strings, or use multiple search strings, to get to
what you need to extract.
I'll assume you're not using the formulas from the template in the files
area, since they do differentiate between the two data items. The template
uses these two formulas for the two different items:
=RCHGetTableCell(
Ending"
=RCHGetTableCell(
Ending"
On Wed, Mar 13, 2013 at 1:36 AM, weekeewawa <weekeewawa@yahoo.
> i have a problem while extracting 'Long Term Debt' from Yahoo Balance Sheet
>
> It shows the same results as 'Short/Current Long Term Debt' whereby the
> result should defer
>
> any solution for it?
>
Tidak ada komentar:
Posting Komentar