Senin, 30 Januari 2012

[smf_addin] Digest Number 2093

EXCEL Stock Market Functions Add-in

Messages In This Digest (9 Messages)

Messages

1.

Bid to sponsor girl child education in Gujarat

Posted by: "mdkumar kumar" mdkumarz@gmail.com   mdkumarz

Sun Jan 29, 2012 4:58 am (PST)



[image: DeshGujarat.Com] <http://deshgujarat.com/>

- GUJARAT <http://deshgujarat.com/category/gujarat-2/>
- BUSINESS <http://deshgujarat.com/category/business/>
- POLITICS <http://deshgujarat.com/category/politics/>
- FAITH <http://deshgujarat.com/category/faith/>
- TRAVEL <http://deshgujarat.com/category/travel/>
- ENTERTAINMENT <http://deshgujarat.com/category/entertainment/>
- SERVICES <http://deshgujarat.com/category/services/>
- INDIA/WORLD <http://deshgujarat.com/category/indiaworld/>
- MORE <http://deshgujarat.com/category/extras/>

<http://www.facebook.com/deshgujarat><http://feeds.feedburner.com/DeshGujarat/news>
<http://twitter.com/#!/DeshGujarat>
Home <http://deshgujarat.com/> »
Gujarat<http://deshgujarat.com/category/gujarat-2/>
» Ahmedabad <http://deshgujarat.com/category/gujarat-2/ahmedabad/> » Sachin
Tendulkar's t-shirt and 1300 more gifts of Narendra Modi exhibited for
auction, watch in photos
Sachin Tendulkar's t-shirt and 1300 more gifts of Narendra Modi exhibited
for auction, watch in photos
January 29, 2012 DeshGujarat <http://deshgujarat.com/author/japan-3/>

- <http://deshgujarat.com/2012/01/29/sachin-tendulkars-t-shirt-and-1300-more-gifts-of-narendra-modi-exhibited-for-auction-watch-in-photos/?share=email&nb=1>
- <http://deshgujarat.com/2012/01/29/sachin-tendulkars-t-shirt-and-1300-more-gifts-of-narendra-modi-exhibited-for-auction-watch-in-photos/#print>
-
-
-

*Ahmedabad, 29 January, 2012*

As many as 1393 gifts presented to Chief Minister Shri Narendra Modi at
various public functions were exhibited at Ahmedabad's Ravishankar Rawal
art gallery between 27-29 January. A list of gifts that were exhibited for
auction includes 208 objects of gold and silver, 377 memento, 225 photo
frames and paintings, 154 turbans, 328 shawl etc. Sachin Tendulkar's
t-shirt was also part of the exhibition. Visitors were given a form, in
which he/she had to write a code number of particular piece, its base
value, its bid value(as per your wish), your name, address, phone number
and signature(DeshGujarat visited and filled forms for two things, a
traditional dress of Tarnetar fair and Shri Somnath's 3-d photo frame. It
was told that whether your bid was highest or not would be notified on
phone call on Monday).

Photo with Kalam while visiting a laboratory

Dholka office where Narendra Modi worked in early years of political career

Thsi gift was presented to Modi by an African nation's Vice President

Ahmedabad based Rizwan Kadri presented this painting of Ravishankar Rawal
to Modi.

This is how forms were filled up for bid to purchase any of the gifts

This Dhaal was given to Modi by Amreli BJP

Sun temple of Modhera looks wonderful in this carved wall piece

This chariot was gifted to Modi by Gujarati people of Gondia

And look at Gadaas

A miniature of Ahmedabad's Patang hotel, highly decorated

An art piece

Swords, just too many … It seems people like to gift swords to Modi the
most

Tadpu is south Gujarat's tribal music instrument, who will buy it? It was
defective

Ploughs, too many. Farmers love to gift 'hal' to Modi

This small bamboo house is temple of tribal Pandori mata of Narmada
district

A boat, gifted to Modi by party's fishermen cell leader

Assamese hates

Patan Patola piece of handkerchief. It's base price was Rs 7,000

Textile pieces, many traditional cloths, turbans, shawls and else

Tendulkar's t shirt

A photo with Birla family, that too was for auction

