Jumat, 16 Desember 2011

[smf_addin] Digest Number 2048

Messages In This Digest (12 Messages)

Messages

1a.

opening files

Posted by: "colobuyer123" keystin@gmail.com   colobuyer123

Thu Dec 15, 2011 9:42 am (PST)



Randy, how do I disable the automatic updating of the data pulled in from the add in. For example, if I just want to open the file and view its current contents vs waiting several minutes for everything to update?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1b.

Re: opening files

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Dec 15, 2011 12:18 pm (PST)



Turn off automatic calculation.

If you have a lot of single-cell RCHGetYahooQuotes() functions, you could
speed up the workbook recalculation significantly by combining them into an
array-entered version of the function over a range.

On Thu, Dec 15, 2011 at 10:42 AM, colobuyer123 <keystin@gmail.com> wrote:

> Randy, how do I disable the automatic updating of the data pulled in from
> the add in. For example, if I just want to open the file and view its
> current contents vs waiting several minutes for everything to update?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1c.

Re: opening files

Posted by: "colobuyer123" keystin@gmail.com   colobuyer123

Thu Dec 15, 2011 2:59 pm (PST)



Sorry to ask but how do I set up an array-entered version? I have a number of data points being calculated

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Turn off automatic calculation.
>
> If you have a lot of single-cell RCHGetYahooQuotes() functions, you could
> speed up the workbook recalculation significantly by combining them into an
> array-entered version of the function over a range.
>
> On Thu, Dec 15, 2011 at 10:42 AM, colobuyer123 <keystin@...> wrote:
>
> > Randy, how do I disable the automatic updating of the data pulled in from
> > the add in. For example, if I just want to open the file and view its
> > current contents vs waiting several minutes for everything to update?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1d.

Re: opening files

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Thu Dec 15, 2011 3:04 pm (PST)



Shift-Cntl-Enter

See:

http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-e
xcel-HA001087290.aspx

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of colobuyer123
Sent: Thursday, December 15, 2011 5:59 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: opening files

Sorry to ask but how do I set up an array-entered version? I have a number
of data points being calculated

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> Turn off automatic calculation.
>
> If you have a lot of single-cell RCHGetYahooQuotes() functions, you could
> speed up the workbook recalculation significantly by combining them into
an
> array-entered version of the function over a range.
>
> On Thu, Dec 15, 2011 at 10:42 AM, colobuyer123 <keystin@...> wrote:
>
> > Randy, how do I disable the automatic updating of the data pulled in
from
> > the add in. For example, if I just want to open the file and view its
> > current contents vs waiting several minutes for everything to update?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1e.

Re: [Bulk] RE: [smf_addin] Re: opening files

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Thu Dec 15, 2011 3:07 pm (PST)



and, see Randy's section of Templates here:
http://finance.groups.yahoo.com/group/smf_addin/files/Templates%20and%20Exam
ples/

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Mike McQuaid
Sent: Thursday, December 15, 2011 6:06 PM
To: smf_addin@yahoogroups.com
Subject: [Bulk] RE: [smf_addin] Re: opening files

Shift-Cntl-Enter

See:

http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-e
xcel-HA001087290.aspx

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of colobuyer123
Sent: Thursday, December 15, 2011 5:59 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: opening files

Sorry to ask but how do I set up an array-entered version? I have a number
of data points being calculated

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> Turn off automatic calculation.
>
> If you have a lot of single-cell RCHGetYahooQuotes() functions, you could
> speed up the workbook recalculation significantly by combining them into
an
> array-entered version of the function over a range.
>
> On Thu, Dec 15, 2011 at 10:42 AM, colobuyer123 <keystin@...> wrote:
>
> > Randy, how do I disable the automatic updating of the data pulled in
from
> > the add in. For example, if I just want to open the file and view its
> > current contents vs waiting several minutes for everything to update?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1f.

Re: opening files

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Dec 15, 2011 3:54 pm (PST)



Check the description (and cited example) in the documentation...

On Thu, Dec 15, 2011 at 3:59 PM, colobuyer123 <keystin@gmail.com> wrote:

> Sorry to ask but how do I set up an array-entered version? I have a
> number of data points being calculated
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > If you have a lot of single-cell RCHGetYahooQuotes() functions, you could
> > speed up the workbook recalculation significantly by combining them into
> an
> > array-entered version of the function over a range.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Re: Intraday data?

Posted by: "ronmac17" ronmac17@yahoo.com   ronmac17

Thu Dec 15, 2011 11:35 am (PST)



Intrady data can be exported as a .txt file from
http://www.freestockcharts.com/ Time frames down to 1 minute. You would
have to write your own macro to import the data or just copy and paste
it.

--- In smf_addin@yahoogroups.com, "Deborah" <dcharlotte99@...> wrote:
>
> I'd like to download historical intra-day data (20 min and 240 min)
say the last 1 to 2 months of data for each of those timeframes. Anyone
know a way either free or a paid service to do so?
>
> I have access to eSignal, a paid service but not sure about
reprogramming the add-in.
>
> Thanks!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

