[smf_addin] Digest Number 2161

EXCEL Stock Market Functions Add-in

Messages In This Digest (13 Messages)

1a.

Re: Barchart What Not1.xlsm From: digsupply

2a.

Re: exact DATE match for smfGetEconData ? From: r d

3a.

Newbie Seeking Some Assistance From: chrisstuart78

3b.

Re: Newbie Seeking Some Assistance From: Randy Harmelink

3c.

Re: Newbie Seeking Some Assistance From: chrisstuart78

4a.

Re: Call/Put Spreadsheet From: bobc94595

4b.

Re: Call/Put Spreadsheet From: Randy Harmelink

5a.

Hello... I hv just joined the group.... Need some help on getting st From: navin_agrawal_1

5b.

Re: Hello... I hv just joined the group.... Need some help on gettin From: Randy Harmelink

5c.

Re: Hello... I hv just joined the group.... Need some help on gettin From: Randy Harmelink

5d.

Re: Hello... I hv just joined the group.... Need some help on gettin From: navin_agrawal_1

5e.

Re: Hello... I hv just joined the group.... Need some help on gettin From: Randy Harmelink

6.

Hello... I hv just joined the group.... Need some help on getting st From: navin_agrawal_1

View All Topics | Create New Topic

Messages

1a.

Re: Barchart What Not1.xlsm

Posted by: "digsupply" picsound@gmail.com   digsupply

Thu Mar 29, 2012 4:21 am (PDT)

Make sure you have the correct references set in VBA:

Tools... > References AND SELECT
MICROSOFT WINDOWS COMMON CONTROLS 6.0 (SP6)

--- In smf_addin@yahoogroups.com, "kim54blake" <kblake@...> wrote:
>
> I just downloaded this file, it looks very impressive, however when I click on any of the buttons I get a compile error: "Method or data member not found" with .ProgressBar1 highlighted??
> Is this a problem at my end or is a module missing?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.

Re: exact DATE match for smfGetEconData ?

Posted by: "r d" freddy@email.com   stupid21bull

Thu Mar 29, 2012 10:00 am (PDT)

correct. this function would be helpful for those who are importing data from numerous series (and who may not have committed those series to memory &/or are providing them for presentation). After all there are over 45,000 economic time series from 39 sources...

just a suggestion

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> To me, that's just a matter of you knowing and understanding the data you
> are retrieving. If you want to compare daily to monthly to annual, you have
> to compare the data at the annual dates. If you want to compare daily to
> monthly, you need to use the monthly dates. There is nothing to compare on
> the other dates.
>
> With this function, is there even any reason to use the monthly or annual
> series if the daily is available? I suppose speed would be a factor if you
> are retrieving a lot of different dates, since the daily file has more data
> to search through.
>
> On Thu, Mar 29, 2012 at 12:19 AM, r d <freddy@...> wrote:
>
> >
> > yes the function works excellent, however assuming one wishes to compare
> > data from different series...it will be helpful to import exact date
> > references.
> >
> > take for instance this example:
> > I wish to compare "Per Capita personal income" in California against the
> > Far West Regional average on December 15, 2011.
> > the State average is published Annually
> > the Regional average is published Monthly
> >
> > therefore if I happen to use December 15 as my date...the State stat is
> > actually 11 months behind the Regional stat!
> >
> > So it'd be helpful to therefore realize actual true dates for the stats I
> > am importing...
> >
> > (c what I mean?)
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3a.

Newbie Seeking Some Assistance

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

Thu Mar 29, 2012 10:11 am (PDT)

Sorry for asking such a dumb question...but I'm trying to create an application on my website--pretty simple, where a user types in a ticker and gets results for the ticker for a few fields

Is this possible using the add in or can i only download the data into excel? Is there any way to create a PHP/Jquery type application using the data?

Thanks

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3b.

Re: Newbie Seeking Some Assistance

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

Thu Mar 29, 2012 10:44 am (PDT)

You wouldn't be able to use the add-in that way.

If you look through the message archives, you'll find some Google
spreadsheet examples that do that type of thing.

Note that you may need to pay the data provider for the right to republish
the data on your website.

On Thu, Mar 29, 2012 at 9:32 AM, chrisstuart78 <chrisstuart78@yahoo.com>wrote:

> Sorry for asking such a dumb question...but I'm trying to create an
> application on my website--pretty simple, where a user types in a ticker
> and gets results for the ticker for a few fields
>
> Is this possible using the add in or can i only download the data into
> excel? Is there any way to create a PHP/Jquery type application using the
> data?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3c.