Recent relevent article in:
Ahmedabad<http://deshgujarat.com/category/gujarat-2/ahmedabad/>
, Gujarat <http://deshgujarat.com/category/gujarat-2/>, Narendra
Modi<http://deshgujarat.com/category/politics/narendra-modi/>
, Politics <http://deshgujarat.com/category/politics/>
<< Previous Post<http://deshgujarat.com/2012/01/29/modi-stays-away-from-uttarakhand-punjab-poll-campaign/>
Leave a Reply

Your email address will not be published.

Name

Email

Comment

RECENT POSTS

- Sachin Tendulkar's t-shirt and 1300 more gifts of Narendra Modi
exhibited for auction, watch in
photos<http://deshgujarat.com/2012/01/29/sachin-tendulkars-t-shirt-and-1300-more-gifts-of-narendra-modi-exhibited-for-auction-watch-in-photos/>
- Modi stays away from Uttarakhand, Punjab poll
campaign<http://deshgujarat.com/2012/01/29/modi-stays-away-from-uttarakhand-punjab-poll-campaign/>
- Khadia's Sunday morning with crowds, kites and Amitabh
Bachchan<http://deshgujarat.com/2012/01/29/khadias-sunday-morning-with-crowds-kites-and-amitabh-bachchan/>
- "Modi has proved himself, Rahul is yet to prove himself, there's no
comparison between
two"<http://deshgujarat.com/2012/01/29/modi-has-proved-himself-rahul-is-yet-to-prove-himself-theres-no-comparison-between-two/>
- Amitabh Bachchan's Patan shoot over, he is in
Amdavad<http://deshgujarat.com/2012/01/28/amitabh-bachchan-arrives-in-ahmedabad-for-36-hours-stay/>
- 'Der aaye durast aaye' says Gujarat BJP on Congress ad praising
Modi<http://deshgujarat.com/2012/01/28/der-aaye-durast-aaye-says-gujarat-bjp-on-congress-ad-praising-modi/>
- Vadodara to get new flyover named after 'Sayajirao Gaikward third'
this Monday, VUDA plans two ring
roads<http://deshgujarat.com/2012/01/28/vadodara-to-get-new-flyover-named-after-sayajirao-gaikward-third-this-monday-vuda-plans-two-ring-roads/>
- Minister Saurabh Patel on Gujarat's infrastructural strengths and next
set of challenges in pipeline(English speech
video)<http://deshgujarat.com/2012/01/28/minister-saurabh-patel-on-gujarats-infrastructural-strengths-and-next-set-of-challenges-in-pipelineenglish-speech-video/>
- Taarak Mehta Ka Ooltah Chashmah:Kutch
episodes(Videos)<http://deshgujarat.com/2012/01/28/taarak-mehta-ka-ooltah-chashmahkutch-episodesvideos/>
- NRI Gujarati who offered drugs to undercover female detective in
exchage of sex
held<http://deshgujarat.com/2012/01/28/nri-gujarati-who-offered-drugs-to-undercover-female-detective-in-exchage-of-sex-held/>
- Amitabh Bachchan overwhelmed at Sun temple
Modhera<http://deshgujarat.com/2012/01/27/amitabh-bachchan-overwhelmed-at-sun-temple-modhera/>
- News in brief from across Gujarat, January 27th,
2012<http://deshgujarat.com/2012/01/27/news-in-brief-from-across-gujarat-january-27th-2012/>
- Gujarat BJP state executive meeting on 29
January<http://deshgujarat.com/2012/01/27/gujarat-bjp-state-executive-meeting-on-29-january/>
- Narendra Modi opens senior IAS officer's Photo
exhibition(Photos/Video)<http://deshgujarat.com/2012/01/27/narendra-modi-opens-senior-ias-officers-photo-exhibitionphotos/>
- Construction of a new 134-room Shri Somnath Maheshwari Samaj Atithi
Gruh kicks off at
Somnath<http://deshgujarat.com/2012/01/27/construction-of-a-new-134-room-shri-somnath-maheshwari-samaj-atithi-gruh-kicks-off-at-somnath/>

