Senin, 29 Agustus 2011

[smf_addin] Digest Number 1937

Messages In This Digest (8 Messages)

Messages

1a.

weekly updated football statistics using smf...

Posted by: "Quang Tran" tinotranlv@gmail.com   vaioice

Sun Aug 28, 2011 9:08 am (PDT)



not sure if this was ever ran across here? but i was told that this was possible using the smf_addin? any guidance would be much appreciated.

-vai

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

Re: weekly updated football statistics using smf...

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

Sun Aug 28, 2011 9:11 am (PDT)



It would all depend on the website that has the information and on how they
display it...

On Sun, Aug 28, 2011 at 5:04 AM, Quang Tran <tinotranlv@gmail.com> wrote:

> not sure if this was ever ran across here? but i was told that this was
> possible using the smf_addin? any guidance would be much appreciated.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Re: Problems with Samples

Posted by: "Peter C" pcalinski@yahoo.com   pcalinski

Sun Aug 28, 2011 12:40 pm (PDT)



Great. Thank you. Sorry i didn't find it myself.

Pete

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check item 0.2 of the "Links" area of the group...
>
> On Sat, Aug 27, 2011 at 1:27 PM, Peter C <pcalinski@...> wrote:
>
> > I can't seem to get any of the samples to work. First note that I can get
> > functions like "=RCHGetYahooHistory("MSFT")" to work fine so I think I have
> > things installed correctly.
> >
> > If I download the sample "Aerospace-Response.xls" for example and attempt
> > to open it I get a window about "links to other data sources" and asks if I
> > want to update or not. If I click Update I get a window that says "one or
> > more links cannot be updated". If I "Edit Links" I can see that the link is
> > to where my "RCH_Stock_Market_Functions.xla" file is located.
> >
> > If I click Update Values I get "cannot find RCHGetYahooQuotes' on
> > "RCH_Stock_Market_Functions.xla"
> >
> > If I click change source and point to the RCH file I get the same error.
> >
> > If I try to open source I get a message that the file is already open.
> >
> > If I just don't update, I can go to a cell displaying "#NAME?" and it will
> > have an array formula like "='C:\Program Files\SMF
> > Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B32:B77,C30:P30)".
> >
> > If I edit the cell to remove everything between the "=" and "RCHGet...."
> > and enter it as an array I get the right values from YahooQuotes".
> >
> > So why is having 'C:\Program Files\SMF
> > Add_In\RCH_Stock_Market_Functions.xla'!
> > a problem?
> >
> > I'm running XP SP3 with Excel 2003
> >
>

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

How do I us this add-in to get latest stock price?

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

Sun Aug 28, 2011 8:46 pm (PDT)



I have an excel file with a list of 50 stock symbols in column A. I want to get the latest stock price and have it show up in column B next to the stock symbol. How can the add-in do that?

Thanks...
-e

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

Re: How do I us this add-in to get latest stock price?

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

Sun Aug 28, 2011 8:47 pm (PDT)



Check out the documentation of the RCHGetYahooQuotes() function.

On Sun, Aug 28, 2011 at 8:11 PM, ermyers67 <ermyers67@yahoo.com> wrote:

> I have an excel file with a list of 50 stock symbols in column A. I want
> to get the latest stock price and have it show up in column B next to the
> stock symbol. How can the add-in do that?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4.

Use the plug-in for Commitments of Traders data on futures from CFTC

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

Sun Aug 28, 2011 11:31 pm (PDT)



Hi,

Has anyone found a resource where we can use the plug-in to download the historical data series of Commitments of Traders (COT) data on futures from CFTC?

We have been looking for it for a while and couldn't find it. The Excel file downloaded from the CFTC website is not easy to extract into time series.

Thanks.

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

Where to download generic xth futures contract price histories?

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

Sun Aug 28, 2011 11:31 pm (PDT)



Where can we download the price histories for generic xth futures contract for popular commodities such as oil and copper? For example generic 12th or 60th month oil futures (in Bloomberg CL12, CL60)

I know we can get the data from the Bloomberg terminal but we cannot afford it as an individual trader. Is there any cheaper way/source where we can download them? (I have IB and TOS but they don't seem to have them so I am looking at third party vendors/websites to use the plug-in for.)

End-of-day data for the past 10 years would be sufficient.

Thanks.

XP

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

Re: Where to download generic xth futures contract price histories?

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

Sun Aug 28, 2011 11:37 pm (PDT)



Check out the BarChart template in the files area.

On Sun, Aug 28, 2011 at 11:02 PM, gz_cp <gz_cp@yahoo.com> wrote:

> Where can we download the price histories for generic xth futures contract
> for popular commodities such as oil and copper? For example generic 12th or
> 60th month oil futures (in Bloomberg CL12, CL60)
>
> I know we can get the data from the Bloomberg terminal but we cannot afford
> it as an individual trader. Is there any cheaper way/source where we can
> download them? (I have IB and TOS but they don't seem to have them so I am
> looking at third party vendors/websites to use the plug-in for.)
>
> End-of-day data for the past 10 years would be sufficient.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! News

Odd News

You won't believe

it, but it's true

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
A bad score is 579. A good idea is checking yours at freecreditscore.com.
Diposting oleh EXCEL FEED LEARNING di 03.56

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)