Messages In This Digest (4 Messages)
- 1a.
- Re: windows 7 excel 2010 migration From: Steve Smith
- 2a.
- Re: Freeware TA add-on From: sergeh3
- 2b.
- ^GSPC volume data not right From: Daniel Perciballi
- 2c.
- Re: ^GSPC volume data not right From: Randy Harmelink
Messages
- 1a.
-
Re: windows 7 excel 2010 migration
Posted by: "Steve Smith" svitil@yahoo.com svitil
Mon Jul 11, 2011 5:27 am (PDT)
On Win7, the Excel 2010 addin directory is
C:\Users\[Your User Name]\AppData\Roaming\Microsof t\AddIns
If you can store the files there Excel will find them - note that I have admin permissions on my system. I am new to the addin (thanks Randy!), so I can't compare my experience with any other OS/Excel versions.
-Steve
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, July 10, 2011 5:51 PM
Subject: Re: [smf_addin] windows 7 excel 2010 migration
The add-in should be able to be located anywhere you want, or anywhere your system will allow you to put it. Same for your data files. The only issue is if you open a workbook that was saved with the add-in in a different location than where you system has it. In that case, you need to manually edit the links (see the #NAME? item in the "Links" area of the group).
But I have no direct experience with either Win7 or EXCEL 2010.
On Sun, Jul 10, 2011 at 5:42 PM, Hal Maughan <hal@kerimaughan.com > wrote:
I've used the add-in for over 2 years and love it - thank you Randy!
>I recently migrated to win 7 excel 2010 and re-installed the add-in per instructions. The first time I ran the macro it worked like a charm. I attempted to save the data file in the c:\program files\SMF Add-in folder as I had done in prior versions and it won't save there. My IT guy says I have to save it in my "my documents" area - can't save straight to the C: drive with win 7 due to new "protections". When I saved to "My documents" area and tried it again, it gave the "non-responding" error for excel.exe and locked up. Not sure what to do. I couldn't find anything in the search of prior posts. Any suggestions on how to overcome this?
>
- 2a.
-
Re: Freeware TA add-on
Posted by: "sergeh3" sergeh3@yahoo.com sergeh3
Mon Jul 11, 2011 5:46 pm (PDT)
i just wanted to thank everyone for taking the time to help me out and for clarifying the pricing confusion (open source vs commercial version) and clarifying which of the several zip-files to download.
thank you all.
--- In smf_addin@yahoogroups.com , "boo1712" <boo1712@...> wrote:
>
> http://prdownloads.sourceforge. net/ta-lib/ ta-lib-0. 4.0-msvc. zip
> Unzip it and register the file "ta-lib.xll" as an excel add-in.
> It is totally free with more TA indicators then you may need.
> As with alot of free stuff, it just lacks documentations, but it works.
>
>
>
>
> --- In smf_addin@yahoogroups.com , "sergeh3" <sergeh3@> wrote:
> >
> > team,
> > does anyone know of an add-on for performing technical analysis via excel (eg, Bollinger Bands, exponential moving averages, etc) that is truly freeware (no trial-versions, etc)? any help would be appreciated, thanks a million in advance.
> >
>
- 2b.
-
^GSPC volume data not right
Posted by: "Daniel Perciballi" dperciballi@yahoo.com dperciballi
Mon Jul 11, 2011 7:41 pm (PDT)
Hi -
I have this command to get shares traded in the S&P 500: =RCHGetYahooQuotes("^GSPC"," v")
This is returning 634,678,144 and is clearly not correct. Also - during my investigation I looked at previous day's volume data for this command and it does not match what Yahoo is showing on the historical prices for this "ticker": http://finance.yahoo.com/ ^GSPC+Historical+q/hp?s= Prices
For exaample - this command returned a value of 2,265,569,280 on July 8 while Yahoo shows it as 3,594,360,000 on the actual webpage.
Why is the command not returning the same as what Yahoo Finance shows on the webpage.
This only occurs for this "ticker". Other tickers return a number that matches or is very close to the number displayed on the Historical Prices section for that ticker symbol.
Thanks,
Dan
>____________________ _________ ___
>From: sergeh3 <sergeh3@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Monday, July 11, 2011 8:45 PM
>Subject: [smf_addin] Re: Freeware TA add-on
>
>
>
>
>i just wanted to thank everyone for taking the time to help me out and for clarifying the pricing confusion (open source vs commercial version) and clarifying which of the several zip-files to download.
>thank you all.
>
>--- In smf_addin@yahoogroups.com , "boo1712" <boo1712@...> wrote:
>>
>> http://prdownloads.sourceforge. net/ta-lib/ ta-lib-0. 4.0-msvc. zip
>> Unzip it and register the file "ta-lib.xll" as an excel add-in.
>> It is totally free with more TA indicators then you may need.
>> As with alot of free stuff, it just lacks documentations, but it works.
>>
>>
>>
>>
>> --- In smf_addin@yahoogroups.com , "sergeh3" <sergeh3@> wrote:
>> >
>> > team,
>> > does anyone know of an add-on for performing technical analysis via excel (eg, Bollinger Bands, exponential moving averages, etc) that is truly freeware (no trial-versions, etc)? any help would be appreciated, thanks a million in advance.
>> >
>>
>
>
>
>
> - 2c.
-
Re: ^GSPC volume data not right
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jul 11, 2011 7:52 pm (PDT)
That is what Yahoo is returning for the data request. There is nothing I can
do about it. You'll need to contact Yahoo to find out why they are reporting
volumes you consider to be incorrect.
PS: Please start a new thread when changing the topic instead of hijacking
an existing one. Thanks.
On Mon, Jul 11, 2011 at 7:41 PM, Daniel Perciballi <dperciballi@yahoo.com >wrote:
>
> I have this command to get shares traded in the S&P 500:
> =RCHGetYahooQuotes("^GSPC"," v")
>
> This is returning 634,678,144 and is clearly not correct. Also - during my
> investigation I looked at previous day's volume data for this command and it
> does not match what Yahoo is showing on the historical prices for this
> "ticker": http://finance.yahoo.com/ ^GSPC+Historical+q/hp?s= Prices
>
> For exaample - this command returned a value of 2,265,569,280 on July 8
> while Yahoo shows it as 3,594,360,000 on the actual webpage.
>
> Why is the command not returning the same as what Yahoo Finance shows on
> the webpage.
>
> This only occurs for this "ticker". Other tickers return a number that
> matches or is very close to the number displayed on the Historical Prices
> section for that ticker symbol.
>
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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