Patricknyc 0 Posted April 1, 2021 Share Posted April 1, 2021 Hey guys, I’m looking for quick and easy spread sheets. I tried to do it Evernote, and it was quick and easy. I’ll be using the spreadsheet to record stock trades. So I’d like to know if it’s possible to add a little more spreadsheet like functions. So when I add a symbol I’d like it to pull the name of the company from yahoo finance. When I manually add the amount of shares I’ve purchased and the entry price, I’d like the cost basis cell to multiply the shares by the entry price. When I manually add the exit price, I’d like the earnings cell to display the the difference between the entry price and the exit price and then calculate calculate the percentage in another cel. I’ve been up all nite so in case this seems like rambling, I’ll post a link to my draft spreadsheet Trading spreadsheet so you can have an idea. Is this too much of a reach? Should I just use Numbers or Excel or this something I can do with Evernote? Link to comment
Level 5* DTLow 5,743 Posted April 2, 2021 Level 5* Share Posted April 2, 2021 On 4/1/2021 at 4:16 AM, Patricknyc said: So I’d like to know if it’s possible to add a little more spreadsheet like functions. A spreadsheet sounds like a good solution, but you should be looking at a spreadsheet application (Excel, Numbers) The document could be stored in Evernote as a file attachment 2 Link to comment
Level 5* gazumped 12,021 Posted April 3, 2021 Level 5* Share Posted April 3, 2021 ..Or you could look at Airtable which is both a relational database and a spreadsheet... (and has a 'free' level...) Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now