The Dollar Stretcher, helping others live better for less since 1996, presents a huge compilation of money-saving tips. Hundreds of readers’ tips can save hundreds of dollars in home, auto, family, food, health & beauty, holiday & special occasions & more
BUY NOW: The Dollar Stretcher Store
On August 28, 2010, In stock market ticker, by admin
On August 16, 2010, In stock market ticker, by admin
With this handy piece of software you can create your own affiliate niche stores automatically. Works with the eBay® Partner Network, Amazon and Commission Junction affiliate programs (more to come!). Free upgrades.
BUY NOW: Jonathan Castro’s Automatic Niche Store Generator
On June 2, 2010, In stock market ticker, by admin
http://finance.yahoo.com/tech-ticker/article/320517/Its-Too-Late-to-Save-Sears%2C-Matthews-Says
Kmart tried to save Sears when purchasing the department store a few years ago. But Kmart itself is even struggling to compete with discounted stores like Walmart and Target. Sears cannot compete with low-end department stores like Kohl’s and JCPenney.
To be frank, I don’t think that I have a racial bias, as I have a lot of Latino friends and I like to speak Spanish, too. But if I see a store having many Latino shoppers, I can pretty much predict the designs, styles and quality of the products there. And I would less likely shop there. I truly admire celebrities like Jennifer Lopez, Paulina Rubio, Angelina Jolie, Christina Aguilera, and Selena for their looks and styles. But when I look at Latino women in the area where I live, they are truly out of shape and out of styles, and most of them either do not speak English, are on welfare/WIC, and teenage mothers. So my question is, is the customer base a factor in determining success of a business? Or should we blame Sears marketing and merchandising management team for not making Sears attractive to US consumers?
@ Pinolera: Thanks for your input. Very well structured thoughts!
On May 21, 2010, In stock market ticker, by admin
Hello
This macro exports a column from Excel to Access (Thanks Garbo!).
I need to set it so that each time it exports, it clears the Access table of all data before pasting.
How can I do this?
Sub EXPORT_ADO_ExcelToAccess()
‘ exports data from the active worksheet to a table in an Access database
‘ this procedure must be edited before use
Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
‘ connect to the Access database
Set cn = New ADODB.Connection
cn.Open “Provider=Microsoft.Jet.OLEDB.4.0; ” & _
“Data Source=C:\Documents and Settings\HowAlex\Desktop\db1.mdb;”
‘ open a recordset
Set rs = New ADODB.Recordset
rs.Open “TestEquities”, cn, adOpenKeyset, adLockOptimistic, adCmdTable
‘ all records in a table
r = 2 ‘ the start row in the worksheet
Do While Len(Range(“A” & r).Formula) > 0
‘ repeat until first empty cell in column A
With rs
.AddNew ‘ create a new record
‘ add values to each field in the record
.Fields(“Security (ISIN)”) = Range(“A” & r).Value
.Fields(“Designation”) = Range(“B” & r).Value
.Fields(“BBG Format”) = Range(“C” & r).Value
.Fields(“Security Name”) = Range(“D” & r).Value
.Fields(“Asset Type”) = Range(“E” & r).Value
.Fields(“Ticker”) = Range(“F” & r).Value
.Fields(“Industry / Sector”) = Range(“G” & r).Value
.Fields(“Last Price”) = Range(“H” & r).Value
.Fields(“Current Market Cap”) = Range(“I” & r).Value
‘ add more fields if necessary…
.Update ‘ stores the new record
End With
r = r + 1 ‘ next row
Loop
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
‘ The macro example assumes that your VBA project has added a reference to the ADO object library.
‘ You can do this from within the VBE by selecting the menu Tools, References and selecting Microsoft
‘ ActiveX Data Objects x.x Object Library.
‘ Use ADO if you can choose between ADO and DAO for data import or export.
end sub
Thank you very much
It doesn’t work.. could you please indicate where exactly this should be called from?
Also, I hope this doesn’t wipe out the column headers, they are vital :\
On May 7, 2010, In stock market ticker, by admin
i.e. – Speaking to my financial adviser in North Dakota, she recommended that I should purchase 20 shares of Cellu Tissue Holdings, Inc. (CLU), an initial public offering at 12.901 per share. Over the next couple of days, the climbed 12 basis points yielding 9.5 percent I rolled my capital gains and invested in Jo-Ann Stores (JAS) at 35.201 per share. Later in the month, I sold short some of the shares. Over the next couple of days I picked 40 shares of Black Rock Income Trust (BKT) at 20.146 per share.
AND
Summering in West Virginia during 2008, it was a tough time for the market, with the failure of Bear Sterns and Lehman’s. I cashed out 50 shares of ACE Limited (ACE) at 48.234 due to the insurance industry taking a hit in the financial crisis, and converted to treasury bonds, which kept my losses to a minimum and cover my margins Recently recognizing that the airline industry is stabilizing and fundamentals looked good. I dived back into equities and purchased 40 shares of Continental Airlines (CAL) at 18.751 per share. Then, realizing that any growth in the first quarter will take place in the technical sector, I decided to purchase Affiliated Computer Services (ACS) at 59.801 per share to hedge against any losses.
It’s a puzzle and I’m looking for a three digit number out of each paragraph.
The information given is…
Current Ticker
HD 29
MSFT 20.567
CSCO 23.484
STC 20.121
GOOG 533.221
HPQ 48.432
ACE 20.765
JAS 36.223
CLU 11.332
CAL 19.557
BKT 6.639
ACS 32.889
MFT 13.647
IBM 124.547
On April 25, 2010, In stock market ticker, by admin
1. Insider Buying Information
Click Here to Get Best Day Trader Tools
Insiders are company’s CEO, Chairman, board directors,
executive vice president of various departments.
Insider buying information top my list for obvious reasons.
Insiders have lots of reasons to sell their shares: buying a
house, huge vacation expense, etc. However, there is usually
only one reason when insiders buy their company’s shares
with their personal money: the insiders believe the stock
price are cheap and they can make money by buying their own
stocks.
Insider buying information is also very informative to
understand market sector movement. Many time I looked at
the insider buying information from sector point of view.
Certain sector during certain period of time constantly had
insider buying activities from different companies of the
same sector, which could indicate a sector wide
undervaluation or bullishness. That was exactly what I found
in late 2003 and early 2004 when I found insiders of lots of
oil and natural gas companies constantly buying their
stocks. Eventually I picked two oil and gas stocks in late
2003 and early 2004 Whiting Petroleum (ticker WLL) and
Chesapeake Energy (Ticker CHK) from insider buying
information and they have been huge success for my premium
investment newsletter Blast Investor Real-time Plus (BIRTP)
and rewarded myself financially very significantly.
2. Guru Watch
It is certainly worth the effort to track stock picks or
ideas from legendary gurus such as Warren Buffet, Eddie
Lambert, Jim Rogers, etc.
Wall Street Journal is great source of investment and
financial information. My 2003 stock pick PetroChina (PTR)
was from an article of Wall Street Journal, which published
news of Warren Buffet buying PTR. I immediately bought into
PTR stock on the same day that I read the article and
profited handsomely from this pick.
Warren Buffet is the best value investor in the world and
you can not afford to ignore him. One way to track Warren
Buffet picks is to go to Yahoo Finance and then read news
headlines under stock ticker of BRK-A.
Recently, internet information grew so large and I believe
it is now much easier to track gurus from web rather than
reading newspapers or magazines. An easier way to track guru
picks is to use tracking services offered in the web. Here I
highly recommend the tracking service provided by
Gurufocus.com. Gurufocus tracks almost all the
value-oriented Wall Street gurus. Their list of gurus is
huge, Warren Buffet, Edward Lambert, George Soros, etc. They
even publish a newsletter alerting you the latest guru buy
and sell actions. Their service is great and best yet, it
is all free!
Click Here to Get Best Day Trader Tools
3. Software Screening Tool
BlastInvest operates internally a Mysql based relational
database storing about seven thousand stocks with all kinds
of valuation metrics and tools that I can do for Benjamin
Graham NCAV ranking, return on equity modeling, low pe or
low price to sale screening, etc. We update database
information every week and I constantly mine the database
looking for the huge winner that can reward both me and my
newsletter readers.
Insider buying information could be even more powerful when
you can combine insider buying information with valuation or
strategy screening, which exactly what we do at BlastInvest
with this powerful internal relational database.
However, I found the free or cheap screening tools out there
in the web are not impressive. Validea.com tool is nice, but
it lacks the powerful feature that I want. Yahoo tool or MSN
tool works, but still they are not for power value
investors. Therefore, I may rank my internal screening tool
very high for getting stock leads, you may be dissappointed
if you do not have access or can not pay for those powerful
tools at reasonable cost.
4. Online Message Board Networking
Stock message boards are wild and you may be surprised that
I put this as one of top sources of information for getting
stock leads. Well indeed, I got tips and found very solid
stock leads from internet message boards.
Actually, I started myself as quite wild BBS stock guru many
years ago before I started blastinvest.com newsletter
business. Lots of Chinese American friends who frequently
visit big online BBS (mitbbs.com, or goofiz.com) would know
my past track record very well. My past BBS investment
performance certainly beat performance of most if not all of
the value mutual funds hands down. My past history
certainly can tell you something on the nature and quality
of message boards. Sure, most of BBS members probably are
not investing gurus, and some folks in the stock forum may
well be dangerous stock promoters or hypers. But certainly
there are some excellent stock gurus there and there are
valuable investing or stock pick information there. So just
be careful and do your homework when you use information
from online stock boards.
Two of the well known value investing forums in US are
Valueforum and Value Investor Club. Unfortunately,
Valueforum is fee based message board and you can not post
any messages without paying fee. Value Investor Club seems
to reject beginners or amateurs and they only want gurus
(maybe Wall Street Gurus) offering stock tips to each other.
I myself certainly disagree with approaches of Valueforum or
Value Investor Club. That is why Blastinvest LLC recently
launched a free forum dedicated for individual value
investors: value-investing-forum.com. For more information
on why you should participate in a forum regardless whether
you are a value investing beginner or a savvy value
investor, please click here:
http://value-investing-forum.com/viewtopic.php?t=483
5. Traditional Newspapers and Magazines
This group includes Investor’s Business Daily, Forbes,
Fortune, Barrons, etc, I read them all from time to time.
If you live near New York city and tune in to Bloomberg
radio, you are going to hear bombardment of ads such as
“Barrons, the best source of stock investing information”.
However, my rating on their capability of giving me stock
leads or ideas are poorer than above channels. The stock
picks published in the public media are pretty mediocre.
Of course, I still believe they are very useful information
to understand economics and to know what Wall Street gurus
are doing or thinking. So they may not be worth subscription
fee for you to pay, they are certainly worth your time to
visit public library once a while to read them.
On April 12, 2010, In stock market ticker, by admin
If You Are Single And Looking For A Sweetheart, Your Sweetheart Store Has Just What You Need. Purchase Romance Coach Kathryn Lord’s Ebooks, Articles And Eworkshops, Written With You In Mind. Let Kathryn Help You Find Love.
BUY NOW: Your Sweetheart Store.
On March 31, 2010, In stock market ticker, by admin
New Max Sale Now $97 Plus Recurring Monthly Product! Testimonials, Great Niche! High Conversions! 60% Payout! The Most Powerful Set Of Medical Coding Exam Prep Tools Available Period! Includes Our Entire Medical Coding Store. Join This Exploding Niche Now.
BUY NOW: Medical Coding Practice Exam Store!
On March 18, 2010, In stock market ticker, by admin
The sports retail and manufacturing industry is worth billions in revenue. Passions do not come cheap so maybe you can turn your enjoyment into making a few dollars.
Dick’s Sporting Goods is a multi sport equipment, apparel and general store. The passion of the owner Dick borrowed $300 from his grandmother and opened a bait and tackle store in 1958. Today Dick’s Sporting Goods is located in 34 states with 315 stores. In addition, he owns Golf Galaxy a multi-channel golf specialty retailer with 77 stores. The stock sells on the New York Stock Exchange with the stock ticker DKS. The stock currently sells for about $70 per share. It enjoys a market cap of over 3.5 billion dollars. The stock has some big name holders like Citigroup, Oppenheimer and Goldman Sachs.
Foot Locker Inc. is another sports shoes and apparel shop that has a significant market share of sports market. The stock sells on the NYSE for $16.71 a share. It trades under the stock ticker FL. It has some room to go back up to the $40 range where it belongs. Some weakening in the retail area and other concerns have weighed on this stock. It is a good stock and worth watching.
Cabela’s is a Nebraska sports and apparel company that sells on-line. It has store outlets that are an adventure for any shopper. Cabela’s is a success story and when the jitters in the market subside it will soar. It is priced currently in the high $20 range and worth every dime. It trades under symbol CAB.
Nike Inc. is a familiar brand name for most sports fans and enthusiasts. The stock is sold on the New York Stock Exchange. The stock symbol is NKE. The company sells apparel, shoes and accessories. The company has a 28.2 billion dollar market share. Nike employs over 32,000 employees. Nike is priced currently at $58 per share. The stock is expected to climb as high as $70 per share. Some of the major holders are Barclay’s Global Fund, Fidelity Blue Chip Fund, Vanguard 500 Index Fund and some other blue ribbon funds.
The combined efforts of Molson Brewing Company of Canada and Coors Brewing Company in recent years created the Molson Coors Brewing Company. The market cap and distribution of the company is tremendous. It employs 11,000 people. It has plans to open a new subsidiary. It is going through a shift in upper management, but it is a sold investment to keep on your radar. The stock symbol is TAP and sells in mid to high $80. The company has a blue ribbon list of holders of the stock. Barclays Global Fund, Vanguard Group, and Goldman Sachs are a sample of their investors.
The sports fan has lots of opportunities to invest in their passion and enjoy the game as a participant in the sheer fun of making a few dollar in the process.
On March 6, 2010, In stock market ticker, by admin
Tap Into The Buying Power Of 13 Million Yahoo! Shoppers To Make More Than $3,470 A Month Without Owning Any Merchandise.
BUY NOW: Yahoo Store Profits.
Recent Comments