Posted January 26, 2019 So hi I'm new to excel scripting and I am facing a pretty tough nut to crack due to my friend begging me to help him with a economics task so basically they have to use historical data from 2018 to purchase stocks and they have to have maximum profit the one with the most profit gets an A , they have about 100k USD at the start and if my intel is good one of the best guys in his class whos doing it manually earned about a million so I think that with excel I could maybe earn 3-4 million and win the game , my idea was to ask my friend to send the data they've received in an Excel file and use a vba script to compare the delta beetwen 1-2 days worth of info and buy every 1-2 days to maximise profit , is it doable?The second idea I had was to use relationships in access but im pretty green when it comes to that . Is such a comparison doable? Link to comment Share on other sites More sharing options... Link to post Share on other sites More sharing options...
Posted January 26, 2019 A) what your doing is cheating since you're doing your friends homework for you. and B) we generally dont help with school assignments. Community Standards | Fan Control Software Please make sure to Quote me or @ me to see your reply! Just because I am a Moderator does not mean I am always right. Please fact check me and verify my answer. "Black Out" Ryzen 9 5900x | Full Custom Water Loop | Asus Crosshair VIII Hero (Wi-Fi) | RTX 3090 Founders | Ballistix 32gb 16-18-18-36 3600mhz 1tb Samsung 970 Evo | 2x 2tb Crucial MX500 SSD | Fractal Design Meshify S2 | Corsair HX1200 PSU Dedicated Streaming Rig Ryzen 7 3700x | Asus B450-F Strix | 16gb Gskill Flare X 3200mhz | Corsair RM550x PSU | Asus Strix GTX1070 | 250gb 860 Evo m.2 Phanteks P300A | Elgato HD60 Pro | Avermedia Live Gamer Duo | Avermedia 4k GC573 Capture Card Link to comment Share on other sites More sharing options... Link to post Share on other sites More sharing options...
Posted January 26, 2019 If the school find out, you could get expelled but if you're international student you're fine. I don't think it wise for anyone on forums to help on your assignment, you never going to learn unless you do/try it yourself first. The best we could do check script for mistakes etc. Magical Pineapples