Re: Newbie Seeking Some Assistance

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

Thu Mar 29, 2012 11:09 am (PDT)

ok thanks. the only reason i asked is that i saw a site vuru (dot) co that was doing it ...from the footer at least they say that they are using yahoo finance data.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You wouldn't be able to use the add-in that way.
>
> If you look through the message archives, you'll find some Google
> spreadsheet examples that do that type of thing.
>
> Note that you may need to pay the data provider for the right to republish
> the data on your website.
>
> On Thu, Mar 29, 2012 at 9:32 AM, chrisstuart78 <chrisstuart78@...>wrote:
>
> > Sorry for asking such a dumb question...but I'm trying to create an
> > application on my website--pretty simple, where a user types in a ticker
> > and gets results for the ticker for a few fields
> >
> > Is this possible using the add in or can i only download the data into
> > excel? Is there any way to create a PHP/Jquery type application using the
> > data?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

4a.

Re: Call/Put Spreadsheet

Posted by: "bobc94595" conlonrc@comcast.net   bobc94595

Thu Mar 29, 2012 11:06 am (PDT)

Randy, if, for example, I run MMM or IBM on your referenced spreadsheet today, the April Calls displayed do not display any quotes close to the at-the-money, or either side. For example, MMM at around $88 only shows quotes from $37.50 to $72.50, and nothing close to $88. Can that be remedied?

Bob

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> And there is a section of the
> RCHGetTableCell-Template-Yahoo-Options-CC-Returns.xls workbook that more or
> less does almost the same thing, just for fewer strike prices.
>
> On Sat, Jul 3, 2010 at 7:30 PM, bobc94595 <conlonrc@...> wrote:
>
> > Thanks, Randy. I am aware of justcoveredcalls, and have found it very
> > informative. In the spreadsheet to which I referred, it shows the same
> > return data in both the Call and Put columns. It appears to be Call data,
> > and the Put column contains the same Call data.
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > If you're interested in option workbooks, I have a few templates in the
> > > files area of this group:
> > >
> > > http://finance.groups.yahoo.com/group/justcoveredcalls/
> > >
> > > When that prototype was put together, I told him I thought it was
> > overkill
> > > -- the max ROI is almost always going to be the first ITM or first OTM
> > put
> > > or call. I really don't think there would be a reason to go beyond that.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

4b.

Re: Call/Put Spreadsheet

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

Thu Mar 29, 2012 11:32 am (PDT)

I just grabbed the file from the JustCoveredCalls group and tried both IBM
and MMM. Both were returning reasonable results for what I see on Yahoo
Finance. For example, the April calls I see for MMM ranges from $77.50 to
$100.

Did you try an smfForceRecalculation? Maybe you got data from a bad Yahoo
server? Do you have your Internet Options set up to always get a fresh copy
of a web page?

On Thu, Mar 29, 2012 at 11:06 AM, bobc94595 <conlonrc@comcast.net> wrote:

> Randy, if, for example, I run MMM or IBM on your referenced spreadsheet
> today, the April Calls displayed do not display any quotes close to the
> at-the-money, or either side. For example, MMM at around $88 only shows
> quotes from $37.50 to $72.50, and nothing close to $88. Can that be
> remedied?
>
> Bob
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

5a.

Hello... I hv just joined the group.... Need some help on getting st

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

Thu Mar 29, 2012 11:20 pm (PDT)

I have been using excel for a long time. But when it comes to programming and VBAs, I would say I am a novice. I am clear about what I want to do, but don't know how to go about it. Let me know if any of the walk-ins or anyone you know who can help me....

The below link gives the realtime backfill data...

http://www.google.com/finance/getpri...=1266701290218

where

q= stock symbol on Google finance
x= exchange symbol
i= interval (here 60 means 60 sec (1 minute interval))
p= no of period(here 5d denotes 5 days of data)
f= parameters (day, close, open, high and low)
df= difference (cpct is may be in % change )
auto =1,
ts = time start… if you cut the last 4 digits…the rest gives the start day in seconds

you can choose your own set of value depending upon your need.

The following link gives the 1 min Realtime data for Nifty

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Using the above explanation we can build any formats (1min, 5min, 15min, 60 min) of real time data and can be use as a backfill

To get 1 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

To get 5 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 15 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 60 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Here is the link where the yahoo finance offers real time data updates in realtime in csv format at free of cost. (This sentence is the hyperlink to the site)

