Can Unity help me make a stock market App for android using Excel spreadsheets for data

Questions & Answers
1

Hi I was hoping to make some form of a charting application to put on the android market.(a free and a paid version hopefully)
The only catch is i’m not sure what way is best to do this…So far ive found out that I can stream free data from yahoo, using excel. I was hoping Unity could help me develop a way that I could take that excel spreadsheet make some kind of database that would update accordingly for the users selected stocks ie Apple(APPL), by this i mean they’d have a portfolio.
Next I would need some way to take the data and store it, so i can construct a graph, and then use the information to make inidcators like the 20,50,or 200 day moving averages.

I know a little java and C#, but ive been told that learning SQL would be vital to my goal… is there a way around this in Unity, or will i have to be pretty network savy to tackle this challenge

Thanks to anyone that can help

2

I guess you talk about Yahoo’s CSV Stock Quote API? In this case it has nothing to do with excel. A CSV file is just a file with comma / character seperated values. It seems that this API isn’t officially supported by Yahoo since it has some bugs. If you can live with them and with the fact that they may cancel their service at anytime, use it.

To store the data you have all possibilities. You can save them in a custom format in a file or use sqlite to create a local database file (at least i guess it should work on Android as well). You could even use CSV yourself to store the data locally.

So to answer your question: Yes you can use Unity for such an application, but keep in mind those free data services can be closed at any time.