About Us <http://deshgujarat.com/about-desh-gujarat/>| Contact
Us<http://deshgujarat.com/contact-us/>
|Gujarat Money <http://www.gujaratmoney.com/>|Gujarati
Calender<http://deshgujarat.com/2008/01/27/gujarati-calendar-2008-vikram-samvat-year-2064/>
|Gujarati Recipe<http://deshgujarat.com/gujarati-recipes-explained-in-gujarati-a-complete-database/>
|Write In Gujarati<http://deshgujarat.com/2009/05/29/google-makes-it-easy-to-write-in-gujarati-online/>
|Gujarat Weather <http://www.imdahm.gov.in/>| Gujarati
Dictionary<http://gujaratilexicon.com/>
|Discourses(Audio)<http://deshgujarat.com/2008/03/13/downloadswami-sachchidanandjis-2210-speechesmp3/>
|News Links <http://deshgujarat.com/now>
Powered by WordPress <http://wordpress.org/> | Designed by:
diet<http://www.spdiet.com/> |
Thanks to lasik <http://optometry.com/>, online
colleges<http://www.bestonlinecollegesdegrees.com/>
and seo <http://www.seo.us.com/>

--
Yours sincerely,
Draksharamam Kumar Mandavilli
mdkumarz@gmail.com,
91-7737255159
2a.

Issues moving to a new computer

Posted by: "swiftyjpowell" telework@live.com   swiftyjpowell

Sun Jan 29, 2012 4:09 pm (PST)



Hello,

I recently moved to a new computer and my spreadsheets no longer seem to be associated with the .XLA file. When I open the spreadsheet all of the formulas have been preceded with "C:\Program Files\SMF Add-In.

I'm using Excel 2010 32-bit.

Two things of note:

1) The location is identical to the location on my original computer. So even if I use find/replace to remove these entries the formulas do not work.
2) If I open the RCH_Stock_Market_Functions.xla file first and then open my spreadsheet everything works fine.

So it seems as though the XLA file need to be registered or identified in settings somewhere? I'm not sure.

If anyone can help it would be greatly appreciated. One of these spreadsheets is critical to my trading which begins first thing tomorrow morning!

Thanks,

Josh

2b.

Re: Issues moving to a new computer

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

Sun Jan 29, 2012 4:22 pm (PST)



The only reason you should have those paths prefixes is that EXCEL
couldn't resolve the links. If using the Find and Replace process
doesn't fix the problem, that would mean to me the add-in isn't
installed on the new machine. If you start up EXCEL and open up a new
worksheet immediately (without manually opening the XLA file), what do
you get when you enter this formula:

=RCHGetElementNumber("Version")

When you open the XLA file first, you give it something to replace the
resolution of those links. That's basically what happens when you
install the XLA as an add-in -- when you open EXCEL, it opens all of the
installed add-ins as well.

Remember, your workbooks are NOT directly associated with the add-in.
EXCEL reconciles the locations with your installed add-in when it opens
the workbooks. It is those hard-coded location links that allows EXCEL
to resolve the links. But it can only resolve the links if the add-in is
in the same location and is installed as an add-in (or manually opened).

On Sun, Jan 29, 2012 at 5:09 PM, swiftyjpowell <telework@live.com>
wrote:

I recently moved to a new computer and my spreadsheets no longer seem to
be associated with the .XLA file. When I open the spreadsheet all of the
formulas have been preceded with "C:\Program Files\SMF Add-In.

I'm using Excel 2010 32-bit.

Two things of note:

1) The location is identical to the location on my original computer. So
even if I use find/replace to remove these entries the formulas do not
work.
2) If I open the RCH_Stock_Market_Functions.xla file first and then open
my spreadsheet everything works fine.

So it seems as though the XLA file need to be registered or identified
in settings somewhere? I'm not sure.

If anyone can help it would be greatly appreciated. One of these
spreadsheets is critical to my trading which begins first thing tomorrow
morning!

2c.

Re: Issues moving to a new computer

Posted by: "swiftyjpowell" telework@live.com   swiftyjpowell

Sun Jan 29, 2012 4:30 pm (PST)



Hi Randy and thanks for the quick reply. It had been running so smoothly for the last year that I had forgotten some of the details.