I am trying to create a sheet so that I have to key in the scrip name in cell A1 and the duration (1 min / 5 min / 15 min / 60 min) in cell B1.

I would need exactly 500 datapoints whether 1 min / 5 min / 15 min / 60 min.

Then using VBA (for which I need help) I should be able to get the data in Excel format on realtime basis..... the above links give the data in CSV...

Finally the file should be designed in a way so that if I want real-time data for 50 - 100 stocks simultaneously, I should be able to get it.....

The most important aspect is getting the data in excel and have it updated on realtime basis….

Can this be managed????

Thanks & Regards,
Navin Agrawal
navin_agrawal_1@yahoo.com

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

5b.

Re: Hello... I hv just joined the group.... Need some help on gettin

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

Thu Mar 29, 2012 11:21 pm (PDT)

That's an invalid link...

On Thu, Mar 29, 2012 at 11:13 PM, navin_agrawal_1 <navin_agrawal_1@yahoo.com
> wrote:

>
> The below link gives the realtime backfill data...
>
> http://www.google.com/finance/getpri...=1266701290218
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

5c.

Re: Hello... I hv just joined the group.... Need some help on gettin

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

Thu Mar 29, 2012 11:31 pm (PDT)

FYI -- for those of you interesting in the links, the email was copied from
this web page:

http://www.marketcalls.in/database/google-realtime-intraday-backfill-data.html

You can use the add-in to retrieve the CSV file with something like:

