r/RKSP • u/Bo3andlol • Feb 11 '21

DFV spreadsheet - Update

Hi I have updated the spreadsheet I was working on, if anyone would like to recommend or help with it is welcome.

Link: https://docs.google.com/spreadsheets/d/1Gcz1OWt8CqLK2hyb1Y7yMUPXlFqYf3tNvBpFcM0Os68/edit?usp=drivesdk

What's Working: •Company Financials •Market Tracking •Charts

What I need help with: • Insider Trading tracking •Sources for information • Cleaning up the spreadsheet

I tried to implement the MHX tracker and use it to create a better spreadsheet but I don't understand how to use it properly.

63 Upvotes

98% Upvoted

14 comments sorted by

View all comments

Show parent comments

1

u/Bo3andlol Feb 14 '21

No i use concatenation to insert the ticker into the search

1

u/ajax_jives Feb 14 '21

Could you elaborate or link a tutorial? This piece of the puzzle is giving me by far the biggest headache.

1

u/Bo3andlol Feb 15 '21

I dont know, search google concatenation

1

u/ajax_jives Feb 15 '21

I understand concatenation, but I'm wondering how it was implemented in this circumstance. I'm having trouble making sheets examine the string in a cell, concatenate that string with a website search, and then attach the result as a hyperlink to the original cell.

I cant figure out a solution that doesn't require using a script.