Why am I encountering the problem with smfJoin?

Posted by: "SANCHO" sancho_best@yahoo.com   sancho_best

Thu Dec 15, 2011 4:44 pm (PST)



Using next formula
=smfGetCSVFile("http://finviz.com/export.ashx?v=151&t=MMM,NFLX&c=1,65,66,67")

everything is working fine. But as soon as i am changing the tickers on
smfJoin, the things are going wrong - i am getting mistake. For instance,
using formula =smfGetCSVFile("http://finviz.com/export.ashx?v=151&t="&smfJoin(A3:A17;",")&"&c=1,65,66,67") - i have error in all cells

changing symbol ";" on "," gives me syntax error where Excel highlights the mistake here A17;"," - again i change "," on ";" and get error - no data everywhere

The error i get after changing smfJoin on sfJoin as mentioned in description to the function.

What is that? maybe i have to change some parameters of Excel itself. I do not understand.

Using Excel 2010 and Windows 7

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3b.

Re: Why am I encountering the problem with smfJoin?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Dec 15, 2011 5:44 pm (PST)



Your formula works fine for me once I change the semi-colon delimiter to a
comma.

Do you have the beta version of the add-in from the "Works in Progress"
folder? The smfJoin() function doesn't exist in the 2.1.2010.08.02 version
of the add-in.

On Thu, Dec 15, 2011 at 5:43 PM, SANCHO <sancho_best@yahoo.com> wrote:

> Using next formula
> =smfGetCSVFile("
> http://finviz.com/export.ashx?v=151&t=MMM,NFLX&c=1,65,66,67")
>
> everything is working fine. But as soon as i am changing the tickers on
> smfJoin, the things are going wrong - i am getting mistake. For instance,
> using formula =smfGetCSVFile("http://finviz.com/export.ashx?v=151&t="&smfJoin(A3:A17;",")&"&c=1,65,66,67")
> - i have error in all cells
>
> changing symbol ";" on "," gives me syntax error where Excel highlights
> the mistake here A17;"," - again i change "," on ";" and get error - no
> data everywhere
>
> The error i get after changing smfJoin on sfJoin as mentioned in
> description to the function.
>
> What is that? maybe i have to change some parameters of Excel itself. I do
> not understand.
>
> Using Excel 2010 and Windows 7
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3c.

Re: Why am I encountering the problem with smfJoin?

Posted by: "SANCHO" sancho_best@yahoo.com   sancho_best

Thu Dec 15, 2011 6:27 pm (PST)



Dear Randy!
I have no idea but my Excel works only with semicolon not with comma.

And i do not know why

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Your formula works fine for me once I change the semi-colon delimiter to a
> comma.
>
> Do you have the beta version of the add-in from the "Works in Progress"
> folder? The smfJoin() function doesn't exist in the 2.1.2010.08.02 version
> of the add-in.
>
> On Thu, Dec 15, 2011 at 5:43 PM, SANCHO <sancho_best@...> wrote:
>
> > Using next formula
> > =smfGetCSVFile("
> > http://finviz.com/export.ashx?v=151&t=MMM,NFLX&c=1,65,66,67")
> >
> > everything is working fine. But as soon as i am changing the tickers on
> > smfJoin, the things are going wrong - i am getting mistake. For instance,
> > using formula =smfGetCSVFile("http://finviz.com/export.ashx?v=151&t="&smfJoin(A3:A17;",")&"&c=1,65,66,67")
> > - i have error in all cells
> >
> > changing symbol ";" on "," gives me syntax error where Excel highlights
> > the mistake here A17;"," - again i change "," on ";" and get error - no
> > data everywhere
> >
> > The error i get after changing smfJoin on sfJoin as mentioned in
> > description to the function.
> >
> > What is that? maybe i have to change some parameters of Excel itself. I do
> > not understand.
> >
> > Using Excel 2010 and Windows 7
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3d.

Re: Why am I encountering the problem with smfJoin?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Thu Dec 15, 2011 6:41 pm (PST)



Probably has to do with your regional settings...

On Thu, Dec 15, 2011 at 7:27 PM, SANCHO <sancho_best@yahoo.com> wrote:

> I have no idea but my Excel works only with semicolon not with comma.
>
> And i do not know why
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3e.

Re: Why am I encountering the problem with smfJoin?

Posted by: "SANCHO" sancho_best@yahoo.com   sancho_best

Thu Dec 15, 2011 6:51 pm (PST)



Yes, i conjecture the same.

Anyway, thanks for help

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Probably has to do with your regional settings...
>
> On Thu, Dec 15, 2011 at 7:27 PM, SANCHO <sancho_best@...> wrote:
>
> > I have no idea but my Excel works only with semicolon not with comma.
> >
> > And i do not know why
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
Recent Activity
Visit Your Group
New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.00

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)