=smfGetCSVFile("
http://www.google.com/finance/getprices?q=CIPLA&i=60&p=15d&f=d,o,h,l,c,v")

On Thu, Mar 29, 2012 at 11:13 PM, navin_agrawal_1 <navin_agrawal_1@yahoo.com
> wrote:

> I have been using excel for a long time. But when it comes to programming
> and VBAs, I would say I am a novice. I am clear about what I want to do,
> but don't know how to go about it. Let me know if any of the walk-ins or
> anyone you know who can help me....
>
> The below link gives the realtime backfill data...
>
> http://www.google.com/finance/getpri...=1266701290218
>
> where
>
> q= stock symbol on Google finance
> x= exchange symbol
> i= interval (here 60 means 60 sec (1 minute interval))
> p= no of period(here 5d denotes 5 days of data)
> f= parameters (day, close, open, high and low)
> df= difference (cpct is may be in % change )
> auto =1,
> ts = time start… if you cut the last 4 digits…the rest gives the start day
> in seconds
>
> you can choose your own set of value depending upon your need.
>
> The following link gives the 1 min Realtime data for Nifty
>
> http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
>
> Using the above explanation we can build any formats (1min, 5min, 15min,
> 60 min) of real time data and can be use as a backfill
>
> To get 1 min Data
> http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
>
> To get 5 min Data
> http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
>
> to get 15 min Data
> http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
>
> to get 60 min Data
> http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
>
> Here is the link where the yahoo finance offers real time data updates in
> realtime in csv format at free of cost. (This sentence is the hyperlink to
> the site)
>
> I am trying to create a sheet so that I have to key in the scrip name in
> cell A1 and the duration (1 min / 5 min / 15 min / 60 min) in cell B1.
>
> I would need exactly 500 datapoints whether 1 min / 5 min / 15 min / 60
> min.
>
> Then using VBA (for which I need help) I should be able to get the data in
> Excel format on realtime basis..... the above links give the data in CSV...
>
> Finally the file should be designed in a way so that if I want real-time
> data for 50 - 100 stocks simultaneously, I should be able to get it.....
>
> The most important aspect is getting the data in excel and have it updated
> on realtime basis….
>
> Can this be managed????
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

5d.

Re: Hello... I hv just joined the group.... Need some help on gettin

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

Fri Mar 30, 2012 12:01 am (PDT)

Thanks Randy...

But as I mentioned, I am not very conversant nor an expert at these things..... Will it b possible for you to guide me or let me know where I can get help on installing and using add-ins...

Further, all I am trying to get is real-time quotes and historical intra-day & EOD data in excel.... If someone has already done this... will appreciate being told....

Regards,
Navin

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> FYI -- for those of you interesting in the links, the email was copied from
> this web page:
>
> http://www.marketcalls.in/database/google-realtime-intraday-backfill-data.html
>
> You can use the add-in to retrieve the CSV file with something like:
>
> =smfGetCSVFile("
> http://www.google.com/finance/getprices?q=CIPLA&i=60&p=15d&f=d,o,h,l,c,v")
>
> On Thu, Mar 29, 2012 at 11:13 PM, navin_agrawal_1 <navin_agrawal_1@...
> > wrote:
>
> > I have been using excel for a long time. But when it comes to programming
> > and VBAs, I would say I am a novice. I am clear about what I want to do,
> > but don't know how to go about it. Let me know if any of the walk-ins or
> > anyone you know who can help me....
> >
> > The below link gives the realtime backfill data...
> >
> > http://www.google.com/finance/getpri...=1266701290218
> >
> > where
> >
> > q= stock symbol on Google finance
> > x= exchange symbol
> > i= interval (here 60 means 60 sec (1 minute interval))
> > p= no of period(here 5d denotes 5 days of data)
> > f= parameters (day, close, open, high and low)
> > df= difference (cpct is may be in % change )
> > auto =1,
> > ts = time start… if you cut the last 4 digits…the rest gives the start day
> > in seconds
> >
> > you can choose your own set of value depending upon your need.
> >
> > The following link gives the 1 min Realtime data for Nifty
> >
> > http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
> >
> > Using the above explanation we can build any formats (1min, 5min, 15min,
> > 60 min) of real time data and can be use as a backfill
> >
> > To get 1 min Data
> > http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
> >
> > To get 5 min Data
> > http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
> >
> > to get 15 min Data
> > http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
> >
> > to get 60 min Data
> > http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
> >
> > Here is the link where the yahoo finance offers real time data updates in
> > realtime in csv format at free of cost. (This sentence is the hyperlink to
> > the site)
> >
> > I am trying to create a sheet so that I have to key in the scrip name in
> > cell A1 and the duration (1 min / 5 min / 15 min / 60 min) in cell B1.
> >
> > I would need exactly 500 datapoints whether 1 min / 5 min / 15 min / 60
> > min.
> >
> > Then using VBA (for which I need help) I should be able to get the data in
> > Excel format on realtime basis..... the above links give the data in CSV...
> >
> > Finally the file should be designed in a way so that if I want real-time
> > data for 50 - 100 stocks simultaneously, I should be able to get it.....
> >
> > The most important aspect is getting the data in excel and have it updated
> > on realtime basis….
> >
> > Can this be managed????
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

5e.

Re: Hello... I hv just joined the group.... Need some help on gettin

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

Fri Mar 30, 2012 12:44 am (PDT)

Check the "Documentation" folder in the files area...

On Fri, Mar 30, 2012 at 12:01 AM, navin_agrawal_1 <navin_agrawal_1@yahoo.com
> wrote:

>
> But as I mentioned, I am not very conversant nor an expert at these
> things..... Will it b possible for you to guide me or let me know where I
> can get help on installing and using add-ins...
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

6.

Hello... I hv just joined the group.... Need some help on getting st

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

Thu Mar 29, 2012 11:38 pm (PDT)

I have been using excel for a long time. But when it comes to programming and VBAs, I would say I am a novice.

I am clear about what I want to do, but don't know how to go about it. Let me know if any of the walk-ins or anyone you know who can help me....

The below link gives the realtime backfill data...

http://www.google.com/finance/getpri...=1266701290218

where

q= stock symbol on Google finance
x= exchange symbol
i= interval (here 60 means 60 sec (1 minute interval))
p= no of period(here 5d denotes 5 days of data)
f= parameters (day, close, open, high and low)
df= difference (cpct is may be in % change )
auto =1,
ts = time start… if you cut the last 4 digits…the rest gives the start day in seconds

you can choose your own set of value depending upon your need.

The following link gives the 1 min Realtime data for Nifty

http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Using the above explanation we can build any formats (1min, 5min, 15min, 60 min) of real time data and can be use as a backfill

To get 1 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

To get 5 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 15 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

to get 60 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Here is the link where the yahoo finance offers real time data updates in realtime in csv format at free of cost. (This sentence is the hyperlink to the site)

I am trying to create a sheet so that I have to key in the scrip name in cell A1 and the duration (1 min / 5 min / 15 min / 60 min) in cell B1.

I would need exactly 500 datapoints whether 1 min / 5 min / 15 min / 60 min.

Then using VBA (which I want someone to design and help me) I should be able to get the data in Excel format on realtime basis..... the above links give the data in CSV...

Finally the file should be designed in a way so that if I want real-time data for 50 - 100 stocks simultaneously, I should be able to get it.....

The most important aspect is getting the data in excel and have it updated on realtime basis….

Can this be managed????

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

Recent Activity

•  112
  New Members
•  2
  New Files

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

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

Messages | Files | Photos | Polls

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