07-17-2006, 08:59 PM
I need some master excel Guru to help me create my Stock Market XLS doc.
This is what I have right now: Stock2
Basically just my Portfolio...
Basically, what I want is for my "Portfolio" sheet to automatically update. To both my Buys and Sells(which hasn't been made yet)
The way I see it, would be to just use
To count how many times I've bought, and just multiply that number by 15000 on the [Total Paid] column. However, times when I buy stocks for 16 np per share, will throw everything off..
___
So I'm wondering if it's possible to instead:
Use a Search code to find all "AAVL" and looking to the column to the RIGHT of it to find a value(what is was bought @)
Thats all for now.. Once I get that figured out, I'll probably post one about Graphs
*And don't tell me to use the Neodaq one. I don't like the "refresh" key, and theres lots of useless junk that I don't need. And theres zero flexibilty in it
This is what I have right now: Stock2
Basically just my Portfolio...
Basically, what I want is for my "Portfolio" sheet to automatically update. To both my Buys and Sells(which hasn't been made yet)
The way I see it, would be to just use
Code:
=COUNTIF(Buy!D:D,"AAVL")To count how many times I've bought, and just multiply that number by 15000 on the [Total Paid] column. However, times when I buy stocks for 16 np per share, will throw everything off..
___
So I'm wondering if it's possible to instead:
Use a Search code to find all "AAVL" and looking to the column to the RIGHT of it to find a value(what is was bought @)
Thats all for now.. Once I get that figured out, I'll probably post one about Graphs
*And don't tell me to use the Neodaq one. I don't like the "refresh" key, and theres lots of useless junk that I don't need. And theres zero flexibilty in it