Yahoo! Import Update

If you enjoy the following, consider signing up for the Gödel's Market Newsletter.

I still haven't wrapped everything up into an installer. Here, however, is an up-to-date screenshot. I don't think these features will be available in the free version, but I added:

- Multiple symbols (separated by " ,") imported at once
- A way to choose how far back the data goes (jan = 00...dec = 11) so that you can update daily without inserting repeat data (I'll probably add something to make sure you're not adding repeats later).

That's it for the moment. I do want to add a txt file loader (with symbol info) and a way to capture dividend data. Perhaps I'll make one for economic and earnings data too.

(If you've enjoyed this, consider signing up for the Gödel's Market Newsletter.)

Import Yahoo Stock CSV Files into MySQL -- Program

If you enjoy this article, consider signing up for the Gödel's Market Newsletter.

This is a very preliminary version (Windows 7 tested) of what I intend to create. But, I thought I would share it.

What the program does:

- Downloads the CSV file of the specified stock symbol from Yahoo! Finance.

- Adds a column in the CSV file with symbol info so that you can insert multiple stock tickers in the same table and sort them by "Symbol."

- Connects to the selected database and inserts the data into a table called "stock_prices_day" with column values "Symbol", "Date", "Open", "High", "Low", "Close", "Volume", "Adj_Close".

-There are simple modifications that may need to be made in order for this to run on machines besides my own. I'll try to get around to it as soon as I find the errors.

- There are more complicated modifications that would obviously be nice, which I will (and have) work on. These will likely be kept to myself, unless there is substantial interest. Donations would be nice given that even the simple version took me quite some time to put together... :D (plus the benefits of this program to a quantifiable trading setup are large).

License Requirements:

- This is for personal use only.

- I do not guarantee it will work.

- I don't believe it will damage anything you own, but it possibly could.

- It gives no investment advice; it is merely a tool.

- It does not come with source.

If you would like the source, I am willing to talk. I'm going to update it somewhat, because it will probably malfunction on a system that isn't my own (hard written directories, perhaps, and dll file requirements).

Here is a screenshot followed by the download.

Download - Sorry, I have to find somewhere to upload the file...I guess blogger doesn't have anything built in. (Try This)  I'm going to have to build this into an installer...hmm. 

(If you've enjoyed this article, consider signing up for the Gödel's Market Newsletter.)

Trading Cliches

I posted a link to 64 investment cliches yesterday. Someone really needs to write an article about trading blog cliches.

Here's the first example. Basically, begin your writing with some simple analogy that describes extremely general trading behavior. Next, tell people what they are doing wrong. Then, tell them how they can succeed by following some simple idea. Finish up by saying that you must put in lots and lots of time (you know, this simple idea is not going to help you that much).


Rinse and repeat.


PS: I only read the first paragraph of that article.

Cliches

Here we go. 64 cliches:

http://www.forbes.com/sites/ericjackson/2012/06/28/the-64-biggest-investing-cliches-to-sound-like-a-pundit/

PS: Doing my work for me.

Annoying

I find articles like this annoying.

I find comments like the following refreshing:

• Baby Boomer no. 20,500,001 wrote :

Means, medians, and standard deviations can be collected and calculated for any age cohort, no matter which way the baloney is cut, it is still descriptive statistics. What is just as important is the worldview which the writer has. It is a nice article to be sure; and, I bet the author of this article is a younger person, probably post-modern, who reviles generalizations. Have a good day!

Any Good Jokes?

I'm trying to find some good jokes. I figured I'd start with finance jokes. Here's one. It's not good, but a start:

Financial Jokes - How Rockfeller did it
At 18 years old, Rockfeller had no money. He found an apple in the street. The fruit was dirty he cleaned it and resold it 50 cents to a man walking in the street ... with his 50 cents he bought 2 apples 25 cents each, and resold them 1$ to another man walking in the street ... with his 1 dollar he bought 4 apples, and resold them of course 2$ ... at 19 years he inherited from his grandmother...

Search

Getting frustrated with trying to find the perfect word combination to locate desired web pages (should they even exist) on Google search, I decided to amp up my search skills and knowledge. Personally, I would like to be able to search based on many, many factors. Can Google determine whether a particular page is academic?, perhaps through a rudimentary analysis of its sentence structure? Can it let me choose my own set of sites I believe to be the most trustworthy and informative?

There seem to be so few additional search parameters on Google's advanced search page. Maybe I am missing some additional advanced, advanced search page, which is why I am trying to find sites like this: 101 tips and tricks for Google search. Yeah, it still leaves something to be desired. I'm hoping I find more solid pages in my search for better search. Someday I would like to pinpoint desired results much faster, easier, and accurately.

In any case, for those of you who have tried multiple terms, phrases, and permutations while searching for desired information, there is still quite a bit of room for improvement in the search market.