Messages In This Digest (9 Messages)
- 1a.
- Goggle Docs From: wu_ming_sg
- 1b.
- Re: Goggle Docs From: Randy Harmelink
- 2a.
- Re: Trouble installing in Excel 2007 From: yourchef51
- 3a.
- Re: Is there an smfPricesByDates equivalent for Barchart? From: gz_cp
- 3b.
- Re: Is there an smfPricesByDates equivalent for Barchart? From: Randy Harmelink
- 3c.
- Re: Is there an smfPricesByDates equivalent for Barchart? From: gz_cp
- 4a.
- Re: Use the plug-in for Commitments of Traders data on futures from From: paul messerschmidt
- 4b.
- Re: Use the plug-in for Commitments of Traders data on futures from From: gz_cp
- 5.
- Recent Interview From: Gennady Kupershteyn
Messages
- 1a.
-
Goggle Docs
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Tue Aug 30, 2011 10:14 am (PDT)
Hi,
Do you think there is a way to integrate this plugin with Google Docs?
Regards,
- 1b.
-
Re: Goggle Docs
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 30, 2011 10:43 am (PDT)
Absolutely no way. Google docs doesn't use VBA.
You can do a few of the same things with their APIs though:
http://docs.google.com/ support/bin/ answer.py? answer=155178
On Tue, Aug 30, 2011 at 10:14 AM, wu_ming_sg <nghongchong@hotmail.com >wrote:
>
> Do you think there is a way to integrate this plugin with Google Docs?
>
- 2a.
-
Re: Trouble installing in Excel 2007
Posted by: "yourchef51" yourchef51@hotmail.com yourchef51
Tue Aug 30, 2011 10:37 am (PDT)
I am by no means an expert but I had issues with Excel 2007 too. Make sure all the spelling and punctuation is as exact as it shows, I capitalized the I in Add-In. Also I had to do some settings adjustment with Internet Explorer. And I tried to add a macro and that blocked it too. I don't know if this is what you are experiencing but this is what I went through. Good Luck.
DJ
--- In smf_addin@yahoogroups.com , "Tony Paterra" <apaterra@...> wrote:
>
> Folks,
> Sorry to be that guy who posts for help on the first install, but I've hit the wall for what I can do myself. This looks like a fantastic tool to do custom data gathering.
>
> I have followed the detailed instructions here:
> http://www.traineetrader.com/ importing- stock-quotes- to-excel- using-smf- add-in/
>
> However when I go to type in any of the "RCH" functions I don't see them appearing the way the function list normally would. The little green Excel ball at the top has SMF as "checked" in the Add-ins menu. I've tried opening a new workbook, re-opening Excel, even re-booting Windows. It all shows up the same way - Add-ins shows SMF as enabled, but not of the functions are being loaded when I try to enter in a function. I've also tried fully typing out the function name, but I get an invalid function error from Excel.
>
> Any help would be much appreciated. I'm happy to provide screenshots as well.
>
> I'm running Windows 7 and Excel 2007.
>
- 3a.
-
Re: Is there an smfPricesByDates equivalent for Barchart?
Posted by: "gz_cp" gz_cp@yahoo.com gz_cp
Tue Aug 30, 2011 10:46 am (PDT)
I downloaded 2.1.2011.04.03 from Work in Progress but the smfWord is giving me #NAME...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I don't see myself doing a function specifically for barchart.com. Partially
> because the format of the data being extracted can be different depending on
> what is being retrieved (e.g. futures vs stocks) or displayed on the chart.
>
> However, you can extract your own data by date with something like:
>
> =0+smfWord(RCHGetWebData("
> http://charts.barchart. ",com/chart. asp?sym=CLV11& data=A&den= HIGH&vol= Y
> "value='08/29/11 "),7," ")
>
> ...gives me the close for 08/29/11 for CLV11. However, I believe the
> smfWord() function is only in the beta release of the add-in (in the "Works
> in Progress" folder of the files area).
>
> On Mon, Aug 29, 2011 at 10:42 PM, gz_cp <gz_cp@...> wrote:
>
> >
> > Yahoo doesn't support commodities and currencies. When I put CLV11.NYM
> > into smfPricesByDates it returns NA.
> >
> > The current Barchart template, while accepts commodity futures and
> > currencies, can only take one ticker at a time and is not very easy to
> > process a large number of tickers like the smfPricesByDates.
> >
> > Is there an smfPricesByDates equivalent for Barchart?
> > (Or simply a =Function(Ticker, Date), without taking arrays, which is
> > actually even more flexible)
> >
> > If there is then it would be wonderful and pretty much solve all our
> > problems! (Even there isn't, I still want to say THANK YOU for your
> > fantastic add-ons)
> >
>
- 3b.
-
Re: Is there an smfPricesByDates equivalent for Barchart?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 30, 2011 11:02 am (PDT)
Did you exit and restart EXCEL? The SMF add-ins gets loaded when you start
up EXCEL. So just replacing the files alone and trying the new function
would still get you the #NAME! error because the old version of the add-in
would still be loaded.
You can always check to see which version of the add-in is loaded:
=RCHGetElementNumber("Version" )
On Tue, Aug 30, 2011 at 10:46 AM, gz_cp <gz_cp@yahoo.com > wrote:
>
> I downloaded 2.1.2011.04.03 from Work in Progress but the smfWord is giving
> me #NAME...
>
- 3c.
-
Re: Is there an smfPricesByDates equivalent for Barchart?
Posted by: "gz_cp" gz_cp@yahoo.com gz_cp
Tue Aug 30, 2011 11:49 am (PDT)
Fantastic!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Did you exit and restart EXCEL? The SMF add-ins gets loaded when you start
> up EXCEL. So just replacing the files alone and trying the new function
> would still get you the #NAME! error because the old version of the add-in
> would still be loaded.
>
> You can always check to see which version of the add-in is loaded:
>
> =RCHGetElementNumber("Version" )
>
> On Tue, Aug 30, 2011 at 10:46 AM, gz_cp <gz_cp@...> wrote:
>
> >
> > I downloaded 2.1.2011.04.03 from Work in Progress but the smfWord is giving
> > me #NAME...
> >
>
- 4a.
-
Re: Use the plug-in for Commitments of Traders data on futures from
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Tue Aug 30, 2011 12:55 pm (PDT)
while the link below is not exactly what you are looking for, it does let
you select 'futures only' or 'options and futures'.
as you can see from this chart
http://www.cftc.gov/OCE/WEB/ index.htm
<http://www.cftc.gov/OCE/WEB/ >when you add options, you can add 50%index.htm
to 100% to the open interest of 'futures only' -- which can paint a very
different market picture.
let the group know what you find
cheers
On Mon, Aug 29, 2011 at 2:22 AM, gz_cp <gz_cp@yahoo.com > wrote:
> **
>
>
> 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.
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 4b.
-
Re: Use the plug-in for Commitments of Traders data on futures from
Posted by: "gz_cp" gz_cp@yahoo.com gz_cp
Tue Aug 30, 2011 2:04 pm (PDT)
This is good but it doesn't seem to provide historical time series.
I have found that on Bigchart you can actually plot CFTC data in the technical section which I think can then be loaded into Excel with the plug-in.
--- In smf_addin@yahoogroups.com , paul messerschmidt <financepaul@...> wrote:
>
> while the link below is not exactly what you are looking for, it does let
> you select 'futures only' or 'options and futures'.
>
> as you can see from this chart
>
> http://www.cftc.gov/OCE/WEB/ index.htm
>
> <http://www.cftc.gov/OCE/WEB/ >when you add options, you can add 50%index.htm
> to 100% to the open interest of 'futures only' -- which can paint a very
> different market picture.
>
> let the group know what you find
>
> cheers
>
> On Mon, Aug 29, 2011 at 2:22 AM, gz_cp <gz_cp@...> wrote:
>
> > **
> >
> >
> > 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.
> >
> >
> >
>
>
>
> --
> --------------------- --------- --------- --
> Paul Messerschmidt
> paul.messerschmidt (skype)
> +1-813-334-8682 (mobile)
>
- 5.
-
Recent Interview
Posted by: "Gennady Kupershteyn" gennady17@yahoo.com gennady17
Tue Aug 30, 2011 6:42 pm (PDT)
I did a recent interview for the moneyshow.com. You can read or listen to
it here,
http://www.moneyshow.com/investing/ article/44/ DailyGuru- 24268/3-Recent- IPOs-Worth- Tracking& scode=024328/ .
Don't forget to vote a 10 ;o). Feel free to pass on the link.
--
Gennady Kupershteyn
Follow me on Twitter or Capitalist Bull
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