So basically I had simply forgotten that you must enable the Add-In by going to Add-Ins/Browse and selecting the XLA file. That is what creates the link.

Everything is good now. Great Add-in BTW. I have a spreadsheet that tracks all of my trades and provides some position sizing info for option data downloaded.

Regards,

Josh

3a.

Trouble Finding Add in

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

Sun Jan 29, 2012 4:57 pm (PST)



Just Downloaded Add In.... Excel Wont bring up ADD Ins tab. Cant access the program. Any advice

3b.

Re: Trouble Finding Add in

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

Sun Jan 29, 2012 5:50 pm (PST)



There's nothing on the add-ins tab related to the SMF add-in. The SMF
add-in is primarily a collection of user-defined functions.

On Sun, Jan 29, 2012 at 5:27 PM, jamesrice397 <jamesrice397@yahoo.com>
wrote:
Just Downloaded Add In.... Excel Wont bring up ADD Ins tab. Cant access
the program. Any advice

4a.

using results of RCHGetHTMLTable in Excel formula -> feature request

Posted by: "sharilady@rocketmail.com" sharilady@rocketmail.com   sharilady@rocketmail.com

Sun Jan 29, 2012 11:21 pm (PST)



Hi,

I'm currently working on a sheet where I would like to use the results of RCHGetHTMLTable (among others) in a formula. One can think about pulling one row of data and directly calculating the average of the values without displaying them.

Although the function provides parameters pDim1 and pDim2, if called from within a workbook, these values will be reset by Application.Caller.Rows.Count. I'm also quite curious about the first couple of lines in the code, because for example bType will always(!) be set to 1. The intended error handling might not properly work here.

Did you ever think about passing the intended dimensions for the results of the function and forcing them to be used? An additional boolean parameter which handles the useage of Application.Caller... might already do the trick. This could also be used for some other functions which seem to be working in a similar way.

Could this be an idea for the next version of this wonderful tool?

Cheers,
sharilady

4b.

Re: using results of RCHGetHTMLTable in Excel formula -> feature req

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

Sun Jan 29, 2012 11:41 pm (PST)



Just pick up the beta version of the add-in from the "Works in Progress"
folder. The change you want, if it's working right, should be the first
change I made after the last official release. From the change log:

Date Routine Description 2010-08-12 RCHGetHTMLTable
Modified pDim1/pDim2 processing so the array size can be overridden
from either VBA or from the worksheet. This allows other functions like
TRANSPOSE() to manipulate the returned results correctly.
I think all of the functions that return an array of data now operate
the same way in terms of the pDim1 and pDim2 parameters.

On Mon, Jan 30, 2012 at 12:21 AM, sharilady@rocketmail.com
<sharilady@rocketmail.com> wrote:

I'm currently working on a sheet where I would like to use the results
of RCHGetHTMLTable (among others) in a formula. One can think about
pulling one row of data and directly calculating the average of the
values without displaying them.

Although the function provides parameters pDim1 and pDim2, if called
from within a workbook, these values will be reset by
Application.Caller.Rows.Count. I'm also quite curious about the first
couple of lines in the code, because for example bType will always(!) be
set to 1. The intended error handling might not properly work here.

Did you ever think about passing the intended dimensions for the results
of the function and forcing them to be used? An additional boolean
parameter which handles the useage of Application.Caller... might
already do the trick. This could also be used for some other functions
which seem to be working in a similar way.

Could this be an idea for the next version of this wonderful tool?

5.

Morningstar Stock Type & Stock Style

Posted by: "V. Shankar" tarakayan@yahoo.com   tarakayan

Mon Jan 30, 2012 2:44 am (PST)



http://quote.morningstar.com/stock/s.aspx?t=AAPL 

I was looking at some of the morningstar examples for MF style %s.  

How do we extract the stock profile details like sector, industry, stock type, stock style from morningstar?

Sector 
Technology
Industry 
Computer Systems
Stock Type 
Cyclical
Employees 
63,300
Fiscal Year Ends 
September
Stock Style 
Large Growth
Recent Activity
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 business?

Get new customers.

List your web site

in 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

Tidak ada komentar:

Posting Komentar