Forum Discussion
Trading stock data model question
Hey there, I'm managing a small stock portfolio in Excel. I had a blast doing a lot of analysis using Power Query, but recently i've discovered an issue that made me think the data model i'm using i...
Jimmy, i did differently actually. I had to redo almost everything and restart from scratch which allowed to clean a lot of things.
What i did was to create an index in both tables and set the relationship on it instead of the stock name (pretty basic when i look back at it).
Thanks for the help anyway !
Hi Etip,
I´m trying to build something similar in excel but I'm a extremely beginner in Power query.. think you could share your file to grap an idea for my report?
I´d really appreciate it