Solve problem with an app that uses google sheet on my blog of blogger
€30-250 EUR
Closed
Posted over 6 years ago
€30-250 EUR
Paid on delivery
I have a blog about finance and investing. I also made an app on it. Imagine the user is reading my blog in blogger and he wants some financial data about Siemens shares. So far, within a static page of the blog I made a little form so that he should type two codes: 1) the ticker of Siemens in google finance (which is ETR: SIE) and the ticker used in morningstar web site (which is SMAWF). With those tickers, I take the data in html, send it to a script in javascript that resends it to a googlespreadsheet, and there, I make some calculations. Finally, the results are sent to the blog web site very easily by publishing it as an embebed table in it.
The 3 problems I want to solve are:
1) I do not want the user to introduce the ticker from google finance and the ticker of morningstar. I would like him to introduce just the one from google, or the name of the company. However, I do not find the relationsheep between google code and morningstar one (in the NYSE or NASdaq yes, but not in other markets). Basically, so far the user has to look on google what are those tickers manually, and this is not very professional.
2) All calculations are fast enough (2-5 seconds). Google sheet is updated very fast when the user introduce a new input (the tickers of another second or third company), however, it takes about 2-3 minutes for google to refresh the embebed result in the blog web site, regardless if I refresh the page with F5. According to google forums on the internet, we cannot reduce that time but I hope it is not true. If it is true, the only solution would be to take the results from the google sheet and make a script to send them to the blog, but including a beautiful format and so on. and the last possibility is not to use google sheets at all, and make all the calculations programming somehere else, but that would be too difficult.
3) The third think is easier is someone knows javascript. It would consist on automatize the following process that now is manual: user make a payment online to subscribe to the service - user have acess to a new static web page auto-created for him in my blog using a password - a google sheet and script are also auto-created for him so that the service is available for him (so far, I have to create one file of each type for each user, otherwise, they will share the same google sheet sharing data of different companies and it would be a chaos) - The service is no more available if he do not pay again next month.
As far as I have few cilents, regarding problem 3, I can manage myself manually giving them access one by one, and creating a new static site in my blog for each of them as well as the google sheet and javascript file specifically for each of them, so the problem 1 and 2 are the most important and urgent right now. 80% of what I pay woud be steps 1 and 2. Step 3 could be re-negotiated later on.
Hi
i can work for Solve problem with an app that uses google sheet on my blog of blogger
So send me Private message at PMB so we can discuss more about it
Thanks
Relevant Skills and Experience
i am expert at ,HTML,Javascript,PHP,Software Architecture,WordPress
Proposed Milestones
€144 EUR - Milestone
Hello There,
I have read your message.
I can do this job very well. I have done several systems along with mobile apps for the mobile device.
Relevant Skills and Experience
We have an Expertise:-
CMS:- Wordpress, Drupal, Joomla
Frameworks:- Laravel, CodeIgniter, CakePHP, Zend
Mobile Applications:- Android, iOS
Programming:- PHP, MySQL
Web Designing:- HTML5, jQuery
Proposed Milestones
€277 EUR - default
If you'd like to view my previous more work, take a look at my Freelancer Portfolios.
If you are interested please contact me.
Thanks!