I have created a user column (in this case a field for a Debt/Equity) and would like to manually enter data into this but don't know how.
Much better still would be to extract the D/E figure from the Yahoo data pool, as this would of course eliminate the need to update this manually.
Another nice figure to pull out of the Yahoo data is the Stockscouter rating.
Any hope of implementing this?
rgds
Ruediger

If you created a memo column, then selecting the item, then clicking in the column will bring up an edit box. For more information, please see the custom column tutorial linked from the Home tab in the software.

Many thanks - field entry works like a charm, nice tutorial also.

It occured to me that the Stockscouter rating is a MSN figure probably not available from Yahoo... D/E perhaps?

It is possible to do this via PSM script extensions. Do you have any programming experience, specifically in VBScript?

If so, I could send you a PSM script extension I wrote to extract Yahoo data for a couple of my custom columns. It would require a lot of modification since your dataset is different than my dataset. And, there are some bugs in it, which showed up when I upgraded to Windows 7 from Windows XP, that I've not fixed yet.

Just let me know.

-Don

AFAIK neither of those values is available from the current data service.

@Anatoly: I was afraid this might be the answer. I guess there's a limit as to what you can expect from a freebie data service.

@dgoyette
Thanks for the offer. I've been out of programming for so long I don't really fancy getting involved in scripting right now. So I'll try to limit the number of tracked stocks to a reasonable number (difficult...) and update manually...

Ruediger

You're welcome Ruediger

I too had not done any programming in quite some time when I started digging into PSM scripting at the end of last year. It's been quite a ride and turned out to be much more difficult than I had anticipated.

Could you provide me with web site addresses (URLs) for the pages where you obtain your data, along with the info text for that particular data, such as "Long Term Debt" or whatever? The next time I'm playing with this script, I'll look into what it would take to make it more modular so that specific data collection can be added and removed, thus making it useful to other PSM users like yourself.




I know where you're coming from, which is why I finally dug into PSM scripting. My wife and I track a LOT of stocks and use alarms heavily, so we can jump on good buying opportunities. Some of the data we use is not available in the Yahoo CSV feed (or other feeds) provided in PSM, so we did what you are doing -- going out onto the web, hit each page that had the data we wanted, and then manually enter it, on a daily basis (to update each stock once a week), which was taking way too much time. The only other alternativewas to subscribe to a $100/month service that could provide this data to us.

So, I dove head-first into scripting, since we didn't want to pay Anatoly's hourly rate to create the script for us. Once I finally got it to work 90% of the time, I stopped working on it as it had taken me months of effort and I was getting tired of trying to find the little bugs that only came up once in a while.

Hope you're having a good weekend!

-Don